No given Value for one or more required parameters

Question

I have a database Oledb. With several textbox and comboboxs. One combobox I have added numbers to selecte from 1,2,3 the Winform works fine but if i change the options to A,B,C I get No value given for one or more required parameter.The oledb / Access file is set to Short text. 

Any idea why this happens?

 

Thanks

 

Answer 1

I created an Array in form load to solve the problem.

 

private void Form1_Load(object sender, EventArgs e)
        {
            string[] Shift = new string[3];

            Shift[0] = "Days";
            Shift[1] = "AfterNoon";
            Shift[2] = "Nights";
            cb_Shift_F1.Items.AddRange(Shift);
        }

 

Answer 2

Can you share the code which gives the error along with the table structure?