C#

private void btnLogon_Click(object sender, EventArgs e)
{
    //Connection Code
    string sql = "SELECT UserName,Password FROM Users WHERE UserName = '"
        + txtboxUserName.Text + "' AND Password = '" + txtboxPassword.Text + "'";
    OleDbCommand cmd = new OleDbCommand(sql, conn);
    conn.Open();
    OleDbDataReader dr = cmd.ExecuteReader();

    try
    {

    }
    catch (InvalidOperationException ex)
    {
        MessageBox.Show(ex.Message.ToString());
    }

    try
    {
        //Read Database
        while (dr.Read() == true)
        {
            this.DialogResult = DialogResult.OK;
        }

    }
    catch (Exception ex)
    {
        MessageBox.Show(ex.Message.ToString());
    }
    if (conn.State != ConnectionState.Closed)
    {
        conn.Close();
    }
}

Mike Curry - Canada wrote:

Does my shift code look ok?

sepel wrote:

sum of them had not any documantion or they had incomplete document or example

sepel wrote:

i searched internet befor.

leppie wrote:

you will be amazed at the advancements Google has made over the last 10 years!