Please help with converting a Date and a Time string after concate

[Alpha]

I have 2 strings, "12/28/2005" and "16:44:54". I need to conatenate them and
convert them to datetime format so I can assign them to a datetime field in a
datarow. The time is now being converted to the date "12/28/2005". and I
don't know how to concatenate them since "+" won't work after I convert them.
Thanks, Alpha

if (result == "00")
{
char[] separator = {','};
char[] intSep = {'.'};
string lastDate, lastTime, lastMilleage;
DataRow drVeh = dsVehicle.Table s["VehDetail"].Rows[VListing.Curren tRowIndex];
DialogResult msgRet;

string[] replySeparated = ATSReply.Split( separator);
lastDate = replySeparated[2];
lastTime = replySeparated[3];
lastMilleage = replySeparated[4];
lastMilleage = lastMilleage.Su bstring(0, lastMilleage.Le ngth - 3);
string[] intLastMilleage = lastMilleage.Sp lit(intSep);

msgRet = MessageBox.Show ("Would you like to update the vehicle odometer to
" + lastMilleage +
" and the last odometer read date to " + lastDate + " and the read time to
" +
lastTime, "Live Update", MessageBoxButto ns.YesNo, MessageBoxIcon. Question);
if(msgRet == DialogResult.Ye s)
{
DateTime DatelastDate = Convert.ToDateT ime(lastDate);
DateTime TimeLastTime = Convert.ToDateT ime(lastTime);
// DateTime lastDateTime = DatelastDate + TimeLastTime;

drVeh["LastOdometerDa te"] = DatelastDate;
drVeh["LastOdometerRe ading"] = Convert.ToInt32 (intLastMilleag e[0]);
drVeh.EndEdit() ;

}

}

[Ignacio Machin \( .NET/ C# MVP \)]

Hi,
Sorry for the re-post ,check the DateTimeFormatI nfo class for build format
strings
--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation

"Alpha" <Al***@discussi ons.microsoft.c om> wrote in message
news:29******** *************** ***********@mic rosoft.com...

I have 2 strings, "12/28/2005" and "16:44:54". I need to conatenate them
and
convert them to datetime format so I can assign them to a datetime field
in a
datarow. The time is now being converted to the date "12/28/2005". and I
don't know how to concatenate them since "+" won't work after I convert
them.
Thanks, Alpha

if (result == "00")
{
char[] separator = {','};
char[] intSep = {'.'};
string lastDate, lastTime, lastMilleage;
DataRow drVeh =
dsVehicle.Table s["VehDetail"].Rows[VListing.Curren tRowIndex];
DialogResult msgRet;

string[] replySeparated = ATSReply.Split( separator);
lastDate = replySeparated[2];
lastTime = replySeparated[3];
lastMilleage = replySeparated[4];
lastMilleage = lastMilleage.Su bstring(0, lastMilleage.Le ngth - 3);
string[] intLastMilleage = lastMilleage.Sp lit(intSep);

msgRet = MessageBox.Show ("Would you like to update the vehicle odometer to
" + lastMilleage +
" and the last odometer read date to " + lastDate + " and the read time to
" +
lastTime, "Live Update", MessageBoxButto ns.YesNo,
MessageBoxIcon. Question);
if(msgRet == DialogResult.Ye s)
{
DateTime DatelastDate = Convert.ToDateT ime(lastDate);
DateTime TimeLastTime = Convert.ToDateT ime(lastTime);
// DateTime lastDateTime = DatelastDate + TimeLastTime;

drVeh["LastOdometerDa te"] = DatelastDate;
drVeh["LastOdometerRe ading"] = Convert.ToInt32 (intLastMilleag e[0]);
drVeh.EndEdit() ;

}

}

[Ignacio Machin \( .NET/ C# MVP \)]

Hi,

You could use DateTime.ParseE xact( date_String + " " + time_String,
"MM/dd/yyyy HH:mm:ss, CultureInfo.Inv ariantCulture.D ateTimeFormat );
--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation

"Alpha" <Al***@discussi ons.microsoft.c om> wrote in message
news:29******** *************** ***********@mic rosoft.com...

I have 2 strings, "12/28/2005" and "16:44:54". I need to conatenate them
and
convert them to datetime format so I can assign them to a datetime field
in a
datarow. The time is now being converted to the date "12/28/2005". and I
don't know how to concatenate them since "+" won't work after I convert
them.
Thanks, Alpha

if (result == "00")
{
char[] separator = {','};
char[] intSep = {'.'};
string lastDate, lastTime, lastMilleage;
DataRow drVeh =
dsVehicle.Table s["VehDetail"].Rows[VListing.Curren tRowIndex];
DialogResult msgRet;

string[] replySeparated = ATSReply.Split( separator);
lastDate = replySeparated[2];
lastTime = replySeparated[3];
lastMilleage = replySeparated[4];
lastMilleage = lastMilleage.Su bstring(0, lastMilleage.Le ngth - 3);
string[] intLastMilleage = lastMilleage.Sp lit(intSep);

msgRet = MessageBox.Show ("Would you like to update the vehicle odometer to
" + lastMilleage +
" and the last odometer read date to " + lastDate + " and the read time to
" +
lastTime, "Live Update", MessageBoxButto ns.YesNo,
MessageBoxIcon. Question);
if(msgRet == DialogResult.Ye s)
{
DateTime DatelastDate = Convert.ToDateT ime(lastDate);
DateTime TimeLastTime = Convert.ToDateT ime(lastTime);
// DateTime lastDateTime = DatelastDate + TimeLastTime;

drVeh["LastOdometerDa te"] = DatelastDate;
drVeh["LastOdometerRe ading"] = Convert.ToInt32 (intLastMilleag e[0]);
drVeh.EndEdit() ;

}

}

[Alpha]

Thank you Ignacio. That worked out great!

Alpha

"Ignacio Machin ( .NET/ C# MVP )" wrote:

Hi,

You could use DateTime.ParseE xact( date_String + " " + time_String,
"MM/dd/yyyy HH:mm:ss, CultureInfo.Inv ariantCulture.D ateTimeFormat );
--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation

"Alpha" <Al***@discussi ons.microsoft.c om> wrote in message
news:29******** *************** ***********@mic rosoft.com...

I have 2 strings, "12/28/2005" and "16:44:54". I need to conatenate them
and
convert them to datetime format so I can assign them to a datetime field
in a
datarow. The time is now being converted to the date "12/28/2005". and I
don't know how to concatenate them since "+" won't work after I convert
them.
Thanks, Alpha

if (result == "00")
{
char[] separator = {','};
char[] intSep = {'.'};
string lastDate, lastTime, lastMilleage;
DataRow drVeh =
dsVehicle.Table s["VehDetail"].Rows[VListing.Curren tRowIndex];
DialogResult msgRet;

string[] replySeparated = ATSReply.Split( separator);
lastDate = replySeparated[2];
lastTime = replySeparated[3];
lastMilleage = replySeparated[4];
lastMilleage = lastMilleage.Su bstring(0, lastMilleage.Le ngth - 3);
string[] intLastMilleage = lastMilleage.Sp lit(intSep);

msgRet = MessageBox.Show ("Would you like to update the vehicle odometer to
" + lastMilleage +
" and the last odometer read date to " + lastDate + " and the read time to
" +
lastTime, "Live Update", MessageBoxButto ns.YesNo,
MessageBoxIcon. Question);
if(msgRet == DialogResult.Ye s)
{
DateTime DatelastDate = Convert.ToDateT ime(lastDate);
DateTime TimeLastTime = Convert.ToDateT ime(lastTime);
// DateTime lastDateTime = DatelastDate + TimeLastTime;

drVeh["LastOdometerDa te"] = DatelastDate;
drVeh["LastOdometerRe ading"] = Convert.ToInt32 (intLastMilleag e[0]);
drVeh.EndEdit() ;

}

}