private void button2_Click(object sender, EventArgs e)// 从数据库中读
取数据并显示在RichTextBox
{
string connString;
connString = "Data Source=GONGXIAOPAN-PC;Initial
Catalog=StuInfoSystem;Integrated Security=True";//连接数据库字符串
//SqlConnection conn = new SqlConnection();
//conn.ConnectionString = connString;
SqlConnection conn = new SqlConnection(connString);
conn.Open();
string sqlQuery = "select StuName from StuInfoTable ";
SqlCommand cmd = new SqlCommand(sqlQuery, conn);//创
建数据库操作命令
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
richTextBox1.Text += dr["StuName"].ToString() + "\n";
}
conn.Close();
//Response.Write("");
}