Name of the column mapping UI control?

I am developing a transformation component and I'd like the gui to feature one of the mapping controls that are used for mapping input columns to, for example, SQL Server database columns in the OLE Database Destintation component, among others. I cannot for the life of me discover what the control is called or even whether it is available for general use. Can anyone help me out? Sorry if this is OT but it seemed like the people here would be the most likely to know immediatelly what I was on about.

Thanks
Charlie.

I am trying to do a similar thing and the tool you described would be useful for me too. Did you have any luck finding it?

Your help will be greatly appreciated,

Savita

|||No not at all. I ended up using a tree view to show the mapping and two list boxes, one for each side of the mapping. It doesn't look *great* but it works and besides, the mapping component I was talking about is pretty hellish to actually use if the mapping involves lots of lines that cross over. Even SSIS has two views on the same thing to make it look fancy and be clear.

Charlie|||As far as I know, and I have asked and looked, that control and much of the data flow UI controls are both undocumented and/or inaccessible. In fact I don't think the UI is managed at all, so would be rather nasty to try and use even if you could find and access it.

Name of the column mapping UI control?

I am developing a transformation component and I'd like the gui to feature one of the mapping controls that are used for mapping input columns to, for example, SQL Server database columns in the OLE Database Destintation component, among others. I cannot for the life of me discover what the control is called or even whether it is available for general use. Can anyone help me out? Sorry if this is OT but it seemed like the people here would be the most likely to know immediatelly what I was on about.

Thanks
Charlie.

I am trying to do a similar thing and the tool you described would be useful for me too. Did you have any luck finding it?

Your help will be greatly appreciated,

Savita

|||No not at all. I ended up using a tree view to show the mapping and two list boxes, one for each side of the mapping. It doesn't look *great* but it works and besides, the mapping component I was talking about is pretty hellish to actually use if the mapping involves lots of lines that cross over. Even SSIS has two views on the same thing to make it look fancy and be clear.

Charlie
|||As far as I know, and I have asked and looked, that control and much of the data flow UI controls are both undocumented and/or inaccessible. In fact I don't think the UI is managed at all, so would be rather nasty to try and use even if you could find and access it.

Name of the column mapping UI control?

I am developing a transformation component and I'd like the gui to feature one of the mapping controls that are used for mapping input columns to, for example, SQL Server database columns in the OLE Database Destintation component, among others. I cannot for the life of me discover what the control is called or even whether it is available for general use. Can anyone help me out? Sorry if this is OT but it seemed like the people here would be the most likely to know immediatelly what I was on about.

Thanks
Charlie.

I am trying to do a similar thing and the tool you described would be useful for me too. Did you have any luck finding it?

Your help will be greatly appreciated,

Savita

|||No not at all. I ended up using a tree view to show the mapping and two list boxes, one for each side of the mapping. It doesn't look *great* but it works and besides, the mapping component I was talking about is pretty hellish to actually use if the mapping involves lots of lines that cross over. Even SSIS has two views on the same thing to make it look fancy and be clear.

Charlie|||As far as I know, and I have asked and looked, that control and much of the data flow UI controls are both undocumented and/or inaccessible. In fact I don't think the UI is managed at all, so would be rather nasty to try and use even if you could find and access it.sql

n tier development strategy question

I don't know where to post this question-or maybe its a comment and I am
just looking for reactions.
We are developing a multi-tiered web app where all database access goes
through a Business Object layer which resides on a machine that is not the
db server.
I am trying to develop the Business Objects in such a way that the web tier
which uses them does not access datasets directly themselves. Instead, the
Business Objects layers provides objects and collection classes representing
the data in the database.
It seems that I am always presented with a trade off of choosing between
encapsulation and performance.
For example, in order to instantiate an object A, the object needs to talk
to the database. So the code for this is encaptulated in A.New. But then, if
object B needs three local instances of object A, each instance will result
in A.New making 3 round trips to the database! To code for performance, I
would have have B return ALL of the data needed to instantiate 3 A's and
pass that to a Friend A.New constructor, but this is at the expenses of
encapsulation and reusuability of objects!
Does this make sense!
HHHHHHHHHHHHHHEEEEEEEEEEEEEEEEEEEEEEEEEE
EEELLLLLLLLLLLLLLLLLLLP
It's driving me nuts not knowing what to do!
Is this a common design problem faced by apps that have a Biz Object layer?The business logic itself may be unique to your applicaiton, but there are
proven and widely accepted design patterns for passing data between the
tiers. For example:
Data Access Application Block
http://msdn.microsoft.com/library/d...aab.
asp
Designing Data Tier Components and Passing Data Through Tiers
http://msdn.microsoft.com/library/d...Gag
.asp
"Chad" <chad.dokmanovich@.unisys.com> wrote in message
news:djj90u$qo0$1@.trsvr.tr.unisys.com...
>I don't know where to post this question-or maybe its a comment and I am
>just looking for reactions.
> We are developing a multi-tiered web app where all database access goes
> through a Business Object layer which resides on a machine that is not the
> db server.
> I am trying to develop the Business Objects in such a way that the web
> tier which uses them does not access datasets directly themselves.
> Instead, the Business Objects layers provides objects and collection
> classes representing the data in the database.
> It seems that I am always presented with a trade off of choosing between
> encapsulation and performance.
> For example, in order to instantiate an object A, the object needs to talk
> to the database. So the code for this is encaptulated in A.New. But then,
> if object B needs three local instances of object A, each instance will
> result in A.New making 3 round trips to the database! To code for
> performance, I would have have B return ALL of the data needed to
> instantiate 3 A's and pass that to a Friend A.New constructor, but this is
> at the expenses of encapsulation and reusuability of objects!
>
> Does this make sense!
>
> HHHHHHHHHHHHHHEEEEEEEEEEEEEEEEEEEEEEEEEE
EEELLLLLLLLLLLLLLLLLLLP
> It's driving me nuts not knowing what to do!
> Is this a common design problem faced by apps that have a Biz Object
> layer?
>
>|||On Mon, 24 Oct 2005 14:27:22 -0400, "Chad"
<chad.dokmanovich@.unisys.com> wrote:
>Is this a common design problem faced by apps that have a Biz Object layer?
Yes.
Google is your friend, it's been endlessly discussed.
My position is that a better appreciation of relational databases as
hold a data model, rather than loose tables, is the first step towards
wisdom.
J.

My question would have been...

Hi,

I am developing an application using C#.NET that accesses a remote database that that contains japanese characters.

My sample querry is strCommand = "SELECT * FROM table WHERE prodname = 'ＣＲ新海物語スペシャルＭ８'";

The result of querry displayed in the binded datagrid also contains other rows that has this prodname:

ＣＲＦ湯けむり紀行ＳＦ－Ｔ
ＣＲぱちんこハイサイＶＲ１
ＣＲホワイトエンジェルＦＳ

etc.

Thanks in advance for your help.

You forgot to ask a question.
|||

Hi,

I am developing an application using C#.NET that accesses a remote database that that contains japanese characters.

My sample querry is strCommand = "SELECT * FROM table WHERE prodname = 'ＣＲ新海物語スペシャルＭ８'";

The result of the querry above that is displayed in the binded datagrid also contains other rows that has this prodname:

ＣＲＦ湯けむり紀行ＳＦ－Ｔ
ＣＲぱちんこハイサイＶＲ１
ＣＲホワイトエンジェルＦＳ

etc.

Why does the command yields other records where the prodname field contains the 'CR' thing?

Sample querry result in a datagrid:

field1 field2 field3 prodname

a as er ＣＲ新海物語スペシャルＭ８

w aa ww ＣＲＦ湯けむり紀行ＳＦ－Ｔ

ss dd ee ＣＲぱちんこハイサイＶＲ1

sdds ddd ee ＣＲ新海物語スペシャルＭ８

rf d5r wwe ＣＲぱちんこハイサイＶＲ１

Does this strange and redundant output has something to do with the Japanese characters contained in some fields

of the table?

Thanks in advance for your help.

|||Try with the correct nvarchar syntax:

SELECT * FROM table WHERE prodname = N'ＣＲ新海物語スペシャルＭ８'

My Query

Hello!
Can any one help me solve this??
I am using MS SQL 2000 database for developing crystal reports for my company.
Now in this I am doing as follows:
I want to concate "dataset_" string with End_A--which is a column name in one table.(Result is like "dataset_1464")I am storing this result in a variable A.
And,now result of this query (A) is name of one table in same database.
Can I use this result ,i.e. A to get MM, which is a column in A.
Here I want to use A instead of dataset_1464.
Please help me if its possible.
thanks in advance,
chandreshselect @.var1 = 'dataset_'+convert(varchar(30),END_A) from table_A

sp_executesql ('select mm from '+@.var1)|||select @.var1 = 'dataset_'+convert(varchar(30),END_A) from table_A

sp_executesql ('select mm from '+@.var1)

HI Thanks alot for prompt reply...
I used this method but it still gives me error like:
Server: Msg 170, Level 15, State 1, Line 4
Line 4: Incorrect syntax near 'select mm from '.

wht colud be the reason???
thanks (again) in advance..
chandresh