What database is used in ASP.net? can anybody show me d syntax to create it, insert value and retrieve it?

I just learned ASP.net from w3 school. I find it interesting. I've been working with php for quite sometime. I have moderate knowledge on sql as well as basic programming. But i'm having problem with database to be used in ASP.net. How to access it? How to create a database? How to insert a value and to retrieve it?What database is used in ASP.net? can anybody show me d syntax to create it, insert value and retrieve it?
You can use practically any database with ASP.Net, including SQL Server, Oracle, Access, and MySQL, among others. It sounds like you might want to learn about the ADO library, which is a set of objects used to connect to and manipulate data in databases through application code. Check this site out :





http://msdn2.microsoft.com/en-us/library鈥?/a>





I think it will answer alot of your questions and point you in the right direction. Good luck : )What database is used in ASP.net? can anybody show me d syntax to create it, insert value and retrieve it?
Sorry there is no Data Base in ASP.net just like there is no Data Base in PHP. both PHP and ASP.net are technologies to create web based application. Both have nothing to do with data bases. Data base servers like MySQL or MS SQL 2005 are where the actual data base can be created and modified. You actually do not have to use a data base server and can use a locally installed data base like SQL express MSDB or MS Access. Both PHP and ASP.net have classes that allow them to communicate with Data Bases and execute data base commands. In ASP.net if you are a beginner you can just open the server explorer open the data base and drag a table on to your .aspx page. This will create an sqladapter but is generally a bad idea as you do not control the SQL being executed. The more advanced user will actually create a stored procedure and a wrapper class to execute it from the app.

horses for loan

skin care