public 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;