Dec 17, 2012, 2:55 PM
Ext.NET error: System.Exception: String was not recognized as a valid DateTime
i have a date colum like this
using the sqldatasource,i am able to insert,update,create ,except of the datecolum.
whenever ,i try to insert data(in this example ,it is a datecolum) ,it is inserted into sqldatabase as NULL value. when i insert a date in sqldatabase manually,and read the data from gridpanel,it seems no problem.it shows all data correctly. But,when i try to update date on the form ,it gives me a error somethink like this:
for example when updating date something like this 2012-12-15 ,it gives the error like above ,however when i try to update date something like this 2012-12-11(a value that doesnt pass the 12,it seems work fine) ,it doesnt give a error at all.
is there a bug related to "date format" in EXT.NET ??
thank you.
<ext:DateColumn ID="DateColumn4" runat="server" DataIndex="Purchasedate" Text="Purchasedate" Format="yyyy-MM-dd" Flex="1" />using the sqldatasource,i am able to insert,update,create ,except of the datecolum.
whenever ,i try to insert data(in this example ,it is a datecolum) ,it is inserted into sqldatabase as NULL value. when i insert a date in sqldatabase manually,and read the data from gridpanel,it seems no problem.it shows all data correctly. But,when i try to update date on the form ,it gives me a error somethink like this:
{serviceResponse:{success:false,message:"System.Exception: String was not recognized as a valid DateTime. ---> System.FormatException: String was not recognized as a valid DateTime.\r\n at System.DateTimeParse.Parse(String s, DateTimeFormatInfo dtfi, DateTimeStyles styles)\r\n at System.Convert.ToDateTime(String value, IFormatProvider provider)\r\n at System.String.System.IConvertible.ToDateTime(IFormatProvider provider)\r\n at System.Convert.ChangeType(Object value, TypeCode typeCode, IFormatProvider provider)\r\n at System.Web.UI.WebControls.Parameter.GetValue(Object value, String defaultValue, TypeCode type, Boolean convertEmptyStringToNull, Boolean ignoreNullableTypeChanges)\r\n at System.Web.UI.WebControls.Parameter.GetValue(Object value, Boolean ignoreNullableTypeChanges)\r\n at System.Web.UI.WebControls.SqlDataSourceView.AddParameters(DbCommand command, ParameterCollection reference, IDictionary parameters, IDictionary exclusionList, String oldValuesParameterFormatString)\r\n at System.Web.UI.WebControls.SqlDataSourceView.ExecuteUpdate(IDictionary keys, IDictionary values, IDictionary oldValues)\r\n at System.Web.UI.DataSourceView.Update(IDictionary keys, IDictionary values, IDictionary oldValues, DataSourceViewOperationCallback callback)\r\n at Ext.Net.Store.MakeUpdates(IDataSource ds, JArray data) in C:\\Users\\Geoffrey McGill\\Documents\\Visual Studio 2010\\Projects\\Ext.NET\\v2\\Ext.Net\\Ext\\Data\\Store.cs:line 890\r\n at Ext.Net.Store.MakeChanges() in C:\\Users\\Geoffrey McGill\\Documents\\Visual Studio 2010\\Projects\\Ext.NET\\v2\\Ext.Net\\Ext\\Data\\Store.cs:line 829\r\n at Ext.Net.Store.DoSaving(String action, String jsonData, JToken parameters) in C:\\Users\\Geoffrey McGill\\Documents\\Visual Studio 2010\\Projects\\Ext.NET\\v2\\Ext.Net\\Ext\\Data\\Store.cs:line 793\r\n --- End of inner exception stack trace ---\r\n at Ext.Net.Store.DoSaving(String action, String jsonData, JToken parameters) in C:\\Users\\Geoffrey McGill\\Documents\\Visual Studio 2010\\Projects\\Ext.NET\\v2\\Ext.Net\\Ext\\Data\\Store.cs:line 806\r\n at Ext.Net.Store.RaiseAjaxPostBackEvent(String eventArgument) in C:\\Users\\Geoffrey McGill\\Documents\\Visual Studio 2010\\Projects\\Ext.NET\\v2\\Ext.Net\\Ext\\Data\\Store.cs:line 1131",data:}}for example when updating date something like this 2012-12-15 ,it gives the error like above ,however when i try to update date something like this 2012-12-11(a value that doesnt pass the 12,it seems work fine) ,it doesnt give a error at all.
is there a bug related to "date format" in EXT.NET ??
thank you.
