private System.Data.SqlClient.SqlConnection myConnection;
private System.Data.SqlClient.SqlCommand myCommand;
private System.Data.DataSet myDataSet;
private System.Data.SqlClient.SqlDataAdapter myDataAdapter;
//创建连接对象并打开它
string connectionString="server=.;uid=sa;pwd=;database=northwind";
myConnection = new System.Data.SqlClient.SqlConnection(connectionString);
myConnection.Open();
//创建DataSet,并设置其性质
myDataSet=new System.Data.DataSet();
myDataSet.CaseSensitive=true;
//创建sqlCommand对象并赋值给它连接对象及select语句
myCommand=new System.Data.SqlClient.SqlCommand();
myCommand.Connection=myConnection;
myCommand.CommandText="select * from Customers";
//创建DataAdapter对象并传入SqlCommand对象,并创建表影射
myDataAdapter=new System.Data.SqlClient.SqlDataAdapter();
myDataAdapter.SelectCommand=myCommand;
myDataAdapter.TableMappings.Add("Table","Customers");
myDataAdapter.Fill(myDataSet);
customersDataGrid.DataSource=myDataSet.Tables["Customers"].DefaultView;