troubleshooting Question

Best Practices = Database to C# class?

Avatar of hej613
hej613 asked on
Microsoft SQL ServerC#
4 Comments1 Solution327 ViewsLast Modified:
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.
ASKER CERTIFIED SOLUTION
Easwaran Paramasivam
Senior Software Engineer

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 4 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros