Dynamic Maping Columns In Excel and database

Question

0.00/5 (No votes)

See more:

I have to fetch data from excel file and store that data in sql server table and i have fetch only those columns of data from excel ,which i mapped with particular columns in database table.

Posted 24-Jul-13 1:36am

Rambabu Sapa

Updated 24-Jul-13 2:09am

Code-Hunt

v2

Add a Solution

Comments

Maciej Los 24-Jul-13 7:51am

And where are you stuck? What kind of issue do you have? What have you done so far?

Rambabu Sapa 24-Jul-13 7:55am

Based On excel Column names i Generated Dynamic labels and same as fill the dropdownLists after That I Have to Map The Drop Down List Columns with exec Columns.
Thanks in Advance

Maciej Los 24-Jul-13 8:00am

It doesn't explain anything ;(
Could you be more specific adn provide more details (example data, used code, etc.)?

Rambabu Sapa 24-Jul-13 8:16am

Example we have
FName , LName , DOB , SAL Columns in Excel
___________________________________________
Tabl1 :- LName,DOB , SAL
Table2 :- FName , SAL

Now I Have to map The exel Data into dataBase Tables Based On User Selection

[no name] 24-Jul-13 8:08am

provide some more information.

Rambabu Sapa 24-Jul-13 8:54am

When files are received from banks, they will contain many fields. The values in those fields may not match the values which must be loaded into the database.
For example, one field which will be on many records is the State (related to address fields). The source data might contain CT or Connecticut. The target database will use an integer value for this field (in this case 8). This integer value will be stored in a field called AddressStateTC.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Manikandan Sekar · Answer 1 · 2013-07-24T01:42:00

Solution 1

Refer this

Load GridView from Excel[^]

use the

SqlBulkCopy

method to copy the data or read the records one by one in the datatable and load it in the database.

Hope it helps.

Posted 24-Jul-13 1:42am

Manikandan Sekar