案例代码
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;
namespace sqlDataReader
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
private void sqlDataReader()
{
//1.构造连接字符串的方法
SqlConnectionStringBuilder connStr = new SqlConnectionStringBuilder();
connStr.DataSource = "192.168.1.20";
connStr.InitialCatalog = "mshDB_Debug";
connStr.UserID = "developer";
connStr.Password = "developer";
connStr.Pooling = true;
connStr.MaxPoolSize = 1000;
connStr.MinPoolSize = 1;
//2.创建Connection对象
SqlConnection conn = new SqlConnection(connStr.ToString());
//3.拼接SQL语句
StringBuilder strSql = new StringBuilder();
strSql.Append("select * from tb_Customer");
//4.创建Command对象
SqlCommand cmd = new SqlCommand(strSql.ToString(), conn);
cmd.CommandType = CommandType.Text;
try
{
//创建SqlDataReader对象
conn.Open();
SqlDataReader reader = cmd.ExecuteReader();
//获取当前结果集的架构信息
DataTable schemaTable = reader.GetSchemaTable();
//绑定数据视图控件
dataGridView1.DataSource = schemaTable;
//reader.Close();
}
catch(Exception e)
{
}
finally
{
conn.Close();
conn.Dispose();
}
}
private void btn1_Click(object sender, EventArgs e)
{
this.sqlDataReader();
}
}
}
运行结果,如下: