Dynamic Data binding

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hi, I am looking for some quick advice on the methods I'm
investigating..

I have a portion of my program that allows a user to import address
data from either an excel sheet, acess db, or a delimited file. What I
need to do is set up their data in a specific format that we use
without needing to inform the client ahead of time. For instance we
need the full name in a column called "Name", but the customer's file
might have a Last Name column and a Full Name column. What I'm trying
out is to fill a dataset with their data, and pop up a screen that has
2 data grids(one that specifies what it should be, and one with the
actual data) and a bunch of check boxes. While the "Name" column in
the ShouldBe table is highlighted, they select a column in their data
and then click the checkbx that describes their data. For instance
name is highlighted and they click the last name column in their data
and check the last name check box and the same for first, then click
the next button. This is supposed to bind the checkbox title with the
column heads so I can concatenate them into the proper column. It is
then supposed to move the highlighted cell in the ShouldBe datagrid
down one and allow them to proceed, until at the end I have a dataset
that is in the proper format, despite its original format. I have
figured out how to create a column of combined columns with ADO using
the expression property but I'm still learning how to do the rest.

If anyone can give me any advice, tell me a better or easier way to
accomplish this and point me in a direction to learn how to do so, or
simply say you're doing it the best way, I would really appreciate
it.(sorry I'm a novice...my first job)

Thanks!

Paul Huff

.

Relevant Pages

  • RE: Dynamic Data binding
    ... Mapping is always fun. ... > column heads so I can concatenate them into the proper column. ... > that is in the proper format, ... > it.(sorry I'm a novice...my first job) ...
    (microsoft.public.dotnet.framework)
  • Re: detect Inf or NaN
    ... You know they're IEEE functions because of the MODULE ... named thingos are excellent examples of proper naming practices. ... Excellent advice for languages like C where there are no module ...
    (comp.lang.fortran)
  • Re: Using the HMS functions in a user RPL program.
    ... to decide when it's proper to use these functions, ... between Polar and Rectangular coordinates; ... The format itself, however, inherently introduces ...
    (comp.sys.hp48)
  • Re: What do I need to use Terminal Server?
    ... It's taken as offered and all good advice. ... I'm starting to see some major modifications to the overall network setup ... Then, based on what I found in #1, I would order the proper hardware ... and software for you - server, workstations, SQL Server if required, ...
    (microsoft.public.windowsxp.general)
  • Re: DataGridView, Formatting a Numeric Column
    ... setting the Format after setting the Alignment. ... I'll be doing some more trashing about in the documentation and the ... further advice I'd be most grateful. ... (Not that the doc said "n" would provide right justification, ...
    (microsoft.public.dotnet.languages.vb.controls)