将数据类型字符串导入C＃中的datetime时出错 [英] Error while importing data type string to datetime in C#

问题描述

我编写了一个代码来将Excel数据导入SQL。首先我将excel数据导入数据表，并将该数据表保存到SQL数据库中。我有一个字段数据类型数据时间。导入时我将所有值作为字符串。我在一个存储过程的帮助下保存它们。节省时间我在日期时间字段中遇到错误。





这里是代码。

I wrote a code to import excel data to SQL. There first I m importing excel data into a data table and that data table i am saving into SQL database.I am having one field data type data time. while importing I am taking all values as a string.I am Saving them with the help of one stored procedure. Saving time I am facing error at date time field.


here is the code.

foreach (DataRow xrow in dt.Rows)
               {


                   string siteid = xrow["siteid"].ToString().Trim();
                   string site = xrow["site"].ToString().Trim();



                   DateTime asd = DateTime.Now;

                   asd = Convert.ToDateTime(xrow["asdate"]);//here I got Error



                   string address = xrow["address"].ToString().Trim();
                   string city = xrow["city"].ToString().Trim();
                   string district = xrow["district"].ToString().Trim();
                   string zone = xrow["zone"].ToString().Trim();
                   string rpname = xrow["rpname"].ToString().Trim();
                   string phno = xrow["phno"].ToString().Trim();
                   string lessor = xrow["lessor"].ToString().Trim();
                   string phone = xrow["phone"].ToString().Trim();

                   string fse = xrow["fse"].ToString().Trim();
                   string contact = xrow["contact"].ToString().Trim();
                   string remark1 = xrow["remark1"].ToString().Trim();
                   string remark2 = xrow["remark2"].ToString().Trim();
                   string prodate = xrow["prodate"].ToString().Trim();
                   string restatus = xrow["restatus"].ToString().Trim();
                   string doctype = xrow["doctype"].ToString().Trim();


                   SqlCommand addrow = new SqlCommand("ProductBulkInsertion", con);
                   addrow.CommandType = CommandType.StoredProcedure;
                   //addrow.Parameters.AddWithValue("@company", company);
                   addrow.Parameters.AddWithValue("@siteid", siteid);
                   addrow.Parameters.AddWithValue("@site", site);
                   addrow.Parameters.AddWithValue("@asdate", asd);
                   addrow.Parameters.AddWithValue("@address", address);
                   addrow.Parameters.AddWithValue("@city", city);
                   addrow.Parameters.AddWithValue("@district", district);
                   addrow.Parameters.AddWithValue("@zone", zone);
                   addrow.Parameters.AddWithValue("@rpname", rpname);
                   addrow.Parameters.AddWithValue("@phno", phno);
                   addrow.Parameters.AddWithValue("@lessor", lessor);
                   addrow.Parameters.AddWithValue("@phone", phone);
                   addrow.Parameters.AddWithValue("@fse", fse);
                   addrow.Parameters.AddWithValue("@remark1", remark1);
                   addrow.Parameters.AddWithValue("@remark2", remark2);
                   addrow.Parameters.AddWithValue("@prodate", prodate);
                   addrow.Parameters.AddWithValue("@restatus", restatus);
                   addrow.Parameters.AddWithValue("@doctype", doctype);
                   addrow.ExecuteNonQuery();

错误是

error is

string was not recognized as a valid datetime

我尝试了什么：



我试过tryparse，tryparse extract几乎失败了。我搜索网但没有合适的答案。所以我发布了这里。

What I have tried:

I tried tryparse, tryparse extract and all but failed.I searched net but no suitable answer. So I posted Here.

推荐答案

好的。我的问题解决了。我在excel中将单元格数据类型更改为日期时间，并将所有日期单元格的日期格式更改为单格式为印度格式dd / MM / yyyy。

Ok. My Problem Solved. I changed cell data type to date time in excel itself and I changed date format of all those date cells into single format into Indian format dd/MM/yyyy.

这篇关于将数据类型字符串导入C＃中的datetime时出错的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！