SqlConnection objects with Visual Studio .Net 2005 on Design Mode

Hello,</o>
</o>
With the Visual Studio .Net 2003 it is possible to add SqlConnections, Sql Commands ? objects by means of the section Data of the </o>
Toolbox.</o>
</o>
At Visual Studio .Net 2005 this section does not more include these objects.</o>
I wrote code to get these objects. They have been displayed in the Component Designer window, but I have not found components / tools to add new such objects on Designer Mode.</o>
</o>
Is there any possibility to add on Designer Mode such objects to Web Forms or Services with Visual Studio .Net 2005?</o>
</o>
Thanks in advance for your help!</o>
</o>Valentin

 

The SqlDataSource object is available in the designer. I think you will want to use this...

http://msdn2.microsoft.com/en-us/dz12d98w.aspx


Joel Thoms
DiscountASP.NET
http://www.DiscountASP.NET

 

Ahh, I don't use the design time view for web services, I'm not very familiar with them.

Though I though that view was going away for web services. You might have to create the code manually.

You can check out this DatabaseUtility library, it might make simple data connections easier for you...

http://joel.net/software/databaseutility.aspx


Joel Thoms
DiscountASP.NET
http://www.DiscountASP.NET

 

Hi,
</o>
Thank you!</o>
I have found the SqlDataSource control under the Data Controls of the Toolbox.</o>
But this control is only for Web Applications available, not for Web Services.</o>
With VS 2003 the same Data Controls are available for both Web Applications and Web Services.</o>
And that is very important because also for Web Services database connections and operations are necessary for customer password validation, computing of number of method calls and so on. The alone one solution is to write code manually to get database connections.</o>
</o>
Valentin</o>

 

OK Joel,
</o>
There is no problem. </o>
There are more ways to get code for database connections with VS 2005 for Web Services:</o>
1. To create code with VS 2003 and migrate it to VS 2005. This is possible for the people like me who have installed the both versions.</o>
2. To migrate VS 2003 programs to VS 2005 and so to get code snippets or examples for other applications or services.</o>
3. Of course, just to write code manually.</o>
</o>
If you are interested and have time, please take a look of my Web Services and Apps. I would be glad. </o>
</o>
Best regards</o>
Valentin</o>
</o>
www.wwv-it.eu</o>