do i need odbc connection?

[nitin.manipal]

hi,

i am stuck... i want to run stored procedure in sql by using .net...so my problem is that do i need to make odbc connection to sql server to run it..

please can anybody help me!

nitin

[Shuja Ali]

.NET has a dedicated class library for accessing SQL Server which can bve found in System.Data.SQLClient.

Take a look at the following in your MSDN.

System.Data.SQLClient.SQLConnection
System.Data.SQLClient.SQLCommand.

[nitin.manipal]

thanks for ur reply..actually now i want a TravelAdapter ...so traveladapter configuration wisard is only option to prepare it or anyother way i can do it..

actually i want to fetch data from database based on stored procedure..and store this in a dataset..now how do i proceed using travel adapter in this case..

plz help

nitin

.NET has a dedicated class library for accessing SQL Server which can bve found in System.Data.SQLClient.

Take a look at the following in your MSDN.

System.Data.SQLClient.SQLConnection
System.Data.SQLClient.SQLCommand.

[Shuja Ali]

You can use Stored procedure as well as a select query to fetch data from the database and store it into a dataset.

I would strongly recommend that you read about ADO.NET from MSDN before proceeding with your project.