七、 强类型DataSet(向导创建)
1. 创建DataSet
2. 数据读取
A. 使用弱类型DataAdapter,手写SQL
using (SqlConnection conn = new SqlConnection(
"Data Source=localhost;Initial Catalog=SettingKnowledgeManagement;Integrated Security=True"))
{
UserDataSet userSet = new UserDataSet();
SqlDataAdapter adapter = new SqlDataAdapter(
"SELECT * FROM tb_user;",
conn);
adapter.Fill(userSet.tb_User);
foreach (UserDataSet.tb_UserRow userRow in userSet.tb_User)
{
Console.WriteLine(userRow.Username);
Console.WriteLine(userRow.password);
Console.WriteLine();
}
}
B. 使用强类型生成的程序
// GetData() 方法
tb_UserTableAdapter adapter = new tb_UserTableAdapter();
foreach (UserDataSet.tb_UserRow row in adapter.GetData())
{
Console.WriteLine(row.Username);
Console.WriteLine(row.password);
Console.WriteLine();
}
// Fill() 方法
UserDataSet dataSet = new UserDataSet();
adapter.Fill(dataSet.tb_User);
foreach (UserDataSet.tb_UserRow row in dataSet.tb_User)
{
Console.WriteLine(row.Username);
Console.WriteLine(row.password);
Console.WriteLine();
}
3. 数据更新
tb_UserTableAdapter adapter = new tb_UserTableAdapter();
adapter.InsertUser("new user", "nnnnnn");
adapter.UpdateUser("password", "new user");
adapter.DeleteUser("new user");