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/2...-in-aspnet-20/
http://www.dotnetspider.com/resource...-Database.aspx
http://www.c-sharpcorner.com/uploadf...e&user=qarjami

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

[Frinavale]

@kimbred
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).