Why do I have a missing column in my datagrid view table?

240 views Asked by At

I have a Datagrid view and 1 column is missing even though it is present inside the database

this is my DGV

enter image description here

and this is my table in the database

enter image description here

i am unsure why the model column is missing but I am sure that I did have it inserted in MySQL

here is my code for adding data to the database

 private void button2_Click(object sender, EventArgs e)
 {
     MySqlCommand cmd = new MySqlCommand("insert into inventory.vehicle(platenumber,brand,model,yearmodel,regdate,exdate,odometer) values(@platenumber, @brand, @model,@yearmodel, @regdate, @exdate,@odometer)", conn);

     cmd.Parameters.Add("@platenumber", MySqlDbType.VarChar, 10).Value = pnumber.Text;
     cmd.Parameters.Add("@brand", MySqlDbType.VarChar, 60).Value = brand.Text;
     cmd.Parameters.Add("@model", MySqlDbType.VarChar, 45).Value = model.Text;
     cmd.Parameters.Add("@yearmodel", MySqlDbType.Int32).Value = yearmodel.Text;
     cmd.Parameters.Add("@regdate", MySqlDbType.Date).Value = datereg.MinDate;
     cmd.Parameters.Add("@exdate", MySqlDbType.Date).Value = regexp.MinDate;
     cmd.Parameters.Add("@odometer", MySqlDbType.Decimal).Value = odometer.Text;



     int i = cmd.ExecuteNonQuery();
     if (i != 0)
     {
         MessageBox.Show("Success");
     }
     else
     {
         MessageBox.Show("Fail");
     }

     this.Close();

this is the function that populates my datagrid

 private void PopulateDataGrid()
        {

            MySqlCommand cmd = conn.CreateCommand();
            DataTable datatable = new DataTable();

            cmd.CommandText = "select id,platenumber,brand,model,yearmodel,regdate,exdate,odometer from vehicle";
            cmd.CommandType = CommandType.Text;

            dataAdapter = new MySqlDataAdapter(cmd);
            dataAdapter.Fill(datatable);
            dataGridView1.DataSource = datatable;

        }
0

There are 0 answers