How to add new row to datagrid?

[Prasadsm]

Hi All,

Check this....

Public Sub CreateNewRow()
Dim index As Integer
index = StatusGrid.Items.Count
Dim da As New SqlDataAdapter
conn.Open()
 
da = New SqlDataAdapter("select * from Status", conn)
 
'New Row Creation
da.Fill(dt)
dt.Rows.Add(dt.NewRow)
'dt.Rows.InsertAt(dt.NewRow(), index)
StatusGrid.EditItemIndex = index
dt.AcceptChanges()
StatusGrid.DataSource = dt
StatusGrid.DataBind()
conn.Close()
 
End Sub

With this code, I got new row in the datagrid.

But the problem Occurs, When the pagesize exceeds.

Here I have given pagesize as 10.

Assume there is 10 rows.Now When AddNewRow button is clicked, I should get new row in next page.(Total 11 rows).10 in first page and the new row in next page.

How can I get this?

Thanks in Advance...

[nateraaaa]

Please post your code that displays the properties you have set for the datagrid.

Nathan