DataGridView in the tabcontrol displays empty rows

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
 

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;

 

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();
  }
  }

Thank you to both of you.