使用SqlDataAdapter问题读取和更新数据
|
我正在寻找一些有关如何最好地使用SqlDataAdapter来访问和更新应用程序中的数据的示例。
现在我有这样的事情：
SqlDataAdapter adapter;
DataSet myData = MyDataAccessClass.GetData(\"Select * from Students\", ref adapter);
// change some data here and save changes
adapter.Update();
DataSet myData = MyDataAccessClass.GetStudents();
// change some data and save changes
MyDataAccessClass.SaveStudents(myData);
没有找到相关结果
已邀请:
2 个回复
炉挤仙挟
public class MyDataAccessClass { private string ConnString; public MyDataAccessClass() { //Get connection string from configuration file } public MyDataAccessClass(string connString) { ConnString = connString; } public DataSet GetAllStudents() { //your SQL Adapter code here... } }public void CreateUpdateStudent(Student student) { //update database }香腔弥胯瓤
SqlConnection con = new SqlConnection(\"Data Source=abcd-pc;Initial Catalog=user_info;Integrated Security=True\"); SqlDataAdapter da = new SqlDataAdapter(); try { da.UpdateCommand = new SqlCommand(\"Update logindemo set password=@pswd where username=@uname\",con); da.UpdateCommand.Parameters.Add(\"@pswd\", SqlDbType.VarChar).Value = txtpass.Text; da.UpdateCommand.Parameters.Add(\"@uname\", SqlDbType.VarChar).Value = txtusername.Text; con.Open(); da.UpdateCommand.ExecuteNonQuery(); Label1.Text = \"Data Updated\"; con.Close(); } catch { Label1.Text = \"Unable To Connect\"; }