Database

public static DataSet GetEventList(
     int activeState, 
     int eventId,
     int eventDateStatus,
     DateTime eventDateStart,
     DateTime eventDateEnd,
     int createDateStatus,
     DateTime createDateStart,
     DateTime createDateEnd,
     int ntdStatus,
     int eventTypeId,
     string firstName,
     string lastName)
{
     DataSet ds = null;
     SqlCommand cmd = null;
     SqlDataAdapter da = null;

     SqlConnection conn = GetConnection();
     if (conn != null)
     {
          try
          {
               cmd = new SqlCommand("EventListGet",conn);
               cmd.CommandType = CommandType.StoredProcedure;

               SqlParameter p = cmd.Parameters.Add("@ActiveState",SqlDbType.Int);
               p.Value = activeState;
                    
               p = cmd.Parameters.Add("@EventId",SqlDbType.Int);
               p.Value = eventId;

               p = cmd.Parameters.Add("@EventDateStatus",SqlDbType.Int);
               p.Value = eventDateStatus;
                    
               p = cmd.Parameters.Add("@EventDateStart",SqlDbType.DateTime);
               p.Value = eventDateStart;
                    
               p = cmd.Parameters.Add("@EventDateEnd",SqlDbType.DateTime);
               p.Value = eventDateEnd;

               p = cmd.Parameters.Add("@CreateDateStatus",SqlDbType.Int);
               p.Value = createDateStatus;
					
               p = cmd.Parameters.Add("@CreateDateStart",SqlDbType.DateTime);
               p.Value = createDateStart;
					
               p = cmd.Parameters.Add("@CreateDateEnd",SqlDbType.DateTime);
               p.Value = createDateEnd;

               p = cmd.Parameters.Add("@NTDState",SqlDbType.Int);
               p.Value = ntdStatus;

               p = cmd.Parameters.Add("@EventTypeId",SqlDbType.Int);
               p.Value = eventTypeId;

               p = cmd.Parameters.Add("@FirstName",SqlDbType.VarChar,50);
               p.Value = firstName;

               p = cmd.Parameters.Add("@LastName",SqlDbType.VarChar,50);
               p.Value = lastName;
					
               da = new SqlDataAdapter(cmd);
               ds = new DataSet();
               da.Fill(ds);
          }
          catch (Exception ex)
          {
               MessageBox.Show(ex.Message,"Load Event List Failed");
               if (ds != null)
               {
                    ds.Dispose();
                    ds = null;
               }
          }
          finally
          {
               if (da != null) da.Dispose();
               if (cmd != null) cmd.Dispose();
               if (conn != null) conn.Close();
          }
     }

     return ds;
}

"If a man empties his purse into his head, no man can take it away from him, for an investment in knowledge pays the best interest." -- Joseph E. O'Donnell

The Second EuroCPian Event will be in Brussels on the 4th of September

Can't manage to P/Invoke that Win32 API in .NET? Why not do interop the wiki way!

SELECT
     LastName,
     FirstName
FROM
     CustomerTable

UNION ALL

SELECT
     NameLast,
     NameFirst
FROM
     EmployeeTable