Here is the code: OpenMC400(); iDB2Command cmd = new iDB2Command(); cmd.Connection = cn; cmd.CommandText = @"call UPMITGCUS.RETRIEVE_MEMBER_SUMMARY(@insubno, @inperno, @ingroup, @insubgroup, @inplancode, @indate, @ques)"; cmd.CommandType = System.Data.CommandType.Text; cmd.DeriveParameters(); //Set the parameter values cmd.Parameters["@insubno"].Value = memberNbr; cmd.Parameters["@inperno"].Value = person; cmd.Parameters["@ingroup"].Value = group; cmd.Parameters["@insubgroup"].Value = subGroup; cmd.Parameters["@inplancode"].Value = plancode; cmd.Parameters["@indate"].Value = date; iDB2DataReader dr = cmd.ExecuteReader(); while (dr.Read()) { Console.WriteLine(dr.GetiDB2Char(0).Value.ToString() + " " + dr.GetiDB2Char(1).Value.ToString() + " " + dr.GetiDB2Char(2).Value.ToString() + " " + dr.GetiDB2Char(3).Value.ToString() + " " + dr.GetiDB2Char(4).Value.ToString() + " " + DateTime.Parse(dr.GetiDB2Date(6).ToNativeFormat()) ); } Here is the error: {"String was not recognized as a valid DateTime."} When converting a string to DateTime, parse the string to take the date before putting each variable into the DateTime object. I have tried different things and it still gives me the error. The other variables come out fine when date is commented out. Thanks for any help.arep
OpenMC400(); iDB2Command cmd = new iDB2Command(); cmd.Connection = cn; cmd.CommandText = @"call UPMITGCUS.RETRIEVE_MEMBER_SUMMARY(@insubno, @inperno, @ingroup, @insubgroup, @inplancode, @indate, @ques)"; cmd.CommandType = System.Data.CommandType.Text; cmd.DeriveParameters(); //Set the parameter values cmd.Parameters["@insubno"].Value = memberNbr; cmd.Parameters["@inperno"].Value = person; cmd.Parameters["@ingroup"].Value = group; cmd.Parameters["@insubgroup"].Value = subGroup; cmd.Parameters["@inplancode"].Value = plancode; cmd.Parameters["@indate"].Value = date; iDB2DataReader dr = cmd.ExecuteReader(); while (dr.Read()) { Console.WriteLine(dr.GetiDB2Char(0).Value.ToString() + " " + dr.GetiDB2Char(1).Value.ToString() + " " + dr.GetiDB2Char(2).Value.ToString() + " " + dr.GetiDB2Char(3).Value.ToString() + " " + dr.GetiDB2Char(4).Value.ToString() + " " + DateTime.Parse(dr.GetiDB2Date(6).ToNativeFormat()) ); } Here is the error: {"String was not recognized as a valid DateTime."} When converting a string to DateTime, parse the string to take the date before putting each variable into the DateTime object. I have tried different things and it still gives me the error. The other variables come out fine when date is commented out. Thanks for any help.arep