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;
        }

string strQuery="";
strQuery = "select dashboardid from dashboardlogin where (loginname = '" + txtLoginName.Text + "') AND (loginpswd = '" + txtPassword.Text + "')";
SqlCommand cm = new SqlCommand(strQuery, conn);
int i = Convert.ToInt32(cm.ExecuteScalar());

coolestCoder wrote:

This is a simple solution but creating dynamic queries are prone to SQL Injection attacks. Use Stored procedures instead or use parameterized command object.

Nekshan wrote:

but it gives dashboardid of only loginname=hina.

Nekshan wrote:

what must i do to change my query for such result?

Nekshan wrote:

SqlCommand cm = new SqlCommand("select dashboardid from dashboardlogin where (loginname = 'hina') AND (loginpswd = 'shaikh')", conn);
int i = Convert.ToInt32(cm.ExecuteScalar());

i have this query working properly,but it gives dashboardid of only loginname=hina.
but i want dashboardid of that person who logs in the system(this code is on login form),whoever logs in the system,his dashboardid must be got in variable 'i'.
what must i do to change my query for such result?
thank you.
nekshan.

SqlCommand cm = new SqlCommand("SELECT dashboardid FROM dashboardlogin "+
"WHERE loginname = @loginname AND loginpwd = @password", conn);
cm.Parameters.Add("@loginname", theLoginName);
cm.Parameters.Add("@password", thePassword");
object rawId = cm.ExecuteScalar();
if (rawId == DBNull.Value)
{
    // The login wasn't found - handle this
}
else
{
    int id = (int)rawId;
    // Do stuff with the id
}

Nekshan wrote:

int s = Convert.ToString(cm.ExecuteScalar());