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 ();
Ïà¹ØÎÊ´ð£º
ÎÒÓжà¸ö±íA B C ½á¹¹ÊÇÒ»ÑùµÄ£¬¶¼ÓÐ2¸ö×Ö¶ÎnameºÍcontent,ÎÒÒªËÑË÷ËùÒÔ±íËùÓÐ×Ö¶ÎÖаüº¬¡°Öйú¡±µÄÄÚÈÝ Õâ¸öSQLÓï¾äÔõôд
ÈçºÎ½«¶à¸ö±íµÄ²éѯ½á¹ûÁ¬³ÉÒ»¸ö±í Õâ¸öSQLÓï¾äÔõôд ±íµÄ½á¹¹ÊÇÒ»ÑùµÄ
ÀýÈç£ ......
DataSetµ¼³öxml Åú´¦Àí(Ñ»·)µÃÔõô´¦Àí
XMLÎļþ
<A>
<B>
<C>
</C>
&nb ......
21cnµÄÓÊÏ䣬ÔÚoutlookÅäÖúó¿ÉÒÔÕý³£ÊÕ·¢Óʼþ£¬¿ÉÊÇÎÒдÔÚC#ÖоͲ»ÐУ¬»»³ÉÆäËüÓÊÏ䣬163ºÜÔç×¢²áµÄ¡£¿ÉÒÔ·¢ËÍ¡£²éÁ˺ܾã¬Ã»ÓÐÕÒµ½ÔÒò£¬Çë¸ßÊÖ°ïæ½â´ð¡£¡£¡£Ð¡µÜ£¬Ð»ÁË¡£¡£´úÂëÈçÏ£º
private void SendMail ......
½ñÌì×öÁËÒ»¸ö´æ´¢¹ý³Ì »·¾³ÊÇSQL2000Êý¾Ý¿â
´óÖÂÈçÏÂ
½¨Á¢ÁÙʱ±í
¶¨ÒåÔ±¹¤Óαê
Ñ»·Ô±¹¤£¨ÊôÓÚ1¸ö¹«Ë¾)
......