DataGridView in the tabcontrol displays empty rows

Question

Hello,

I have embedded tabcontrol in my windows form.
When filling the datagridview in the tabcontrol, as a parameter I use the value of a textbox which is on the same form but out of the tabcontrol. The rust I get is empty rows in the DataGridView.

Can anybody help me please?
Thanks

Pravin Ghadge · Answer

Hi, try this, private void textBox1_KeyPress(object sender, KeyPressEventArgs e) { if (e.KeyChar == (char)13) { dateTimePicker2.Focus(); DataSet _dataset = new DataSet(); OleDbDataAdapter oleDbAdapter1 = new OleDbDataAdapter(); oleDbAdapter1.SelectCommand = new OleDbCommand(); oleDbAdapter1.SelectCommand.Connection = conn; oleDbAdapter1.SelectCommand.CommandText = "SELECT * from Avt where Brdog=?"; oleDbAdapter1.SelectCommand.Parameters.AddWithValue("@Brdog", textBox1.Text); oleDbAdapter1.Fill(_dataset, "Avt"); dataGridView1.DataSource = _dataset.Tables["Avt"].DefaultView; conn.Close(); } }

Nel · Answer

Thank you to both of you.

Vulpes · Answer

For the benefit of others reading this, the code which Nel is using is in this thread: http://www.c-sharpcorner.com/Forums/Thread/159968/no-value-given-for-one-or-more-required-parameters-error-w.aspx Nel, I'd check whether the query is returning any rows: int numRows = oleDbAdapter1.Fill(_dataset, "Avt"); MessageBox.Show(numRows.ToString()); If it's not returning any rows but you're satisfied that it should be, then I'd try using a different overload of the Fill statement: oleDbAdapter1.Fill(_dataset); dataGridView1.DataSource = _dataset.Tables[0].DefaultView;

DataGridView in the tabcontrol displays empty rows

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (3)