(3)创建 Command对象,执行一个 INSERT语句,然后使用 ExecuteNonQuery方法将一个记录插入到 StudentInfo表中。 protected void Page Load(object sender, EventArgs e) string connString Configuration Manager. Connection Strings["StudentDBConnection String"].ToString(; using( SqlConnection conn= new SqlConnection( conn String)∥创建 Connection对象conn string query String="INSERT INTO StudentInfo"+ "(StudentID, StudentName) Values(200902602035', 'E2 2")" conn Open o Sqlcommand command= new SqlCommand(queryString, conn); Int32 recordsAffected =command. ExecuteNon Queryo Response. Write("插入记录的行数:"+ records Affected) (4)创建 Datareader对象,读取 Student DB数据库 StudentInfo表中 的全部数据 protected void Page Load(object sender, EventArgs e) string connString ConfigurationManager Connection Strings["StudentDBConnectionString"]. ToStringO using(SqlConnection conn =new SqlConnection( connString) string sqlstr="SELECT* FROM StudentInfo Sqlcommand command= new SqlCommand( sqlstr, conn) conn. Open SqlDataReader reader= command. ExecuteReadero while(reader. Reado) Response. Write(reader["StudentID"ToString(+ +( string)reader"StudentName"+""+ reader. Get Value(3).ToString (+ +reader. Get Value(4 ). ToString (+"<br>"); reader. Close O (5)将查询结果在 Grid view控件中显示。 protected void Page Load(object sender, EventArgs e)（3） 创建 Command 对象，执行一个 INSERT 语句，然后使用 ExecuteNonQuery()方法将一个记录插入到 StudentInfo 表中。 protected void Page_Load(object sender, EventArgs e) { string connString = ConfigurationManager.ConnectionStrings["StudentDBConnectionString"].ToString(); using (SqlConnection conn = new SqlConnection(connString)) //创建 Connection 对象 conn { string queryString = "INSERT INTO StudentInfo" + "(StudentID, StudentName) Values('200902602035', '白雪 2')"; conn.Open(); SqlCommand command = new SqlCommand(queryString, conn); Int32 recordsAffected = command.ExecuteNonQuery(); Response.Write("插入记录的行数：" + recordsAffected); } } （4） 创建 DataReader 对象，读取 StudentDB 数据库 StudentInfo 表中 的全部数据。 protected void Page_Load(object sender, EventArgs e) { string connString = ConfigurationManager.ConnectionStrings["StudentDBConnectionString"].ToString(); using (SqlConnection conn = new SqlConnection(connString)) { string sqlstr = "SELECT * FROM StudentInfo"; SqlCommand command= new SqlCommand(sqlstr, conn); conn.Open(); SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { Response.Write(reader["StudentID"].ToString() + " " + (string)reader["StudentName"] + " " + reader.GetValue(3).ToString() + " " + reader.GetValue(4).ToString() + "</br>"); } reader.Close (); } } （5） 将查询结果在 GridView 控件中显示。 protected void Page_Load(object sender, EventArgs e)