.netÁ¬½ÓÊý¾Ý¿â£¬Ö´ÐÐsql½Å±¾

1¡¢¶¨ÒåÖ¸Á£ºusing System.Data.SqlClient;
2¡¢¶¨ÒåsqlÁ¬½Ó£º SqlConnection conn= new SqlConnection("server=(local);database=colorring;uid=sa;pwd=;");
3¡¢´ò¿ªsqlÁ¬½Ó£º conn.Open();
4¡¢¶¨ÒåsqlÓï¾ä£ºstring sqlstr = "insert into test values (123321)";
5¡¢×é×°sqlÓï¾äºÍÁ¬½Ó£ºSqlCommand cmd = new SqlCommand(sqlstr,conn);
6¡¢Ö´ÐÐsqlÃüÁint result=cmd.ExecuteNonQuery();
7¡¢¹Ø±ÕsqlÁ¬½Ó£ºconn.Close();
8¡¢ÏÔʾ¸üеÄÊýÁ¿£º  Label1.Text =Convert.ToString(result);
´úÂëÈçÏ£º
        using System.Data.SqlClient;
        SqlConnection conn= new SqlConnection("server=(local);database=colorring;uid=sa;pwd=;");
        conn.Open();
        string sqlstr = "insert into test values (123321)";
        SqlCommand cmd = new SqlCommand(sqlstr,conn);
        int result=cmd.ExecuteNonQuery();
        conn.Close();
        Label1.Text =Convert.ToString(result);