Saving an updated dataset back to the database

[Creini]

Hi,

I'm trying to write a Webapplication in ASP.Net 3.5 and C#.

I read data from a database and Bind it to a FormView using

<%# Eval("Columname") %>

Which works quite well. But I have no idea how to save the changes back to the database. Well, I think I can use the dataadapter.update function, but I don't know how to call it before my page does a postback and loose all my changes.

How do I save things back to a database??

Thanks,
Mattias

[Curtis Rutland]

Ok, well if you are doing your binding in your codefile's Page_Load method, make sure that you surround it with

if(! Page.IsPostBack)
{
//here's where your binding goes
//this is C#, but you get the picture
}
 

That will prevent your changes from being lost on postback.

You need to make sure that your DataAdapter has a Update and (possibly) an Insert command. You can automatically generate these commands using a CommandBuilder.

Take a look at this article to see an example of the CommandBuilders.

Then you should be able to use the Update command.