I don't really understand why this code doesn't work?
The error says,Code:dr.BeginEdit(); dr["ACSDate"] = hdnField.Value; dr["FormNum"] = txtFormNumberNew.Text; dr["ResponsiblePerson"] = txtResponsiblePersonNew.Text; dr["SiteCodeID"] = GlobalVariable.g_sitecodeID; dr.EndEdit(); da.Update(ds, "tblAsset"); ds.AcceptChanges();
The value of hdnField.Value was taken in this code:Incorrect date value: '5/30/2007 7:07:13 PM' for column 'ACSDate' at row 1
What I am using is ASP.net using C# and my database is MySQL AB Database.Code:DateTime timeNow = DateTime.Now; string myTime = timeNow.ToString("h:mm:ss tt"); string acsdate = ddlMonth.SelectedValue + "/" + ddlDays.SelectedValue + "/" + ddlYear.SelectedValue + " " + myTime; hdnField.Value = acsdate;




Reply With Quote