如何转换日期和时间？ [英] how to convert the Date and time ?

问题描述

I have one exception (Conversion failed when converting date and/or time from character string.) 

how to convert this please help me.

This my coding

protected void Save(object sender, EventArgs e)
  {

      conn();

      string ImgSmall = Path.GetFileName(fileuploadimgsmall.PostedFile.FileName);
      fileuploadimgsmall.SaveAs(Server.MapPath("ImagesSmall/" + ImgSmall));

      string ImgLarge = Path.GetFileName(fileuploadimglarge.PostedFile.FileName);
      fileuploadimglarge.SaveAs(Server.MapPath("ImagesLarge/" + ImgLarge));

      objcmd = new SqlCommand("Insert into TBL_PDT_IMG(PDT_ID,IMG_NAME,IMG_DESC,PDT_IMAGE_SMALL,PDT_IMAGE_LARGE,IS_PRIMARY,Created_by,Created_dt,Changed_by,Changed_dt) values(@PDT_ID,@IMG_NAME,@IMG_DESC,@PDT_IMAGE_SMALL,@PDT_IMAGE_LARGE,@IS_PRIMARY,@Created_by,@Created_dt,@Changed_by,@Changed_dt)", objcon.con);

      objcmd.Parameters.AddWithValue("@PDT_ID", ddlproduct.SelectedValue);
      objcmd.Parameters.AddWithValue("@IMG_NAME", txtimgname.Text.Trim());
      objcmd.Parameters.AddWithValue("@IMG_DESC", txtimgdesc.Text.Trim());
      objcmd.Parameters.AddWithValue("@PDT_IMAGE_SMALL", "ImagesSmall/" + ImgSmall);
      objcmd.Parameters.AddWithValue("@PDT_IMAGE_LARGE", "ImagesLarge/" + ImgLarge);
      objcmd.Parameters.AddWithValue("@IS_PRIMARY", chkstatus.Checked);
      objcmd.Parameters.AddWithValue("@Created_by", "RG");
      objcmd.Parameters.AddWithValue("@Created_dt",DateTime.Now.ToString());
      objcmd.Parameters.AddWithValue("@Changed_by", ',');
      objcmd.Parameters.AddWithValue("@Changed_dt", ',');
      objcmd.ExecuteNonQuery();

      bind();

}

}

推荐答案

@Created_dt 参数将值插入表格的 Created_dt 字段，该字段很可能是日期时间字段。



只需在此行中传递 DateTime.Now 而不是 DateTime.Now.ToString（）：

@Created_dt parameter inserts value into Created_dt field of your table which most likely is a datetime field.

Just pass DateTime.Now instead of DateTime.Now.ToString() in this line:

objcmd.Parameters.AddWithValue("@Created_dt",DateTime.Now.ToString());

它应该没问题。

and it should be fine.

1）可能是因为很多原因，一个是数据输入

2）日期不能是'，'

3）而是传递null或默认日期时间1900-01-01



更改为此并试一试

************* *********

objcmd.Parameters.AddWithValue（@ Changed_dt，null）;

1) it might be because of many reasons one is the Data input
2) the date cannot be ','
3) instead pass null or default datetime 1900-01-01

change it to this and give a try
**********************
objcmd.Parameters.AddWithValue("@Changed_dt", null);

这篇关于如何转换日期和时间？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！