SQLServer Instance

Question

Am trying to get a list of all sql sever instance(c#) in my network using this code but i get an empty list

var dt = SqlDataSourceEnumerator.Instance.GetDataSources();

to verify i put in CMD this "sqlcmd -L" and "osql -L" and i get the list.

so what am doing wrong, i dont know if OS matter am using Win10. Also someone know how to do this using dlls that sqlserver have?

thanks.

Answer 1

Hi Kavita:

For your second question removing of previous and next month days:  you can not remove them but you can hide them by setting those days back and forecolors using OtherMonthDayStyle attribute of Calendar.

Eg: <OtherMonthDayStyle ForeColor="Blue" BorderStyle="None" BorderColor="Blue" BackColor="Blue"></OtherMonthDayStyle>


But those cells are selectable in order to suppress this, add this in DayRender event of calendar:

if (e.Day.IsOtherMonth==true)
   {
    e.Cell.BackColor = System.Drawing.Color.Blue;
    e.Cell.ForeColor = System.Drawing.Color.Blue;
    e.Day.IsSelectable = false;
  }


in Page_Load event add this:

Calendar1.Attributes["onMouseDown"] = "JavaScript:Void(0);";

try out this.