clear the datagridview

Shyja Abraham

I have a form with textbox and datagridview ,when we enter the value into the textbox ,corresponding values filled into the datagridse view. i use this code for this , but here arise one problem when we change the value of textbox, the datagridview values not cleared, the Previous values also displayed in to the datagridview. how we clear the datagridview , when we enter the value 2nd time into textbox.

private void textBox2_TextChanged(object sender, EventArgs e)

{

lpogridview.Visible = true;

lpogridview.DataSource = null;

cmd.CommandText = "select itemcode,itemname,unit,lpoqty,lporate,lpodiscount,lpovalue from lpo l inner join item i on l.itemid=i.itemid where lpono='" + textBox2.Text + "'";

da.SelectCommand = cmd;

da.Fill(ds, "item11");

DataTable dt11 = ds.Tables["item11"];

lpogridview.AutoGenerateColumns = false;

lpogridview.DataSource =dt1

}

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sam Hobbs15y ago
If you have everything connected properly, then you don't need to re-fill the data when the bound data changes.

You are not using a BindingSource. I don't know if that would help with this but it might.

Note that you don't show what "da" and what "ds" are.

Have a look at my Database Table Update in a DataGridView without Writing Code; it might help.
0
Vulpes15y ago
See if it makes any difference if you insert the highlighted line:

lpogridview.DataSource = null;
lpogridView.RowCount = 0;
cmd.CommandText = "select itemcode,itemname,unit,lpoqty,lporate,lpodiscount,lpovalue from lpo l inner join item i on l.itemid=i.itemid where lpono='" + textBox2.Text + "'";
0