kamiloted
شنبه 01 آبان 1395, 23:49 عصر
سلام دوستان با کد زیر یه جستجو انجام میدم.توی سیستم خودم با کانشن لوکال و اس کیو ال سرور. به خوبی جواب میده.اما تو سیستم مقصد دارای اس کیو ال اکسپرس
این خطا رو میده مشکل از چیه دوستان؟؟
conversion failed when converting date and / or time from character string
تایپ تاریخم :datetime2(7) هست
DataTable dt = new DataTable();
Database db = new Database();
dt = db.MySelect(" SELECT tbl_Pardakhti_Nasyeh.IdClient,tbl_Pardakhti_Nasyeh .NameClient,tbl_Pardakhti_Nasyeh.codeFactoor,tbl_P ardakhti_Nasyeh.TotalCost,tbl_Pardakhti_Nasyeh.Cos t, " +
"tbl_Pardakhti_Nasyeh.Date,tbl_Factoor_Foroosh.Takh fifKoll,tbl_Pardakhti_Nasyeh.Comments " +
"FROM tbl_Factoor_Foroosh INNER JOIN tbl_Pardakhti_Nasyeh ON tbl_Factoor_Foroosh.codeFactoor = tbl_Pardakhti_Nasyeh.codeFactoor where tbl_Pardakhti_Nasyeh.Date='" + txtDate1.Value.Value.Date + "' group by tbl_Factoor_Foroosh.codeFactoor,tbl_Factoor_Foroos h.TakhfifKoll,tbl_Pardakhti_Nasyeh.IdClient,tbl_Pa rdakhti_Nasyeh.NameClient,tbl_Pardakhti_Nasyeh.cod eFactoor,tbl_Pardakhti_Nasyeh.TotalCost,tbl_Pardak hti_Nasyeh.Cost,tbl_Pardakhti_Nasyeh.Date,tbl_Pard akhti_Nasyeh.Comments");
dt.Columns.Add("تاریخ", typeof(string));
foreach (DataRow row in dt.Rows)
{
string old = PersianDate.GetPdate(DateTime.Parse(row["Date"].ToString()));
row["تاریخ"] = old.ToString();
}
dt.Columns.Remove("Date");
dataGridView1.DataSource = dt;
ممنونم از همگی
این خطا رو میده مشکل از چیه دوستان؟؟
conversion failed when converting date and / or time from character string
تایپ تاریخم :datetime2(7) هست
DataTable dt = new DataTable();
Database db = new Database();
dt = db.MySelect(" SELECT tbl_Pardakhti_Nasyeh.IdClient,tbl_Pardakhti_Nasyeh .NameClient,tbl_Pardakhti_Nasyeh.codeFactoor,tbl_P ardakhti_Nasyeh.TotalCost,tbl_Pardakhti_Nasyeh.Cos t, " +
"tbl_Pardakhti_Nasyeh.Date,tbl_Factoor_Foroosh.Takh fifKoll,tbl_Pardakhti_Nasyeh.Comments " +
"FROM tbl_Factoor_Foroosh INNER JOIN tbl_Pardakhti_Nasyeh ON tbl_Factoor_Foroosh.codeFactoor = tbl_Pardakhti_Nasyeh.codeFactoor where tbl_Pardakhti_Nasyeh.Date='" + txtDate1.Value.Value.Date + "' group by tbl_Factoor_Foroosh.codeFactoor,tbl_Factoor_Foroos h.TakhfifKoll,tbl_Pardakhti_Nasyeh.IdClient,tbl_Pa rdakhti_Nasyeh.NameClient,tbl_Pardakhti_Nasyeh.cod eFactoor,tbl_Pardakhti_Nasyeh.TotalCost,tbl_Pardak hti_Nasyeh.Cost,tbl_Pardakhti_Nasyeh.Date,tbl_Pard akhti_Nasyeh.Comments");
dt.Columns.Add("تاریخ", typeof(string));
foreach (DataRow row in dt.Rows)
{
string old = PersianDate.GetPdate(DateTime.Parse(row["Date"].ToString()));
row["تاریخ"] = old.ToString();
}
dt.Columns.Remove("Date");
dataGridView1.DataSource = dt;
ممنونم از همگی