private void button1_Click(object sender, EventArgs e)
{
//设置连接路径
string sqlstr = "Data Source = DESKTOP-OLSHFKE; Initial Catalog = MyData; User ID = wuyongzhao ; Password = 123";
//连接数据库
SqlConnection sqlCon = new SqlConnection(sqlstr);
//打开数据库
sqlCon.Open();
//实例化命令
SqlDataAdapter sqlAdp = new SqlDataAdapter("Select* from table1 ", sqlCon);
//实例化数据集
DataSet ds = new DataSet();
//填充数据集
sqlAdp.Fill(ds, "table1");
//在textbox上展示数据
int i = 0;
textBox1.Text = Convert.ToString(ds.Tables["table1"].Rows[i]["员工编号"]);
textBox2.Text = Convert.ToString(ds.Tables["table1"].Rows[i]["员工姓名"]);
textBox3.Text = Convert.ToString(ds.Tables["table1"].Rows[i]["基本工资"]);
textBox4.Text = Convert.ToString(ds.Tables["table1"].Rows[i]["工作评价"]);
}
C#连接读取SQL Server并展关数据
最新推荐文章于 2023-06-16 09:36:56 发布