Dataset database issues
-
I have this function:
[WebMethod] public string SetUserInfo(string AuthID, DataSet dg2) { if (AuthID=="********") { Oconn.Open(); da.Update(dg2); Oconn.Close(); return "it seems to have worked."; } else { return "Your Authentication Failed"; } }and this is my da (dataAdapter) var:public SqlDataAdapter da = new SqlDataAdapter();but it keeps coming back with an error: "Update unable to find TableMapping['Table'] or DataTable 'Table'" http://digg.com -
I have this function:
[WebMethod] public string SetUserInfo(string AuthID, DataSet dg2) { if (AuthID=="********") { Oconn.Open(); da.Update(dg2); Oconn.Close(); return "it seems to have worked."; } else { return "Your Authentication Failed"; } }and this is my da (dataAdapter) var:public SqlDataAdapter da = new SqlDataAdapter();but it keeps coming back with an error: "Update unable to find TableMapping['Table'] or DataTable 'Table'" http://digg.comYou should supply a DataTable named as Table in WebService function inputs(DataSet dg2)
-
I have this function:
[WebMethod] public string SetUserInfo(string AuthID, DataSet dg2) { if (AuthID=="********") { Oconn.Open(); da.Update(dg2); Oconn.Close(); return "it seems to have worked."; } else { return "Your Authentication Failed"; } }and this is my da (dataAdapter) var:public SqlDataAdapter da = new SqlDataAdapter();but it keeps coming back with an error: "Update unable to find TableMapping['Table'] or DataTable 'Table'" http://digg.compublic string SetUserInfo(string AuthID, DataSet dg2) { if (AuthID=="********") { Oconn.Open(); string connection = "server = localhost;database=urdatabase;uid=urid;pwd=urpswd"; string updatedata = "update urtable set AuthID = " + " '" + this.textbox1.text + "where AuthID = "********"; SqlConenction conn = new SqlConnection(connection ); SqlCommad cmdupdate = new SqlCommad(updatedata ,conn); da.Fill(udataset,"urtable"); Oconn.Close(); } else { return "Your Authentication Failed"; } } Maybe this helps u Regards;