Click here to Skip to main content
11,493,171 members (63,162 online)
Rate this: bad
good
Please Sign up or sign in to vote.
See more: C# ASP.NET
urgently require the code for data mapping from source file to target file which will lead to migration of objects.

source file will be a simple tabular file which has to be mapped.
please suggest feasible options which can be used in visual studio
Posted 14-Jan-13 23:14pm
Edited 15-Jan-13 1:37am
v4
Comments
Milind_T at 15-Jan-13 4:15am
   
Is this really a question ? Not on my to-do list for sure !
shanky9211 at 15-Jan-13 6:33am
   
yeah...it is.
lets assume if a source file is provided with details about materials(eg:width,density etc) and you have to map it into the target file using visual web developer 2010.
in the above given circumstance wot shud i do??
it will be nice if u suggest sm help
Suvabrata Roy at 15-Jan-13 4:19am
   
Please provide some sample...
and elaborate your question
shanky9211 at 15-Jan-13 6:34am
   
yeah...it is.
lets assume if a source file is provided with details about materials(eg:width,density etc) and you have to map it into the target file using visual web developer 2010.
in the above given circumstance wot shud i do??
it will be nice if u suggest sm help

1 solution

Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

Hi,

As per my understanding,

You have two files. One is Tabulated another is also Tabulated (as per my assumption)
but still they have some miss matches so you need to map one to another.

The source file is tab delimited (as you said) now rename it to CSV extract it using OLEDB, then you will get DataTable and the same way you will able to insert selected columns to destination file ( as Its also assumed as Tab delimited ).

For further classification Read

KBCSCV[^]
OLEDB Fetch[^]
Insert Data Using OLEDB[^]
  Permalink  

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

  Print Answers RSS
0 Sergey Alexandrovich Kryukov 419
1 Maciej Los 286
2 F-ES Sitecore 224
3 KarstenK 210
4 CPallini 208
0 Sergey Alexandrovich Kryukov 10,132
1 OriginalGriff 8,630
2 Sascha Lefèvre 3,624
3 Maciej Los 3,392
4 Richard Deeming 2,500


Advertise | Privacy | Mobile
Web01 | 2.8.150520.1 | Last Updated 15 Jan 2013
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100