Updating MS Access

[zxk105]

I have done my web site using ASP.NET with MS Access database. I've got my database data to display on my pages so now it's turn to be able to update the data.

What I want to do is develop a simple (web) form with input boxes that I will dynamically populate with the data from my database. Then I will have an opportunity to change the info and click on the 'Update' button which will then update the database. Pretty straight forward.....

So far I've managed to retrieve my data, loop thru it, and use .InnerHtml to display it. But I have to use the regular html version (<input....>) of the input box. When I use <asp:TextBox...> it doesn't get processed on the server side. And this is where I am stuck. I don't know how to access this client side data via ASP.NET. Then I am also not sure if I'm doing this the right way or not. Can anyone explain to me how all of this done?

[SuperLite17]

Try something similar to this: [ using a datagrid ]

<code>
<asp:TextBox runat="server"
ID="FirstColumn" size="100"
MaxLength="100"
Text='<%# DataBinder.Eval(Container.DataItem, "FirstColumn") %>'
CssClass="flat" />
</code>

[zxk105]

So I have to use the 'datagrid'? I have come accross this when googling around. Does the 'datagrid' just temporarily store all the database info? I have to look more into it......