Used dhtmlx Components:
dhtmlxConnector_net_v15_130416 and dhtmlx 3.6 professional
Data Servers tested SQL 2008 2008R2 and 2012
aspx Code: (used from connector sample to hold it easy, just dataProcessor, pub_date and button save is added)
Front-End:
<asp:Content ID=“MainContent” ContentPlaceHolderID=“FormContentPlaceholder” runat=“server”>
<input type="button" onclick="myForm.load('basic_init.ashx?id=25');" value="Load data" />
<input type="button" onclick="myForm.save();" value="Save data" />
</asp:Content>
webhandler:
[WebService(Namespace = “http://tempuri.org/”)]
[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
public class form_basic_connector : dhtmlxRequestHandler
{
public override IdhtmlxConnector CreateConnector(HttpContext context)
{
var connector = new dhtmlxFormConnector(
"BookStore",
"title,author,price,pub_date",
"book_id",
dhtmlxDatabaseAdapterType.SqlServer2005,
ConfigurationManager.ConnectionStrings["SamplesDatabase"].ConnectionString
);
return connector;
}
}
behavior:
Date in pub_date: 2034-05-01
If i read the Row all goes well:
ID25
7\n
22222,1
<pub_date>2034-05-01 00:00:00</pub_date>
As soon i will save the data:
25_!nativeeditor_status updated
25_author 7\n
25_price 22222,1
25_pub_date Mon May 01 2034 00:00:00 GMT+0200
25_title ID25
ids 25
And the update fails. Reason:
Mon May 01 2034 00:00:00 GMT+0200
Ok I switched already from date/datetime to varchar(255). This works but i can’t read back the date after first save. Because not 2034-05-01 00:00:00 is stored its Mon May 01 2034 00:00:00 GMT+0200 from now.
For the moment I suspect a convert date bug within the connector DLL, and I hope you can reproduce and resolve the problem. (For the moment my development is completely stuck. And my customers i already a bit upset.