Dim DesinNum As DataColumn = New DataColumn
With DesinNum
.ColumnName = "DEsign#"
.Expression = "ISNULL(usrini,'')+design+typcde"
End With
With Design_dt.Columns
.Add(DesinNum)
End With
These are the results I'm getting
usrini="J", Design=123,typcde=cst expression=j123cst
usrini="J", Design=123,typcde="" expression=""
I have this code to add a new colum in the datagrid.
It seams to work ok except when the typcde is blank the design# is blank.
I'm using this on vb2008
can anyone help me with this expression?