Save data to a database in C#?

Question

How do I save data to a database fom a ASPX page?

Answer 1

Using ADO.net you can save data to database. To know more about ADO.net Refer: http://msdn.microsoft.com/en-us/library/h43ks021

If you have your Database ready, it is simple, Just drag a SQL Data Source Component from TOOL box and configure it . A good example is shown here: http://www.asp.net/web-forms/tutorials/data-access/accessing-the-database-directly-from-an-aspnet-page/inserting-updating-and-deleting-data-with-the-sqldatasource-vb 

Another option is to use SQL Adopter which provides a Connection Object, Command Object and a Dataset. You can play with it to I/U/D/Select data.

http://support.microsoft.com/kb/308507

http://www.emmet-gray.com/Articles/SavingDataADO.htm

If You work with .net 4.0 Entity Framework i would recomend you to go with Entity Framework too.

http://www.asp.net/web-forms/tutorials/getting-started-with-ef/the-entity-framework-and-aspnet-getting-started-part-1

---

Lingaraj Mishra

Answer 2

Hi Tony,

To add more another preferred option would be using Enterprise Library Data Access Application Block. Please visit the below link for more info.

http://msdn.microsoft.com/en-us/library/ff664408(v=pandp.50)

-Mohammed Ghouse Ibne Barq Kadapavi
http://www.ProgrammersVision.blogspot.com
https://sites.google.com/site/BarqKadapavi
Please mark the post answered your question as the answer, and mark other helpful posts as helpful.