1.打开Microsoft Visual Stadio2010——新建解决方案——新建Windows窗体程序
2.添加DataGridView控件,Name改为dgvChaXun;
添加Button按钮,双击——
【注:正常编程中应创建类,在类中编写】
private void button1_Click(object sender, EventArgs e)
{
//打开数据库
SqlConnection sqlcnn = new SqlConnection();
string str = "server=.\\sqlexpress;uid=sa;pwd=123;database=AddressBookSystem";
sqlcnn.ConnectionString = str;
sqlcnn.Open();
//实例化Command对象
SqlCommand sqlcmd = new SqlCommand();
sqlcmd.Connection = sqlcnn;
sqlcmd.CommandText = "select * from HAOYOUFL";
sqlcmd.CommandType = CommandType.Text; //sql文本命令
//通过command对象的ExcuteReader方法,创建一个DataReader对象
SqlDataReader sdr = sqlcmd.ExecuteReader();
//实例化DataTable
DataTable dt = new DataTable();
if (sdr.HasRows) //如果DataReader里有行,则加载sdr到DataTable中
{
dt.Load(sdr);
}
dgvChaXun.DataSource = dt;
sdr.Close();
sqlcnn.Close();
}
3.执行查看