SQL Server Wizard [RESOLVED]

[Andy]

Hmm. I don't know exactly what I'm trying to ask so I'll do my best here lol

when you want to create a connection to a server using the server explorer, you get to choose the server instace, the databases and such from a wizard. Where can I find a thread or code or SOMETHING to guide me how to create my own drop-down boxes of SQL servers on a network or a pc? I'm creating a utility that converts SQL database tables into XML files and i need the user to be able to select a Server, a database and a table on his/her own will.

[Mike Hildner]

This example is in C#, but it explains how to do
http://www.codeproject.com/cs/databa...&select=822220

[Andy]

Thanks a lot. i will play around with that here shortly.

[Andy]

well dang. the c# source code is a LOT advanced for this dude. if anyone has links to a vb source OR can translate the source into vb, that'd be awesome.

[Mike Hildner]

Andy,

I haven't even tried it, but do you even need to translate to vb.net? Can't you just reference that code and call it?

[Andy]

yeah, I could. But i noticed that the code wasn't as solid as it could be. For instance, when I ran the sample code that goes along with that, it didn't detect all my servers or databases. I was wanting to examine the code and see why.

I will do what you suggested though. That's better than nothing

[Mike Hildner]

I just asked this question on a SQL group, here's the reply.
http://groups.yahoo.com/group/micros...r/message/4379

Hope you get it working - this is something I need to do as well, although I've got some time before I need to implement. If you do get it working, please let me know!

[Andy]

absolutely! thanks for the footwork man

[dsc_chris]

Hey Andy.

C-Sharp to VB.net Converter

http://www.kamalpatel.net/ConvertCSharp2VB.aspx

This works well. You can download the offline version which will convert more code then the online version and you even get the source code (Built in C#)

Remember though converting code is not always the best idea. For the most part everything will work but there are some things in C# which wont work in VB (From what I have read anyways someone can clear this up if I am wrong)

Regards,

Chris

[Mike Hildner]

Here's another c# to vb converter:
http://authors.aspalliance.com/aldot...translate.aspx

This month's issue of MSDN magazine has an article about C# to VB to C#:
http://msdn.microsoft.com/msdnmag/is...t/default.aspx

[dsc_chris]

Mike, are you good with sockets or know anything about the new socket system in VB.net i have an open thread I need some help

[dsc_chris]

Interesting that MSDN Article has a link to the CSharp2VB converter

[Mike Hildner]

Good enough to have an application that people pay for Doesn't mean I'm an expert, but it's functional. What's the thread?

Sorry for going OT.

[dsc_chris]

http://www.vbforums.com/showthread.p...hreadid=298727