Deleting record

Hello Mfwamba,



question does the record exists in the database with that particular code value which your giving ?

And can you also try in this way as giving the parameter name and valueto gether:
SqlParameter code = new SqlParameter("@cod", txtcode.Text);
try
{
SqlConnection conn = new SqlConnection(connstr);
SqlCommand comm = new SqlCommand();
conn.Open();
SqlParameter code = new SqlParameter("@cod", SqlDbType.NChar);
SqlParameter product = new SqlParameter("@prod", SqlDbType.VarChar);
SqlParameter price = new SqlParameter("@price", SqlDbType.NChar);
comm.Parameters.Add(code);
comm.Parameters.Add(product);
comm.Parameters.Add(price);
code.Value = txtcode.Text;
product.Value = txtproduct.Text;
price.Value = txtprice.Text;
comm.Connection = conn;
comm.CommandText = @"DELETE FROM company WHERE code=@cod";

comm.ExecuteNonQuery();
MessageBox.Show("Deleted!");
}
catch (Exception)
{
MessageBox.Show("Not deleted");
}
finally
{
conn.Close();
}

When you're using parameters you don't need or want to use single quotes to specify string values. So try changing this line:

comm.CommandText = @"DELETE FROM company WHERE code='@cod'";

to this:

comm.CommandText = @"DELETE FROM company WHERE code=@cod";