So I want to delete a record from my mysql database but the code isn't deleting it. I'm working in 3 tier architecture
Here is the code
DataLayer code :
public int Delete(int DBID)
{
var returnValue = 0;
using (MySqlConnection conn = new MySqlConnection(connection))
{
using (MySqlCommand cmd = new MySqlCommand("deletdb", conn))
{
cmd.CommandType = CommandType.StoredProcedure;
MySqlParameter parameter = new MySqlParameter("@db", MySqlDbType.Int32);
parameter.Value = DBID;
cmd.Parameters.Add(parameter);
conn.Open();
returnValue = cmd.ExecuteNonQuery();
conn.Close();
}
}
return returnValue;
}
Business Layer
public int Delete(int DBID)
{
// your businees logic, calculations or validations may go here
return new dlHelper().Delete(DBID);
}
Default.aspx.cs
prote ...
Go to the complete details ...