C#插入SQL数据库

        string strconn = "server=.;User Id=sa;Password=sa;database=数据库名;integrated security=true";
        SqlConnection conn = new SqlConnection(strconn);
        conn.Open();

        string sqlstr = "insert into table1(item1,item2,item3) values('1','2','3')";
        SqlCommand cmd = new SqlCommand(sqlstr, conn);
        cmd.EndExecuteNonQuery();
        conn.Close();

转载于:https://www.cnblogs.com/2010-6-5/archive/2010/06/21/1762108.html