Hi Niels,
You are using a recordset, that makes it very difficult to work with a
datagrid.
When you want to use that recordset, than you have first to make from your
recordset a kind of table, there are a lot om those you can take however not
the recordset because that does not fit on a datagrid, while a datatable is
the most easy one.
You have to bind that table to the datagrid and you can fill the table one
by one using those textboxes and comboboxes as you said.
Than you have to update your recordset with that table again
And than you can update it to your database.
And that while there are much more easier ways to go.
Did you ever look in the resource kit to those very simple samples.
VB.net Resource kit
http://msdn.microsoft.com/vbasic/vbrkit/default.aspx
And if you have problems installing the resource kit
http://msdn.microsoft.com/vbasic/vbr...q/#installvdir
There are in that resourcekit very few update databasse commands, when you
are that far reply here or look at the "dataadapter update" and do not
forget the "commandbuilder".
The one you sure forget is to take care of the last update with the
"endcurrentedit".
However you can start and ask your questions in this newsgroup, you sure get
answers.
You can crosspost it to the newsgroup,
microsoft.public.dotnet.framework.adonet than as well.
I hope this helps?
Cor
