.NET SQL SERVER Usage

[newkhan]

Hi,
My question is that if use built in sql server of .NET Framework 2005 then after creating database how to perform insert function to insert values in the table. I cant find where the query is going to made. Please guide me how to perform operation on databases through builtin sql server in .NET 2005.

Thank You.

[Frinavale]

Hi,
My question is that if use built in sql server of .NET Framework 2005 then after creating database how to perform insert function to insert values in the table. I cant find where the query is going to made. Please guide me how to perform operation on databases through builtin sql server in .NET 2005.

Thank You.

Are you using Visual Studio 2005? Framework 2.0?

Have you seen this article on how to use a database in your program?

Your query should be made in your code...unless you are using Stored Procedures. In that case, the query's already been compiled for you and all you have to do is call it.

-Frinny