configuration

[cmsbuffet]

If I would like to connect SSMS with .Net, and I would like to connect a procedure in Transact-SQL with a Project in .Net studio, how do I do the configuration? Or how do I call procedure from SSMS?

 

[cmsbuffet]

I found out the following

To access SQL Server databases, you must import the System.Data.SqlClient namespace, which provides new objects such as the SqlDataReader and the SqlDataAdapter objects. You can use SqlDataReader to read a forward-only stream of rows from a SQL Server database. DataAdapter represents a set of data commands and a database connection that you can use to fill the DataSet object and to update a SQL Server database.

But in Visual Studio 2008 I don't have an option of Import and SSMS doesn't have an option of Import either.

 

[ca8msm]

There isn't a menu option for importing namespaces; they go at the top of your code behind file e.g.

Imports System.Data.SqlClient

Mark,

[URL unfurl="true"]http://lessthandot.com[/url] - Experts, Information, Ideas & Knowledge
[URL unfurl="true"]http://mdssolutions.co.uk[/url] - Website Design
[URL unfurl="true"]http://aspnetlibrary.com[/url] - An online resource for professional ASP.NET developers

 

[cmsbuffet]

Why I cannot find DataReader object in VS2008? I go to VS2008, open Web Form, find Toolbox, find Data, but there is no DataReader there...

 

[ca8msm]

Because a DataReader isn't an object you can drop on your page; you will need to create an instance of one in your code behind page. I'd suggest you start with going through some of the tutorials from

http://asp.net/learn

otherwise you are just going to hit problem after problem.

Mark,

[URL unfurl="true"]http://lessthandot.com[/url] - Experts, Information, Ideas & Knowledge
[URL unfurl="true"]http://mdssolutions.co.uk[/url] - Website Design
[URL unfurl="true"]http://aspnetlibrary.com[/url] - An online resource for professional ASP.NET developers

 

[cmsbuffet]

I am watching tutorial "Watch ASP.NET Development in Action." They are using VS2005 for explanation. However, I have VS2008. For instance, in tutorial they can view and add databases in an explorer on the right from the main window. However, I can neither view my SSMS databases, nor can I find an "ADD" button for the database in the explorer on the right from the main window. Is it supposed to be that way?