dataSet

dataSet是数据库与其他控件的桥梁，所以在绑定前一般都需先得到dataSet对象。 一、非代码方式 1 （1）:（创建数据连接）打开服务器资源管理器，在数据连接项中添加连接。//可以跳过此步，直接到第二步配置数据源 （2）：（添加数据源）选择 数据 菜单中的 添加新数据源 菜单项，弹出数据源配置向导，产生dataset. 二、代码方式          private System.Data.DataSet myDS ;         private System.Data.SqlClient.SqlDataAdapter myAD = null;         private System.Data.SqlClient.SqlCommand myCom = null;         private System.Data.SqlClient.SqlConnection myCon = null;                 string myConStr = "Persist Security Info=false;Initial Catalog=zxw;";                myConStr += "Data Source=localhost;Integrated Security=SSPI;";                myCon = new SqlConnection(myConStr);                 myCon.Open();                 string comStr = "select * from personInf";                 myCom = new SqlCommand(comStr, myCon);                 //myAD = new SqlDataAdapter(myCom);                 myAD = new SqlDataAdapter();                 myAD.SelectCommand = myCom;                 myDS = new DataSet();                 myAD.Fill(myDS, "personInf");//指定填充数据集中的那张表             

               myCom = new SqlCommand(comStr, myCon);                等价于如下三句                 myCom = new SqlCommand();                 myCom.CommandText = comStr;                 myCom.Connection = myCon;

                myCom = new SqlCommand(comStr, myCon);                等价于如下两句                 myAD = new SqlDataAdapter();                 myAD.SelectCommand = myCom;        

BindingSource使用时设置其datasource为某dataset，datamember为dataset中某表。