MessageBoxConfirmation: "Yes" or "No"

conn.Open();

OleDbCommand comm = new OleDbCommand();

comm.Connection = conn;

connstr = "SELECT COUNT(*) FROM cadastdoc WHERE [noficio] = @noficio";

comm.CommandText = connstr;

comm.Parameters.Clear();

comm.Parameters.AddWithValue("@noficio", txtNOficioCadastDoc.Text);

int numRecords = (int)comm.ExecuteScalar();

if (numRecords == 0)

{

connstr = "INSERT INTO cadastdoc([nregisto],[procedencia],[assunto],[noficio],[data],[hora],[area_destino],[anexo])VALUES(@nregisto,@procedencia,@assunto,@noficio,@data,@hora,@area_destino,@anexo)";

comm.CommandText = connstr;

comm.Parameters.Clear();

comm.Parameters.AddWithValue("@nregisto", lblNregisto.Text);

comm.Parameters.AddWithValue("@procedencia", txtProcedenciaCadastDoc.Text);

comm.Parameters.AddWithValue("@assunto", txtAssuntoCadastDoc.Text);

comm.Parameters.AddWithValue("@noficio", txtNOficioCadastDoc.Text);

comm.Parameters.AddWithValue("@data", dtCadastDoc.Text);

comm.Parameters.AddWithValue("@hora", txtHoraCadastDoc.Text);

comm.Parameters.AddWithValue("@area_destino", cbxAreaDestinoCadastDoc.Text);

comm.Parameters.AddWithValue("@anexo", "1");

comm.ExecuteNonQuery();

MessageBox.Show("Saved ..");

///////////////////////////////////////refresh datagrid

//conn.Open();

OleDbCommand cmd = conn.CreateCommand();

cmd.CommandType = CommandType.Text;

cmd.CommandText = "select [nregisto],[procedencia],[assunto],[noficio],[data],[hora],[area_destino] from cadastdoc";

cmd.ExecuteNonQuery();

DataTable dt = new DataTable();

OleDbDataAdapter da = new OleDbDataAdapter(cmd);

da.Fill(dt);

//conn.Close();

dvgCadastramentoDoc.DataSource = dt;

dvgCadastramentoDoc.CurrentCell = dvgCadastramentoDoc.Rows[dvgCadastramentoDoc.Rows.Count - 2].Cells[0];

}

else

{

MessageBox.Show("Already exist", txtNOficioCadastDoc.Text);

}

conn.Close();