Trying to change a dataset.table.row.item value

[Matrix.net]

Hi , I'm trying to change a dataset's item's value but cant seem to be able to do it instead it keeps the same value in the dataset.table.row.item . What I'm trying to do in my code is get back a dataset (which has date and time information in one of the cells) and go through each row and change the cell that contains the date/time data to just contain the date information by splitting the date and time based on the space between them and then retaining the first index of the returned array and setting that value back in that dataset.table.row.item .

HERES MY CODE :
While dateCounter < dset.Tables(0).Rows.Count
strDate = Split(dset.Tables(0).Rows(dateCounter).Item(3).ToString, " ")
truncatedDate = strDate.GetValue(0).ToString
dset.Tables(0).Rows(dateCounter).Item(3) = truncatedDate
dateCounter = dateCounter + 1
End While

then after all that , I still get the date and time ! help , this is in .net 2.0

[kashif_82]

After scratching my head about 7 times (and each times = to a new way of doing this), I can only say that by default .net engine wants to stick its "midnight 12AM" timer in there.
What exactly do you want to do with saving the field as date only? If it's just to display could't you use one of the to string method for Date class or do you have any restriction over that?

[Matrix.net]

After scratching my head about 7 times (and each times = to a new way of doing this), I can only say that by default .net engine wants to stick its "midnight 12AM" timer in there.
What exactly do you want to do with saving the field as date only? If it's just to display could't you use one of the to string method for Date class or do you have any restriction over that?

yes its just for display , cause in sql server you get that 12am attached to any date that was entered . So Im just trying to only display the date

[kashif_82]

Well if it is for display only, then why not use CType(whatevercontrol.text, Date).ToShortDateString ???
As I mentioned above, I am not sure if there are limitation/reason to why you are not choosing this method.

[Matrix.net]

Thanks dude