I have a table in sql and data type is (time(7),null) and I am uploading data to table via c# app. now in code part what ever I did, I could not find "time" data type;
now code for this column is like that;
comm.Parameters.AddWithValue("@TESNO_KALNO", dtr[3].ToString());
(this part is old part) //comm.Parameters.AddWithValue("@OD_NOD", dtr[4].ToString());
if (!string.IsNullOrEmpty(dtr[4].ToString()))
{
comm.Parameters.AddWithValue("@OD_NOD", Convert.ToDateTime(dtr[4].ToString()));
}
else
{
comm.Parameters.AddWithValue("@OD_NOD", DBNull.Value);
OD_NOD column is the source of problem.
what should I do ?
Thank you



