Click here to Skip to main content
15,886,872 members
Home / Discussions / C#
   

C#

 
GeneralRe: Error Pin
NaNg1524111-Feb-06 8:13
NaNg1524111-Feb-06 8:13 
GeneralRe: Error Pin
NaNg1524111-Feb-06 9:36
NaNg1524111-Feb-06 9:36 
GeneralRe: Error Pin
perlmunger11-Feb-06 11:09
perlmunger11-Feb-06 11:09 
QuestionCreate list with Grid and getting Process info in C#. Pin
Yanshof11-Feb-06 1:37
Yanshof11-Feb-06 1:37 
AnswerSome one can help me with this question please ? Pin
Yanshof11-Feb-06 9:02
Yanshof11-Feb-06 9:02 
AnswerRe: Create list with Grid and getting Process info in C#. Pin
Dave Kreskowiak11-Feb-06 10:51
mveDave Kreskowiak11-Feb-06 10:51 
QuestionHow to browse SQL server from a network? Pin
bouli10-Feb-06 21:46
bouli10-Feb-06 21:46 
AnswerRe: How to browse SQL server from a network? Pin
perlmunger11-Feb-06 6:34
perlmunger11-Feb-06 6:34 
You don't mention if you are using SQL Server 2000 or 2005. I'll assume 2000 because I can provide you with an answer (though I would be surprised if the answer was much different in 2005).

You need to use SQLDMO. This is a COM component that allows you to programmatically control SQL Server. Here is a basic snippet for loading a list of servers:
ArrayList serverList = new ArrayList();
SQLDMO.Application dmo = new SQLDMO.Application();
SQLDMO.NameList nameList;
nameList=dmo.ListAvailableSQLServers();
foreach ( object svrName in nameList)
{
	string server = svrName.ToString();
	if (server == "(local)")
	{
		server = "localhost" ;
	}
	serverList.Add ( server ) ;
}

The section where I check to see if the current server name is (local) and then change it to localhost is there because if you provide (local) in your connection string, it won't work properly. It expects localhost.

You can now use the ArrayList serverList in a listview or a combobox. In order to use SQLDMO, you will need to add a reference to it. Just right-click and "Add Reference" on the references folder in your project. Then click the COM tab in the ensuing dialog. Search through that list for "Microsoft SQLDMO Object Library". Click Select and then Ok. Visual studio will automatically make a .NET wrapper for the object and you should be able to use it as I have specified in my code above (though the SQLDMO namespace may come up as something different in yours. Just look at the references list once it's been added to know if you need to alter that in your code).

Let me know if you have any questions.

-Matt

------------------------------------------

The 3 great virtues of a programmer:
Laziness, Impatience, and Hubris.
--Larry Wall
QuestionI need Help Pin
BestArtemis10-Feb-06 21:22
BestArtemis10-Feb-06 21:22 
AnswerRe: I need Help Pin
Wayne Phipps10-Feb-06 21:35
Wayne Phipps10-Feb-06 21:35 
QuestionDLL Problem Pin
Expert Coming10-Feb-06 14:06
Expert Coming10-Feb-06 14:06 
AnswerRe: DLL Problem Pin
Dave Kreskowiak10-Feb-06 14:28
mveDave Kreskowiak10-Feb-06 14:28 
GeneralRe: DLL Problem (How?) Pin
Expert Coming10-Feb-06 14:33
Expert Coming10-Feb-06 14:33 
GeneralRe: DLL Problem (How?) Pin
Dave Kreskowiak10-Feb-06 14:56
mveDave Kreskowiak10-Feb-06 14:56 
GeneralRe: DLL Problem (How?) Pin
kourvoisier10-Feb-06 14:59
kourvoisier10-Feb-06 14:59 
GeneralRe: DLL Problem (How?) Pin
Expert Coming10-Feb-06 15:09
Expert Coming10-Feb-06 15:09 
GeneralRe: DLL Problem (How?) Pin
Dave Kreskowiak10-Feb-06 16:50
mveDave Kreskowiak10-Feb-06 16:50 
GeneralRe: DLL Problem (How?) Pin
Expert Coming10-Feb-06 17:09
Expert Coming10-Feb-06 17:09 
GeneralRe: DLL Problem (How?) Pin
Dave Kreskowiak10-Feb-06 17:25
mveDave Kreskowiak10-Feb-06 17:25 
GeneralRe: DLL Problem (How?) Pin
Expert Coming10-Feb-06 17:32
Expert Coming10-Feb-06 17:32 
Question2 question about C#.... Pin
Yanshof10-Feb-06 12:37
Yanshof10-Feb-06 12:37 
AnswerRe: 2 question about C#.... Pin
Expert Coming10-Feb-06 13:03
Expert Coming10-Feb-06 13:03 
AnswerRe: 2 question about C#.... Pin
Sean8910-Feb-06 13:16
Sean8910-Feb-06 13:16 
AnswerRe: 2 question about C#.... Pin
perlmunger10-Feb-06 18:14
perlmunger10-Feb-06 18:14 
QuestionDrawing with c# Pin
kourvoisier10-Feb-06 12:29
kourvoisier10-Feb-06 12:29 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.