1.创建windows窗体程序
为窗体添加2个控件
button和dataGridView
2.将数据源信息编写入app.config
<connectionStrings>
<add name="DBConnect" connectionString="Data Source=ip;Database=库名;User ID=账户;Password=密码"/>
</connectionStrings>
3.代码实现
1.定义成员变量获取app.config文件中的数据源
/// <summary>
/// 从App.config获取数据源
/// </summary>
private static string SqlServerConnString = ConfigurationManager.ConnectionStrings["DBConnect"].ConnectionString;
2.为button添加点击事件并将数据填充到datatable中并显示到dataGridView中
private void button1_Click(object sender, System.EventArgs e)
{
MessageBox.Show("数据源" + SqlServerConnString);
//获取连接
SqlConnection sqlConnection = new SqlConnection(SqlServerConnString);
//打开连接
sqlConnection.Open();
//获取命令行
SqlCommand sqlCommand = sqlConnection.CreateCommand();
//执行sql
sqlCommand.CommandText="SELECT * FROM batch_mean";
//数据库读取类
SqlDataReader sqlDataReader = sqlCommand.ExecuteReader();
//填充数据
DataTable dataTable = new DataTable();
dataTable.Load(sqlDataReader);
dataGridView1.DataSource=dataTable;
//关闭连接
sqlConnection.Close();
}
4.运行测试
点击运行
点击按钮
数据显示在表格中则表示成功