how to remove last row

[smriti]

hi all,

 

i am using access database and when i load the grid

the last blank row is also appearing.

how to make it invisible.

 

 

Thanks.

[penfold69]

If the grid can be made read only, do so:

 

myGrid.ReadOnly = True.

 

Otherwise, you need to set up a DataView:

 

(from memory):

 

Dim dv as New DataView(YourDataTable_or_YourDataSet)

dv.AddNew = False

MyGrid.Datasource = dv

 

 

B.

[smriti]

Thanks for your reply.

But i am getting an exception

cannot create a child list for field Table2

 

I used the following

 

string strSql=@"Select * from Table2";

da=new OleDbDataAdapter(strSql,constr);

ds.Clear();

da.Fill(ds,"Table2");

DataView dv=new DataView(ds.Tables["Table2"]);

dv.AllowNew=false;

this.dataGrid1.DataSource=dv;

this.dataGrid1.SetDataBinding(dv,"Table2");

 

Thanks

[donnacha]

Try the following (VB Code)

 

Dim cm As CurrencyManager = BindingContext(dataGrid1.DataSource, dataGrid1.DataMember)

Dim dv As DataView = cm.List

dv.AllowNew = False