使用Command对象进行数据库操作
一、插入数据
//引用数据库访问名称空间
using System.Data.SqlClient;
using System.Configuration;
string sqlconnstr = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
SqlConnection sqlconn = new SqlConnection(sqlconnstr);
//建立Command对象
SqlCommand sqlcommand = new SqlCommand();
sqlcommand.Connection = sqlconn;
//把SQL语句赋给Command对象
sqlcommand.CommandText = "insert into student(No,Name,Sex,birthday,Adress,Photo)values (@No,@Name,@Sex,@birthday,@Adress,@Photo)";
sqlcommand.Parameters.AddWithValue("@No",TextBox1.Text);
sqlcommand.Parameters.AddWithValue("@Name",TextBox2.Text);
sqlcommand.Parameters.AddWithValue("@Sex",DropDownList1.Text);
sqlcommand.Parameters.AddWithValue("@birthday",TextBox3.Text);
sqlcommand.Parameters.AddWithValue("@Adress",TextBox4.Text);
sqlcommand.Paramet