public void auctionAdd(auction auction) { createConnection(); connection.Open(); SqlCommand command = new SqlCommand("auctionAdd", connection); command.CommandTimeout = 40; command.CommandType = CommandType.StoredProcedure; command.Parameters.Add("@serviceCode", SqlDbType.Int, 50); command.Parameters["@serviceCode"].Value = auction.serviceCode; command.Parameters.Add("@staff", SqlDbType.Int, 50); command.Parameters["@staff"].Value = auction.staff; command.Parameters.Add("@bid", SqlDbType.DateTime, 50); command.Parameters["@bid"].Value = auction.bid; command.Parameters.Add("@timee", SqlDbType.NVarChar, 50); command.Parameters["@timee"].Value = auction.timee; command.ExecuteNonQuery(); connection.Close(); connection.Dispose(); }