更新datepicker值时出错 [英] Error while updating datepicker value

问题描述

大家好

以下是我的更新查询

更新OrderMaster  set  OrderFrmType = '  G'，OrderDate ='& dtpOrderDate.SelectedDate& '，SMGIDRef ='& j&'，MDIDRef ='& k&'，Remark ='& txtRemark.Text&'，AIDAgencyRef ='& l& '哪里有OrderFormNo ='& cmbOrderNo.Text&' 

我收到以下错误这里



从字符串转换日期和/或时间时转换失败。



请告诉我该怎么做..



谢谢

解决方案

 更新 OrderMaster  set  OrderFrmType = '  G'，OrderDate = ' & dtpOrderDate.SelectedDate.ToString（dd / MMM / yyyy）& '，SMGIDRef = ' & j& '，MDIDRef = ' & k& '，备注= ' & txtRemark.Text& '，AIDAgencyRef = ' & l& ' 其中​​ OrderFormNo = ' & ; cmbOrderNo.Text& '   
 
  - 如果不是多语言，请试试。 
 
  - 多语种然后
 
更新OrderMaster设置OrderFrmType ='G'，OrderDate ='& dtpOrderDate.SelectedDate.ToString（  MM-dd-yyyy）&  < span class =code-string>'，SMGIDRef ='& j&  ' ，MDIDRef ='& k&  '，备注='& ; txtRemark。文本&  '，AIDAgencyRef =' & l&  '其中OrderFormNo ='& cmbOrderNo。< span class =code-keyword>文字&  ' 
 
 
   -   更改您的插入查询。 

欲了解更多信息，请访问我

感谢大家的帮助..

i以下方式获得这个

  Dim  strDate  As  DateTime 
 strDate = DateTime.Parse（dtpOrderDate。 Text，System.Globalization.CultureInfo.CreateSpecificCulture（  en-GB）。DateTimeFormat）
  Dim  formatInfo  As  新 System.Globalization .DateTimeFormatInfo（）
 formatInfo.LongDatePattern =   MM / dd / yyyy 
  Dim  strStartDate  As   String  = strDate.ToString（  MM / dd / yyyy，formatInfo）
 

Hi all
Below is my update query

Update OrderMaster set OrderFrmType='G',OrderDate='" & dtpOrderDate.SelectedDate & "',SMGIDRef='" & j & "',MDIDRef='" & k & "', Remark='" & txtRemark.Text & "', AIDAgencyRef='" & l & "' where OrderFormNo='" & cmbOrderNo.Text & "'"

I am getting the following error here

Conversion failed when converting date and/or time from character string.

Please tell me what to do..

Thanks

解决方案

Update OrderMaster set OrderFrmType='G',OrderDate='" & dtpOrderDate.SelectedDate.ToString("dd/MMM/yyyy") & "',SMGIDRef='" & j & "',MDIDRef='" & k & "', Remark='" & txtRemark.Text & "', AIDAgencyRef='" & l & "' where OrderFormNo='" & cmbOrderNo.Text & "'"

--Please try it if it is not multilingual. 

--If multilingual then 

Update OrderMaster set OrderFrmType='G',OrderDate='" & dtpOrderDate.SelectedDate.ToString("MM-dd-yyyy") & "',SMGIDRef='" & j & "',MDIDRef='" & k & "', Remark='" & txtRemark.Text & "', AIDAgencyRef='" & l & "' where OrderFormNo='" & cmbOrderNo.Text & "'"


--Change your insert query.

For more please visit me

Thanks all for your help..
i got this in below way

Dim strDate As DateTime
             strDate = DateTime.Parse(dtpOrderDate.Text, System.Globalization.CultureInfo.CreateSpecificCulture("en-GB").DateTimeFormat)
             Dim formatInfo As New System.Globalization.DateTimeFormatInfo()
             formatInfo.LongDatePattern = "MM/dd/yyyy"
             Dim strStartDate As String = strDate.ToString("MM/dd/yyyy", formatInfo)

这篇关于更新datepicker值时出错的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！