定制DataSet

  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;