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