I pasting here for basic insert operation using mysql db
public static string AddAusSururb()
{
string connstr = @"server=" + GetAppSetting(AppSettings.serverName) + ";database=" + GetAppSetting(AppSettings.databaseName) + ";userid=" + GetAppSetting(AppSettings.userID) + ";password=" + GetAppSetting(AppSettings.dbPassword) + ";CHARSET=" + GetAppSetting(AppSettings.AcceptCharset) + ";convert zero datetime=" + GetAppSetting(AppSettings.convertDatetime) + "";
MySqlConnection conn = null;
MySqlDataReader rdr = null;
string status = string.Empty;
try
{
string stm = "SELECT Id FROM aussuburb ORDER BY Id DESC LIMIT 1;";
var sql = "INSERT INTO aussuburb(Id, Postcode, Suburb, State)VALUES(@ID,@Postcode,@Suburb,@State);";
conn = new MySqlConnection(connstr);
conn.Open();
MySqlCommand cmd = new MySqlCommand();
cmd.Connection = conn;
cmd.CommandText = stm;
int LastID = Convert.ToInt32(cmd.ExecuteScalar());
cmd.CommandText = sql;
cmd.Prepare();
cmd.Parameters.AddWithValue("@ID", LastID + 1);
cmd.Parameters.AddWithValue("@Postcode", "TEST");
cmd.Parameters.AddWithValue("@Suburb", "TEST");
cmd.Parameters.AddWithValue("@State", "TEST");
cmd.ExecuteNonQuery();
status = "success";
}
catch (MySqlException ex)
{
status = "failed" + ex.ToString();
}
finally
{
if (rdr != null) { rdr.Close(); }
if (conn != null) { conn.Close(); }
}
return status;
}