Database

"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!

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!