C#

ganeshdpatil wrote:

But i can do same thing for SQL server

DataTable instances = SmoApplication.EnumAvailableSqlServers(false);

Pete O'Hanlon wrote:

Sorry - I was in the middle of organising unit testers this afternoon

DataTable ListOfServersNames=new DataTable();<br />
 var sqlServers = SqlDataSourceEnumerator.Instance;<br />
 ListOfServersNames= sqlServers.GetDataSources();

Application.ThreadException += new ThreadExceptionEventHandler(Application_ThreadException);

private static void Application_ThreadException(object sender, ThreadExceptionEventArgs e)
{
    StreamWriter errorWriter = new StreamWriter(@"c:\errorlog.txt");
    try
    {
        OutputError(e.Exception, errorWriter);
    }
    finally
    {
        errorWriter.Close();
    }
}

private static void OutputError(Exception ex, StreamWriter errorWriter)
{
    errorWriter.WriteLine("Type : " + ex.GetType().ToString());
    errorWriter.WriteLine("Message : " + ex.Message);
    errorWriter.WriteLine("Source : " + ex.Source);
    errorWriter.WriteLine("StackTrace : " + ex.StackTrace);
    errorWriter.WriteLine("TargetSite : " + ex.TargetSite);

    errorWriter.WriteLine("Data :");
    System.Collections.IDictionaryEnumerator enumerator = ex.Data.GetEnumerator();
    while (enumerator.MoveNext())
    {
        errorWriter.WriteLine("    " + enumerator.Key.ToString() + " : " + enumerator.Value.ToString());
    }

    if (ex.InnerException != null)
    {
        errorWriter.WriteLine("");
        errorWriter.WriteLine("Inner Exception :");
        OutputError(ex.InnerException, errorWriter);
    }
}

Type : System.AccessViolationException
Message : Attempted to read or write protected memory. This is often an indication that other memory is corrupt.
Source : System.Windows.Forms
StackTrace :    at System.Windows.Forms.UnsafeNativeMethods.PeekMessage(MSG& msg, HandleRef hwnd, Int32 msgMin, Int32 msgMax, Int32 remove)
   at System.Windows.Forms.Application.ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(Int32 dwComponentID, Int32 reason, Int32 pvLoopData)
   at System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context)
   at System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context)
   at System.Windows.Forms.Application.Run(Form mainForm)
   at Ninja.Program.Main() in C:\Documents and Settings\Administrator\My Documents\Visual Studio 2005\Projects\Ninja\Ninja\Program.cs:line 27
TargetSite : Boolean PeekMessage(MSG ByRef, System.Runtime.InteropServices.HandleRef, Int32, Int32, Int32)
Data :

   Application.SetUnhandledExceptionMode(UnhandledExceptionMode.CatchException);
    AppDomain.CurrentDomain.UnhandledException += new UnhandledExceptionEventHandler(Application_Exception);

private static void Application_Exception(object sender, UnhandledExceptionEventArgs e)
{
    StreamWriter errorWriter = new StreamWriter(@"c:\errorlog2.txt");
    try
    {
        OutputError((Exception)e.ExceptionObject, errorWriter);
    }
    finally
    {
        errorWriter.Close();
    }
}