Adding rows to a gridview

[kimbred]

Here's the deal. I have a gridview that I need to fill by adding one record at a time. Is there a procedure for inserting a record in a gridview?

[Frinavale]

Add the row to the Object that you are using as the data source for the GridView and it will appear in your GridView.

-Frinny

[kimbred]

The values of several of the columns are dependent on other columns in the rows so I wanted to evailuate the data defore displaying it in the grid. From what I've read, it's not possible to insert rows into a dataview one by one programically. I'm not sure I understand your solution.

[Frinavale]

See you never mentioned the use of a DataView so I wasn't exactly sure what you were doing.

To do this you need to dynamically create a DataTable.
Then create a new DataView based on this DataTable:

Dim dynamicTable As DataTable = createDataTable()
Dim myDataView As New DataView(dynamicTable)
myGridView.DataSource = myDataView;

[kimbred]

So all my modification will be to the data table then the dataview will just use the data table as a source. Is that correct?

[dorandoran]

It is EXTREMELY pain in everywhere to insert a record using Gridview. Here is a good article yet painful.

http://fredrik.nsquared2.com/viewpost.aspx?PostID=155

http://aspnet.4guysfromrolla.com/articles/021203-1.aspx

http://amitpatriwala.wordpress.com/2008/04/18/inserting-new-row-in-gridview-in-aspnet-20/

http://www.dotnetspider.com/resources/18196-Add-New-Row-GridView-save-Database.aspx

http://www.c-sharpcorner.com/uploadfile/raj1979/gridviewexample11232008075052am/gridviewexample.aspx?login=true&user=qarjami

I have 10 more links on this. let me know if these dont help. Good Luck

[Frinavale]

So all my modification will be to the data table then the dataview will just use the data table as a source. Is that correct?

Well once it's in the DataView you can access the table and edit the data there, yes.

[kimbred]

Is that the way you'd do it?

[Frinavale]

Yup.

It's not pretty and I'm sure that there is a more elegant way to do it (using a different Object as the datasource).

But it's not as bad as it sounds. Especially if you are grabbing data from a database because you'll likely already have a table at that point.

In my case I'm converting Objects into a table, so it's a bit messier than your solution will be. Well it's only messy for the table generation part really, after that it's not so bad. It's been a long time since I've used a database (hope that will change in the near future).