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);
}
