初谈ADO.NET中利用DataAdapter进行数据操作

{

InitializeComponent();

myCon = new SqlConnection("Data Source=localhost\\SQLEXPRESS;Initial Catalog=Shop;Persist Security Info=True;User ID=sa;Password= ");

myAda = new SqlDataAdapter();

myCmd = new SqlCommand("select * from Userinfo",myCon);

myAda.SelectCommand = myCmd;

myCbd = new SqlCommandBuilder(myAda);

mySet = new DataSet();

myAda.TableMappings.Add("UserInfo", "UserInfo");

myAda.TableMappings[0].ColumnMappings.Add("UserID", "用户");

myAda.TableMappings[0].ColumnMappings.Add("UserName", "用户姓名");

myAda.TableMappings[0].ColumnMappings.Add("UserAge", "年龄");

myAda.TableMappings[0].ColumnMappings.Add("UserSex", "性别");

myAda.TableMappings[0].ColumnMappings.Add("UserAddress", "地址");

}

private void Form3_Load(object sender, EventArgs e)

{

try

{