C#操作数据库显示Customers数据表第3-7条记录

显示Customers数据表第3-7条记录，C#操作数据库显示Customers数据表第3-7条记录，其实做出来例子，才知道，很简单啊，不过需要把数据库先连接好，看如下代码： 　　private void button1_Click(object sender, EventArgs e) 　　 {//显示Customers数据表第3-7条记录 　　 SqlConnection MyConnection=new SqlConnection(); 　　 MyConnection.ConnectionString = @"Data Source =.SQLEXPRESS;Initial Catalog=Northwind;Integrated Security=True"; 　　 MyConnection.Open(); 　　 SqlCommand MyCommand =new SqlCommand("Select * From Customers ORDER BY CustomerID", MyConnection); 　　 DataSet MySet = new DataSet(); 　　 SqlDataAdapter MyAdapter = new SqlDataAdapter(MyCommand); 　　 MyAdapter.Fill(MySet, 2, 5, "Customers"); 　　 this.dataGridView1.DataSource=MySet.Tables["Customers"]; 　　}

srcfans.com
O025
MyForm
bin
Release
MyForm.pdb
O025
O025
MyForm
bin
Release
MyForm.exe
srcfans.com