一、先进入sqlserver2008R2 创建一个数据库student
二、在student数据库下创建数据表Student
三、进入vs2013新建一个项目,创建一个form窗体,拖一个BUTTON 按钮、拖一个dataGridView用于显示数据表
四、双击BUTTON按钮
private void button1_Click(object sender, EventArgs e)
{
string con,sql;
con = "server=.;Database = student;user id = sa; password = 123";
sql ="select * from student";
SqlConnection mycon = new SqlConnection(con);
mycon.Open();
SqlDataAdapter myda = new SqlDataAdapter(sql,con);
DataSet myds = new DataSet();
myda.Fill(myds,"student");
dataGridView1.DataSource = myds.Tables["student"];
mycon.Close();
二、在student数据库下创建数据表Student
三、进入vs2013新建一个项目,创建一个form窗体,拖一个BUTTON 按钮、拖一个dataGridView用于显示数据表
四、双击BUTTON按钮
private void button1_Click(object sender, EventArgs e)
{
string con,sql;
con = "server=.;Database = student;user id = sa; password = 123";
sql ="select * from student";
SqlConnection mycon = new SqlConnection(con);
mycon.Open();
SqlDataAdapter myda = new SqlDataAdapter(sql,con);
DataSet myds = new DataSet();
myda.Fill(myds,"student");
dataGridView1.DataSource = myds.Tables["student"];
mycon.Close();
按启动键运行程序
结果显示如下: