C# Programming
06-02-2012, 11:31 AM
I have a question about how to handle a change for a C#.net 2010 application that loads a data table from an excel 2003 spreadsheet. Basically all the rows and columns from an excel spreadsheet are loaded into a datatable (ado.net object) for editing purposes before the data is loaded into a sql server 2008 r2 database.
Basically right now each column has a large volume of edits that need to pass edits before the data can be loaded to the database. The edits are setup for each column uniquely.
Now my company wants to me to combine the edits for two specific columnns together. The edits will be based upon two data validation tables that are stored in the sql server database.
Can you tell me and/or point me to a reference that will tell me how to solve this problem?
Basically right now each column has a large volume of edits that need to pass edits before the data can be loaded to the database. The edits are setup for each column uniquely.
Now my company wants to me to combine the edits for two specific columnns together. The edits will be based upon two data validation tables that are stored in the sql server database.
Can you tell me and/or point me to a reference that will tell me how to solve this problem?