RE: Dynamic Data binding

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



Mapping is always fun. Having built numerous mapping pieces, I can safely say
that custom is not always better.

As an option, consider BizTalk. It has an orchestration piece that solves
the majority of mapping needs without having to write a single line of code.
It is not cheap, but you will find that your mapping program will continue to
grow and grow as you add new clients. Ultimately, this could end up with
great expense from your time.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

***************************
Think Outside the Box!
***************************


"Phuff" wrote:

> 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: Biztalk 2002 - 2006 rearchitecture advice
    ... There are guidelines available in the BTS2006 online documentation concerning the migration of BTS2002 projects. ... EDI currently is a bit of pain in BTS2006, I personally use flat file functionality to process it and do not use the EDI adapter in BTS2006 - it is a mess. ... The 02 project is heavy on mapping, ... get's mapped to our canonical PO format. ...
    (microsoft.public.biztalk.server)
  • Enumerating formatting strings
    ... I was messing about with formatting and realized that the right kind of object could quite easily tell me exactly what accesses are made to the mapping in a string % mapping operation. ... return x def nameList: if self.names: ... I've been wondering whether it's possible to perform a similar analysis on non-mapping-type format strings, so as to know how long a tuple to provide, or whether I'd be forced to lexical analysis of the form string. ...
    (comp.lang.python)
  • Re: Delphi and EDI import/export
    ... This is a step what is not here - nice, user friendly mapping with ability ... of lookups, postprocessing, orchestration, etc ... > Delphi that can load, parse, format*, construct, and save EDI files. ... > transaction data is formed into a document structure. ...
    (borland.public.delphi.non-technical)
  • Re: VHDL jpeg image processing
    ... have provided c++ code from my supervisor and there are several format ... I can choose for mapping, bitmap png, ppg etc. ...
    (comp.lang.vhdl)
  • Dynamic Data binding
    ... I am looking for some quick advice on the methods I'm ... 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)