public class SqlHelper

{

public static string GetConnection()

{

string connStr = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;

return connStr;

}

public static int ExecuteNonQuery(string sql, params MySqlParameter[] parameters)

{

int result = -1;

using (MySqlConnection conn = new MySqlConnection(GetConnection()))

{

conn.Open();

using (MySqlCommand cmd = conn.CreateCommand())

{

cmd.CommandText = sql;

cmd.Parameters.AddRange(parameters);

result = cmd.ExecuteNonQuery();

}

}

return result;

}

public static DataTable ExecuteDataTable(string sql, params MySqlParameter[] parameters)

{

using (MySqlConnection conn = new MySqlConnection(GetConnection()))

{

using (MySqlCommand cmd = conn.CreateCommand())

{

cmd.CommandText = sql;

cmd.Parameters.AddRange(parameters);

using (MySqlDataAdapter da = new MySqlDataAdapter(cmd))

{

using (DataSet ds = new DataSet())

{

da.Fill(ds);

return ds.Tables[0];

}

}

}

}

}

}