.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);