Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

C#ºÍÊý¾Ý¿âSQL - MS-SQL Server / »ù´¡Àà

ÎÒÃÇC#×öÒ»¸ö´°Ìå ÍùÊý¾Ý¿âÀï²åÈëÊý¾Ý
  SqlConnection cn = new SqlConnection("Data Source=20090713-1752\\SQLEXPRESS;Initial Catalog=goods;Integrated Security=True");
  cn.Open();

  SqlDataAdapter da = new SqlDataAdapter("insert into goods values('" + textBox1.Text + "','" + textBox2.Text + "','" + textBox3.Text + "')", cn);
  DataSet ds=new DataSet ();
  da.Fill(ds, "goods");
   
  MessageBox.Show("OK");
  cn.Close();


Ö»ÓÐÒ»¸ö±í id name num£¨ÊýÁ¿£©¡£¡£¡£¡£ÏÖÔÚÿ²åÈëÒ»ÐоÍÏÔʾһÐУ¬£¬£¬£¬¼ÙÈôÎÒÏȲåÈë1 ÂøÍ· 20£¬ È»ºóÔÙ²åÈë 1 ÂøÍ· 11 £¬ ÈçºÎÈÃʹÆäÏÔʾһÐÐ 1 ÂøÍ· 31 °¡
²»Ã÷°×£¡

s

ÕâÑùµÄ»°,ÓÃÂ¥Ö÷µÄ±àÂ뷽ʽֱ½ÓÏÔʾ½á¹ûµÄ»°,ÓеãÀ§ÄÑ.Ó¦µ±°É²åÈëºÍÏÔʾ·Ö2¸ö²¿·Ö.²åÈëÊÇÒ»ÌõÒ»ÌõµÄ²åÈë,µ«ÊÇÏÔʾµÄ»°,ÐèÒªÁíÒ»¸ö·½·¨.
SqlConnection cn = new SqlConnection("Data Source=20090713-1752\\SQLEXPRESS;Initial Catalog=goods;Integrated Security=True"); 
  cn.Open(); 

  SqlDataAdapter da = new SqlDataAdapter("insert into goods values('" + textBox1.Text + "','" + textBox2.Text + "','" + textBox3.Text + "')\n select id, [name], sum([sum]) as [sum]", cn); 
  DataSet ds=new DataSet (); 


Ïà¹ØÎÊ´ð£º

sqlÓï¾ä¶à±í¶à×ֶβéѯ - MS-SQL Server / »ù´¡Àà

ÎÒÓжà¸ö±íA B C ½á¹¹ÊÇÒ»ÑùµÄ£¬¶¼ÓÐ2¸ö×Ö¶ÎnameºÍcontent,ÎÒÒªËÑË÷ËùÒÔ±íËùÓÐ×Ö¶ÎÖаüº¬¡°Öйú¡±µÄÄÚÈÝ Õâ¸öSQLÓï¾äÔõôд 

ÈçºÎ½«¶à¸ö±íµÄ²éѯ½á¹ûÁ¬³ÉÒ»¸ö±í Õâ¸öSQLÓï¾äÔõôд ±íµÄ½á¹¹ÊÇÒ»ÑùµÄ
ÀýÈç£ ......

jspÁ´½Ósql2000µÄÒÉÎÊ£¿



type Exception report


message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

org.apache.jas ......

C# DataSetµ¼³öxml Åú´¦Àí(Ñ­»·)µÃÔõô´¦Àí

DataSetµ¼³öxml Åú´¦Àí(Ñ­»·)µÃÔõô´¦Àí
XMLÎļþ
<A>
      <B>
        <C>
        </C>
  &nb ......

sql ËÑË÷Óï¾ä - .NET¼¼Êõ / ASP.NET

<table style="width: 1000px"><tr>
  <td style="height: 38px; width: 35px;">
  ÐÕÃû</td>
  ......

sqlССµÄÒÉÎÊ - .NET¼¼Êõ / C#

¿ÉÄÜÒòΪ¹¤×÷µÄÔ­Òò ½Ó´¥Êý¾Ý¿âÕâ¿é±È½ÏÉÙ£¬Ö®Ç°¶¼ÊÇ×ö³ÌÐòÕâ¿é£¬Êý¾Ý¿âÕâ¿é¶¼ÓÐרÃŵÄÈËÀ´×ö ·Ö¹¤¶¼ºÜÃ÷ϸ ËùÒÔ¶ÔÊý¾Ý¿âÕâÒ»¿éÍêÈ«²»Á˽⡣ǰ¶Îʱ¼ä È¥ÃæÊÔÁ˼¸¼Ò¹«Ë¾ ¼¸ºõ¶¼ÊÇÔÚÊý¾Ý¿âÕâ¿é¹ÒµôµÄ Á¬¸ö¼òµ¥µÄSQ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ