I've got a datatable with 3 columns:
-A string
-A datetime
-An expression-based column

I want the expression based column to be a representation of both of the 
other columns. The expression looks like:

ColString + ' ' + ColDate

The only problem is that the datetime format is very verbose. I don't need 
the time at all, and I'd rather only have the month and year. Is there any 
way to adjust this formatting in this scenario?

Thanks...

-Ben

Hi benji,

You might consider playing with SUBSTRING function or do the filling 
manually instead of using expressions.

-- 
Miha Markic [MVP C#, INETA Country Leader for Slovenia]
RightHand .NET consulting & development www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/

"benji"  wrote in message 
news:416DC926-0084-424C-88D4-70FA8F8D21BB@microsoft.com...

> I've got a datatable with 3 columns:
> -A string
> -A datetime
> -An expression-based column
>
> I want the expression based column to be a representation of both of the
> other columns. The expression looks like:
>
> ColString + ' ' + ColDate
>
> The only problem is that the datetime format is very verbose. I don't need
> the time at all, and I'd rather only have the month and year. Is there any
> way to adjust this formatting in this scenario?
>
> Thanks...
>
> -Ben 

Hi Miha,

Thanks for the response. Could you elaborate a bit about doing the filling 
manually?

Thanks...

-Ben

"Miha Markic" wrote:


> Hi benji,
> 
> You might consider playing with SUBSTRING function or do the filling 
> manually instead of using expressions.
> 
> -- 
> Miha Markic [MVP C#, INETA Country Leader for Slovenia]
> RightHand .NET consulting & development www.rthand.com
> Blog: http://cs.rthand.com/blogs/blog_with_righthand/
> 
> "benji"  wrote in message 
> news:416DC926-0084-424C-88D4-70FA8F8D21BB@microsoft.com...
> > I've got a datatable with 3 columns:
> > -A string
> > -A datetime
> > -An expression-based column
> >
> > I want the expression based column to be a representation of both of the
> > other columns. The expression looks like:
> >
> > ColString + ' ' + ColDate
> >
> > The only problem is that the datetime format is very verbose. I don't need
> > the time at all, and I'd rather only have the month and year. Is there any
> > way to adjust this formatting in this scenario?
> >
> > Thanks...
> >
> > -Ben 
> 
> 

"benji"  wrote in message 
news:235E75CE-7667-48BE-9871-4143F408FEE0@microsoft.com...

> Hi Miha,
>
> Thanks for the response. Could you elaborate a bit about doing the filling
> manually?


Use a normal instead of expression column. And then just fill it in a loop 
and when a relevant column value changes (DataTable.ColumnChanged event).

-- 
Miha Markic [MVP C#, INETA Country Leader for Slovenia]
RightHand .NET consulting & development www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/

Hi Miha,

Do you have a suggestion of where to place the loop code? Is there an event 
that you'd suggest I handle for this? (Same question for when data changes)

Thanks...

-Ben

"Miha Markic" wrote:


> 
> "benji"  wrote in message 
> news:235E75CE-7667-48BE-9871-4143F408FEE0@microsoft.com...
> > Hi Miha,
> >
> > Thanks for the response. Could you elaborate a bit about doing the filling
> > manually?
> 
> Use a normal instead of expression column. And then just fill it in a loop 
> and when a relevant column value changes (DataTable.ColumnChanged event).
> 
> -- 
> Miha Markic [MVP C#, INETA Country Leader for Slovenia]
> RightHand .NET consulting & development www.rthand.com
> Blog: http://cs.rthand.com/blogs/blog_with_righthand/ 
> 
> 

I would fill the data after dataset is filled and then I would hook up 
ColumnChanged event to update my data.

-- 
Miha Markic [MVP C#, INETA Country Leader for Slovenia]
RightHand .NET consulting & development www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/

"benji"  wrote in message 
news:317AAAC0-D495-4627-95CC-B1D2FA280857@microsoft.com...

> Hi Miha,
>
> Do you have a suggestion of where to place the loop code? Is there an 
> event
> that you'd suggest I handle for this? (Same question for when data 
> changes)
>
> Thanks...
>
> -Ben
>
> "Miha Markic" wrote:
>
>>
>> "benji"  wrote in message
>> news:235E75CE-7667-48BE-9871-4143F408FEE0@microsoft.com...
>> > Hi Miha,
>> >
>> > Thanks for the response. Could you elaborate a bit about doing the 
>> > filling
>> > manually?
>>
>> Use a normal instead of expression column. And then just fill it in a 
>> loop
>> and when a relevant column value changes (DataTable.ColumnChanged event).
>>
>> -- 
>> Miha Markic [MVP C#, INETA Country Leader for Slovenia]
>> RightHand .NET consulting & development www.rthand.com
>> Blog: http://cs.rthand.com/blogs/blog_with_righthand/
>>
>>