public string ExecuteData_string(string sProcName)
{
string dt_ = "";
DataTable dt = new DataTable();
try
{
Open();
global::MySql.Data.MySqlClient.MySqlDataAdapter da = new global::MySql.Data.MySqlClient.MySqlDataAdapter();
cmd.CommandText = sProcName;
da.SelectCommand = cmd;
da.Fill(dt);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
throw ex;
}
finally
{
Close();
}
dt_ = dt.Rows[0][0].ToString();
return(dt_);
}
public int Execute_int(string sProcName)
{
DataTable dt = new DataTable();
int dt_ = 0;
try
{
Open();
global::MySql.Data.MySqlClient.MySqlDataAdapter da = new global::MySql.Data.MySqlClient.MySqlDataAdapter();
cmd.CommandText = sProcName;
da.SelectCommand = cmd;
da.Fill(dt);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
throw ex;
}
finally
{
Close();
}
dt_ = dt.Rows.Count;
return(dt_);
}
public bool ExecuteData_bool(string sProcName)
{
DataTable dt = new DataTable();
try
{
Open();
global::MySql.Data.MySqlClient.MySqlDataAdapter da = new global::MySql.Data.MySqlClient.MySqlDataAdapter();
cmd.CommandText = sProcName;
da.SelectCommand = cmd;
da.Fill(dt);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
throw ex;
}
finally
{
Close();
}
return(true);
}
