C#

private void listBoxXxx_SelectedIndexChanged(object sender, EventArgs e)
        {
            if (listBoxXxx.Items.Count < 1)
            {
                string msg = "There are no Items in the list to select from. ";
                MessageBox.Show(msg, "Required Information Missing", MessageBoxButtons.OK, MessageBoxIcon.Information);
                return;
            }

            if (listBoxXxx.SelectedIndex != -1)
            {
                labelXxx.Text = listBoxXxx.SelectedItem.ToString();
            }
        }

        //Load the Main page
        frmMain m = new frmMain(fname, title, firm, firmId, permission, theDate, userId, chal, CONNSTR);
        this.Hide();
        m.ShowDialog();
    }
}
catch (SqlException Sqlex)  //Catch Sql Errors
{
    MessageBox.Show("Error: " + Sqlex, "SQL Connection Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}

catch (Exception ex)  //Catch All Errors
{
    MessageBox.Show("Error: " + ex, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
    return;
}

void ListSelectionChanged(object sender, EventArgs e){
 ListControl list = (ListControl)sender;
 if(list.SelectedIndex < 0) return;
 ... // do stuff with list.SelectedItem
}

tsw1985 wrote:

This is because I'm using a barcode gun, for windows it is a keyboard. If you
are writing a e-mail and I use the barcode gun, you can see numbers in you email
when you are writing. I want avoid that.

si_69 wrote:

I am trying to create a generic method for calling stored procedures

si_69 wrote:

Can anyone advise

public static bool WriteToDatabase(
    string sql,
    System.Data.CommandType commandType,
    out string errorText,
    params System.Tuple<string,object>[] values
)
{
    bool success = true;
    errorText = null;

    using (System.Data.IDbConnection connection = new System.Data.SqlClient.SqlConnection(ConnectionString))
    {
      try
      {
        using (System.Data.IDbCommand command = connection.CreateCommand() )
        {
          command.CommandText = sql ;
          command.CommandType = commandType ;

          foreach (System.Tuple<string,object> param in values )
          {
            System.Data.IDbDataParameter p = command.CreateParameter() ;
            p.ParameterName = param.Item1 ;
            p.Value = param.Item2 ;
            command.Parameters.Add(p);
          }

         connection.Open();
         command.ExecuteNonQuery();
        }
      }
      catch ( System.Exception err )
      {
        success = false ;
        errorText = err.ToString() ;
      }
      finally
      {
         connection.Close();
      }
    }

    return ( success ) ;
}

    WriteToDatabase
    (
      "blah blah blah"
    ,
      System.Data.CommandType.Text
    ,
      out error
    ,
      new System.Tuple<string,object> ( "@date" , System.DateTime.Now )
    ) ;