New Row in the bound DataGridView

[D2]

Hi All,

I have a bound DataGridView control where I wish to add a new row. The
simple solution turns out to be add a new row to the underlying
datatable object and the changes will automatically reflect in the
grid. However, I seem to have caught something bad.

My query is something like this:

select * from [order] where orderid=x

this returns zero records in the dataset.

I bind the grid to the dataset as below:

grid.DataSource = ds;
grid.DataMember = "order"

now, I want to add a new row in the grid.. as follows:

ds.Rows.Add(ds.Tables["order"].NewRow());

after this, I check the rows in the grid:
grid.Rows.Count.. it shows 0

Pl note that when my query returns >=1 rows then the above works just
fine.

Any idea if i'm missing something here?

Cheers!
D2