C#

cmd.Parameters.Add("@cust_id", OleDbType.Integer).Value = nCustID;<br />
cmd.Parameters.Add("@RouteID", OleDbType.Integer).Value = nRouteID;

SqlConnection sqlconSource = new SqlConnection(ConfigurationManager.AppSettings["cs"]);
SqlCommand sqlcmdSource = new SqlCommand("LogOn", sqlconSource);
sqlcmdSource.CommandType = CommandType.StoredProcedure;
sqlcmdSource.Parameters.Add(new SqlParameter("@UserName", SqlDbType.VarChar, 40));
sqlcmdSource.Parameters.Add(new SqlParameter("@Password", SqlDbType.VarChar, 10));
sqlcmdSource.Parameters["@UserName"].Value = txtUserName.Text;
sqlcmdSource.Parameters["@Password"].Value = txtPassword.Text;

sqlconSource.Open();

if (sqlcmdSource.ExecuteScalar().ToString() == "0")
   Response.Redirect("AccessDenied.aspx");
else
   Response.Redirect("FileManager.aspx");

sqlconSource.Close();

Try
{
   SqlConnection sqlconSource = new SqlConnection(ConfigurationManager.AppSettings["cs"]);
   SqlCommand sqlcmdSource = new SqlCommand("LogOn", sqlconSource);
   sqlcmdSource.CommandType = CommandType.StoredProcedure;
   sqlcmdSource.Parameters.Add(new SqlParameter("@UserName", SqlDbType.VarChar, 40));
   sqlcmdSource.Parameters.Add(new SqlParameter("@Password", SqlDbType.VarChar, 10));
   sqlcmdSource.Parameters["@UserName"].Value = txtUserName.Text;
   sqlcmdSource.Parameters["@Password"].Value = txtPassword.Text;

   sqlconSource.Open();

   if (sqlcmdSource.ExecuteScalar().ToString() == "0")
      Response.Redirect("AccessDenied.aspx");
   else
      Response.Redirect("FileManager.aspx");
}


Catch (SqlException e)
{
//however you want to handle the exception
}


Finally
{
   if (sqlconSource.State == ConnectionState.Open)
      sqlconSource.Close();
}

ConsoleKeyInfo cki = Console.ReadKey(true);
Console.WriteLine(cki.Key.ToString());

do
{
//do stuff
}
while (cki.Key != ConsoleKey.Escape);

while (true)
{
  flag = false
  get next file
  open file
  while (not flag)
  {
    read line from file
    if eof
      flag = true
    else
    {
      process data from file
      if escape key pressed
        flag = true
    }
  }
  close file
  if flag
    exit program
}

BoneSoft wrote:

But I won't taint your decision with my own personal choice.