为Select设置查询蚕食

代码

protected void Button3_Click(object sender, EventArgs e) { var cn = new SqlConnection(); cn.ConnectionString = @"Data Source=./SQLEXPRESS;AttachDbFilename=|DataDirectory|Student.Mdf;Integrated Security=True;User Instance=True"; var cmd = new SqlCommand(); cmd.Connection = cn; cmd.CommandText = "select * from student where StudentID =@StudentID "; cmd.Parameters.AddWithValue("@StudentID", TextBox1.Text); cn.Open(); var dr = cmd.ExecuteReader(); if (dr.HasRows) { while (dr.Read()) { TextBox2.Text = dr["StudentName"].ToString(); } } dr.Close(); cn.Close(); }

 

 

 

 

页面：