We help IT Professionals succeed at work.

Best Practices = Database to C# class?

hej613
hej613 asked
on
321 Views
Last Modified: 2013-11-19
Good Morning experts - I'm working at a steel plant currently and would like to do some analysis on some of the work that is being done - I was trying to create a C# application that will do analysis and then export it into excel or some other reporting "thing"...

For a very simple example lets say my query looks like:

SELECT        STUPP_COIL, PO_NUMBER, RUN_DATE, COIL_WEIGHT
FROM            APPCOILS.COILS
WHERE        (TO_CHAR(RUN_DATE, 'MM/DD/YYYY') = '11/18/2013') AND (JOB = '9370')
ORDER BY STUPP_COIL

(the job and the date will be entered at the program, not hard coded into the query)

this will pull back about 60-70 "Coils" of steel per day,

If I had a class that had Coil#, po# and RunDate, and weight for the example how would I assign each coil an item in a list (for example) so I could add up all the weights, or see how many coils are being run per day, per hour, etc...

This is a very simplified example so I can hopefully understand the concept - The actual table has about 60 columns in it (I dont need them all, but I figured if I could do it with the bare minimum I could always scale it up)

Could someone point me to the correct direction on what I am trying to do?

I guess I do not know it enought to know exactly WHAT to ask... So, if anyone can help, I would appreciate it.

Thank you.
Comment
Watch Question

Have the datetime column for RUN_DATE and have the value with time appropriately.

Use below query to identify the jobs for given date range.

SELECT        STUPP_COIL, PO_NUMBER, RUN_DATE, COIL_WEIGHT
FROM            APPCOILS.COILS
WHERE  (RUN_DATE BETWEEN '20131118 01:00:10' AND '20131119 06:00:00' ) AND (JOB = '9370')

You could give the date and time FROM and TO range in where clause.
The general date should be in the format YYYYMMDD HH:MM:SS

HTH.

Author

Commented:
Thanks, Easwaran - I understand the SQL portion of it, I guess I was not specific enough with the question...

Once I use that SQL and pull back the rows, What should I do with them so I can do some analysis of the data?  Should I put the values in a list, should I put them in a DataAdapter/DataTable and use a LINQ query?  

What is the best way to deal with the information so I can do some analysis of some sort on it? adding up the weights, counting different coils by different status, etc, etc.

Could you or someone point me in the correct direction on what to do with the rows I get back?  a few links would be amazing, a book recommendation would also be great, is it ADO I'm looking into? Thank you.
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Author

Commented:
Thank you very much :)

Gain unlimited access to on-demand training courses with an Experts Exchange subscription.

Get Access
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Empower Your Career
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.