/// <summary>
/// Insert, Update, Delete
/// </summary>
/// <param name="query"></param>
/// <param name="parameter"></param>
/// <returns></returns>
public int ExecuteNonQuery(string query, object[] parameter = null)
{
int data = 0;
using (MySqlConnection conn = DBGetConnection.GetDBConnection())
{
conn.Open();
MySqlCommand cmd = new MySqlCommand(query, conn);
if (parameter != null)
{
string[] listPara = query.Split(' ');
int i = 0;
foreach (string item in listPara)
{
if (item.Contains('@'))
{
cmd.Parameters.AddWithValue(item, parameter[i]);
i++;
}
}
}
data = cmd.ExecuteNonQuery();
conn.Close();
}
return(data);
}
/// <summary>
/// Select
/// </summary>
/// <param name="query"></param>
/// <param name="parameter"></param>
/// <returns></returns>
public DataTable ExecuteQuery(string query, object[] parameter = null)
{
DataTable data = new DataTable();
using (MySqlConnection conn = DBGetConnection.GetDBConnection())
{
try
{
conn.Open();
MySqlCommand cmd = new MySqlCommand(query, conn);
if (parameter != null)
{
string[] listPara = query.Split(' ');
int i = 0;
foreach (string item in listPara)
{
if (item.Contains('@'))
{
cmd.Parameters.AddWithValue(item, parameter[i]);
i++;
}
}
}
MySqlDataAdapter adap = new MySqlDataAdapter(cmd);
try
{
adap.Fill(data);
}
catch (Exception ex)
{
MessageBox.Show("Error : " + ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
conn.Close();
}
catch (Exception ex)
{
MessageBox.Show("Error : " + ex.Message, "Cant connect with database", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
return(data);
}
/// <summary>
/// Get String values from database
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public string GetFieldValues(string query)
{
string mString = null;
using (MySqlConnection conn = DBGetConnection.GetDBConnection())
{
conn.Open();
MySqlCommand cmd = new MySqlCommand(query, conn);
MySqlDataReader reader;
reader = cmd.ExecuteReader();
while (reader.Read())
{
mString = reader.GetValue(0).ToString();
}
reader.Close();
conn.Close();
}
return(mString);
}
