public int Ex_DML(string u) { try { int b = d.RunDMLCommand(s, u, "tblqrydetails"); return(b); } catch (Exception ex) { throw new ArgumentException(ex.Message); } }
public DataSet In_Dat() { try { string t, u; DateTime dt = System.DateTime.Now; t = "insert into tblqrydetails(Cus_Name,Cus_Eml_Id,Cus_Con_No,Qry_Text,Qry_Dt) values('" + Cus_Name + "','" + EMl + "','" + Con_No + "','" + QryTxt + "','" + dt + "')"; u = "select Qry_Id from tblqrydetails where Cus_Name='" + Cus_Name + "' and Cus_Eml_Id='" + EMl + "' and Cus_Con_No='" + Con_No + "' and Qry_Text LIKE '" + QryTxt + "' and Qry_Dt='" + dt + "'"; int i = d.RunDMLCommand(s, t, "tblqrydetails"); DataSet j = d.RunDRLCommand(s, u, "tblqrydetails"); return(j); } catch (Exception ex) { throw new ArgumentException(ex.Message); } }