Adding to a Database with a Data Grid

[LFJ]

Greets fellow nerds,
this post concerns VB.Net.
I'm writing a program that uses Parent and Child data grids. This program reads from a database and displays the data in the data rows as planned. When I highlight a row in the parent grid, the related date displays in the child grid as planned. I need to add, modify, and delete data from thr database with this program.

My prob is that I can't add a new record of data in the parent grid. I get an error and the debugger stops. I can add a new row of data in the child grid and save it with no problems.

Have any of you guys had this prob? How do I get the Parent to accept new data and transfer it to the database?

I attached the code for this, see the code. Open the rtf text file with Wordpad.


Thanx a mil,
LFJ

[LFJ]

Please reply to this post. Toss in you $0.02. Don't be bashful. I need the help. You cats can help me, I'm sure of this. So, go ahead and get your feet wet. Give it a try, jump right in!

[Pirate]

See if this would do the trick !

'get data from datagrid and store them in obj
Dim obj As New Object()
obj = DataGrid1.DataSource
 
 
'pass the obj array to the datarow.itemarray and then update yourdatabase
Dim datarow As DataRow
datarow.ItemArray = obj