Click here to Skip to main content
15,899,937 members
Home / Discussions / C#
   

C#

 
AnswerRe: How can i disable temporarily warnings/error from the code? Pin
Dave Kreskowiak11-Feb-06 8:51
mveDave Kreskowiak11-Feb-06 8:51 
GeneralRe: How can i disable temporarily warnings/error from the code? Pin
e-laj11-Feb-06 11:59
e-laj11-Feb-06 11:59 
Questionenumeration was modified operation may not execute Pin
spirit_of_pak11-Feb-06 6:23
spirit_of_pak11-Feb-06 6:23 
AnswerRe: enumeration was modified operation may not execute Pin
Ravi Bhavnani11-Feb-06 6:38
professionalRavi Bhavnani11-Feb-06 6:38 
AnswerRe: enumeration was modified operation may not execute Pin
perlmunger11-Feb-06 6:45
perlmunger11-Feb-06 6:45 
GeneralRe: enumeration was modified operation may not execute Pin
Dave Kreskowiak11-Feb-06 8:46
mveDave Kreskowiak11-Feb-06 8:46 
GeneralRe: enumeration was modified operation may not execute Pin
perlmunger11-Feb-06 11:10
perlmunger11-Feb-06 11:10 
AnswerRe: enumeration was modified operation may not execute Pin
malharone11-Feb-06 7:31
malharone11-Feb-06 7:31 
GeneralRe: enumeration was modified operation may not execute Pin
Colin Angus Mackay11-Feb-06 13:41
Colin Angus Mackay11-Feb-06 13:41 
GeneralRe: enumeration was modified operation may not execute Pin
malharone11-Feb-06 18:14
malharone11-Feb-06 18:14 
GeneralRe: enumeration was modified operation may not execute Pin
Colin Angus Mackay12-Feb-06 1:34
Colin Angus Mackay12-Feb-06 1:34 
GeneralRe: enumeration was modified operation may not execute Pin
malharone12-Feb-06 5:27
malharone12-Feb-06 5:27 
GeneralRe: enumeration was modified operation may not execute Pin
spirit_of_pak12-Feb-06 17:28
spirit_of_pak12-Feb-06 17:28 
QuestionError Pin
NaNg1524111-Feb-06 3:54
NaNg1524111-Feb-06 3:54 
AnswerRe: Error Pin
perlmunger11-Feb-06 7:15
perlmunger11-Feb-06 7:15 
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 

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.