clear the datagridview

Question

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

}

Sam Hobbs · Answer

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.

Vulpes · Answer

See if it makes any difference if you insert the highlighted line: lpogridview.DataSource = null; lpogridView.RowCount = 0; cmd.CommandText = select itemcodeitemnameunitlpoqtylporatelpodiscountlpovalue from lpo l inner join item i on l.itemid=i.itemid where lpono=' + textBox2.Text + ';