logo资料库

从数据库中读取数据并显示在RichTextBox.doc

第1页 / 共1页
资料共1页,全文预览结束
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(""); }
分享到:
收藏