C#

bouli wrote:

I'd like to know how I can get connected to the default instance of SQL Server with user login?

try<br />
{<br />
     SqlConnection connection = new SqlConnection("server=localhost; database=yourdb; user=yourusername; password=yourpassword);<br />
     connection.Open();<br />
}<br />
catch (SQLExcepton SqlE)<br />
{<br />
     //Do you exception handling here<br />
     connection.Close();<br />
}

serialPort1.PortName = "COM2";<br />
serialPort1.Open();<br />

public enum PortAvailabillity
        {
            Available, InUse
        }

 public static Dictionary<int, PortAvailabillity> GetPorts()
        {
            string[] availablePorts = SerialPort.GetPortNames();
            Dictionary<int, PortAvailabillity> portStatus = new Dictionary<int,PortAvailabillity>();

            foreach (string s in availablePorts)
            {
                int number = int.Parse(s[s.Length - 1].ToString());

                try
                {
                    SerialPort p = new SerialPort(s);

                    if (!p.IsOpen)
                        portStatus.Add(number, PortAvailabillity.Available);
                    else
                        portStatus.Add(number, PortAvailabillity.InUse);

                }
                catch (IOException err )
                {
                    #if DEBUG
                    Console.WriteLine("Error getting port: " + err.ToString());
                    #endif
                }
            }

            return portStatus;
        }