C#连接数据库实现查询功能

界面设置：C#窗体上添加dataGridView1，和一个button按钮。

点击button时dataGridView1上显示数据库查询结果：

asp.net
private void button1_Click(object sender, EventArgs e)
{
//指定Sql Server提供者的连接字符串
string connString = "server=10.106.103.170;database=MyLogon;Trusted_Connection=SSPI";
//建立连接对象
SqlConnection Sqlconn = new SqlConnection(connString);
//打开连接
Sqlconn.Open();
////为上面的连接指定Command对象
SqlCommand thiscommand = Sqlconn.CreateCommand();
thiscommand.CommandText = "select name,password from Table_0424";
thiscommand.Connection = Sqlconn;
////为指定的command对象执行SqlDataAdapter
SqlDataAdapter da = new SqlDataAdapter(thiscommand);
DataTable dt = new DataTable() ;
da.Fill(dt);
dataGridView1.DataSource = dt;
}