How do I add a new column cominging 2 string and a int column ?

[Alpha]

Is there any way to create a new column in a dataset table from 2 string
column and a int column? I got an error "expecting string" from my code
below. Any help would be appreciated.

DataColumn scc1 = new
DataColumn("Cod eLength",Type.G etType("System. String"));
scc1.Expression = "iif(len(CycleL ength) > 0,CycleCode + ' - ' +
CycleLength,Cyc leCode)";
dsSchTables.Tab les["ServiceCyc le"].Columns.Add(sc c1);
dsSchTables.Acc eptChanges();

DataColumn scc2 = new
DataColumn("Cod eLengthUnit",Ty pe.GetType("Sys tem.String"));
scc1.Expression = "iif(len(CycleU nit) > 0,CodeLength + ' - ' +
CycleUnit,CodeL ength)";
dsSchTables.Tab les["ServiceCyc le"].Columns.Add(sc c2);
dsSchTables.Acc eptChanges();

[Cor Ligthert [MVP]]

Alpha,

I am curious about the meaning of the + '-' + in your expression?

Cor

"Alpha" <Al***@discussi ons.microsoft.c om> schreef in bericht
news:97******** *************** ***********@mic rosoft.com...

Is there any way to create a new column in a dataset table from 2 string
column and a int column? I got an error "expecting string" from my code
below. Any help would be appreciated.

DataColumn scc1 = new
DataColumn("Cod eLength",Type.G etType("System. String"));
scc1.Expression = "iif(len(CycleL ength) > 0,CycleCode + ' - ' +
CycleLength,Cyc leCode)";
dsSchTables.Tab les["ServiceCyc le"].Columns.Add(sc c1);
dsSchTables.Acc eptChanges();

DataColumn scc2 = new
DataColumn("Cod eLengthUnit",Ty pe.GetType("Sys tem.String"));
scc1.Expression = "iif(len(CycleU nit) > 0,CodeLength + ' - ' +
CycleUnit,CodeL ength)";
dsSchTables.Tab les["ServiceCyc le"].Columns.Add(sc c2);
dsSchTables.Acc eptChanges();

[Alpha]

That is just part of the string that I would like to display to the user to
make it easier to read the information that are consist of a Code, followed
by a '_' and the the length and unit. It would read something like this in
the combox 3k - 3000 miles
"Cor Ligthert [MVP]" wrote:

Alpha,

I am curious about the meaning of the + '-' + in your expression?

Cor

"Alpha" <Al***@discussi ons.microsoft.c om> schreef in bericht
news:97******** *************** ***********@mic rosoft.com...

Is there any way to create a new column in a dataset table from 2 string
column and a int column? I got an error "expecting string" from my code
below. Any help would be appreciated.

DataColumn scc1 = new
DataColumn("Cod eLength",Type.G etType("System. String"));
scc1.Expression = "iif(len(CycleL ength) > 0,CycleCode + ' - ' +
CycleLength,Cyc leCode)";
dsSchTables.Tab les["ServiceCyc le"].Columns.Add(sc c1);
dsSchTables.Acc eptChanges();

DataColumn scc2 = new
DataColumn("Cod eLengthUnit",Ty pe.GetType("Sys tem.String"));
scc1.Expression = "iif(len(CycleU nit) > 0,CodeLength + ' - ' +
CycleUnit,CodeL ength)";
dsSchTables.Tab les["ServiceCyc le"].Columns.Add(sc c2);
dsSchTables.Acc eptChanges();

[Cor Ligthert [MVP]]

Alpha,

I don't know it, however how would the expression know that it is a
concatination if you use a system.Int32 and a system.string.

If the problem is that your first operand is an integer, than you can maybe
try the trick to add in advance a '' + (double single quote) .

Just a try and a guess

Cor

[Alpha]

Can I fill a dataset table with a SQL SERVER View? That way I can easily
concatenate an cast the int type to string and form a column that way. What
would the sytax be if I can fill with View? I only know so far to do SQL
select from table with Select command object.

Thanks, Alpha

"Cor Ligthert [MVP]" wrote:

Alpha,

I don't know it, however how would the expression know that it is a
concatination if you use a system.Int32 and a system.string.

If the problem is that your first operand is an integer, than you can maybe
try the trick to add in advance a '' + (double single quote) .

Just a try and a guess

Cor

[Alpha]

I created a view in SQL SERVER and I fill the dataset by selecting the
concatenated column from the view and it works. Thanks, Alpha

"Alpha" wrote:

Can I fill a dataset table with a SQL SERVER View? That way I can easily
concatenate an cast the int type to string and form a column that way. What
would the sytax be if I can fill with View? I only know so far to do SQL
select from table with Select command object.

Thanks, Alpha

"Cor Ligthert [MVP]" wrote:

Alpha,

I don't know it, however how would the expression know that it is a
concatination if you use a system.Int32 and a system.string.

If the problem is that your first operand is an integer, than you can maybe
try the trick to add in advance a '' + (double single quote) .

Just a try and a guess

Cor