public string GetDataThang(ref DataTable tbl, string SPname) { try { clsDatabase cls = new clsDatabase(); cls.OpenConnect(); string[] Values = new string[] { Convert.ToString(thang), Convert.ToString(nam) }; if (ParasThang.Length != Values.Length) { return("Tham bien va tham tri khong tuong thich"); } else { cls.getValue(ref tbl, SPname, ParasThang, Values); } cls.CloseConnect(); } catch (Exception ex) { error = ex.ToString(); MessageBox.Show("Co loi " + ex.Message); } return(error); }
private string Execute(ref string records, string StoreProcedureName) { try { clsDatabase cls = new clsDatabase(); cls.OpenConnect(); string[] Values = new string[] { Taikhoan, Matkhau, Quyen }; if (Paras.Length != Values.Length) { return("Tham bien va tham tri khong tuong thich"); } else { cls.ExecuteSP(StoreProcedureName, Paras, Values, ref records); } cls.CloseConnect(); } catch (Exception ex) { error = ex.ToString(); MessageBox.Show("Co loi " + ex.Message); } return(error); }