How to update the sql 2005 DB with decimal values

bex · February 12th, 2009, 08:14 AM

Hi there i need to update the tabel via the gridview.
Every thing works fine if i update integers like 1,2,3... but when i try 0.12, or 0.3 i get Input string was not in a correct format i tryed to change the data type to :int , then money, smallmoney, decimal, numeric with no succes
can any one please tell me how to do this?

thanks

gbianchi · February 12th, 2009, 08:19 AM

Hi there.. Maybe your database is expecting a number with another format? maybe a , instead of a . to separe integer from decimal?

Anyway, can you show us the offending line?? also did you try it directly into the database???

bex · February 12th, 2009, 08:40 AM

Hi thanks for the quick replay
i have not tryed directly to the sql,
here is the table:

Code:

CREATETABLE [dbo].[Campaign](
[CampaignName] [nvarchar](50)NOTNULL,
[Template] [nvarchar](50)NULL,
[PayRate1] [decimal](18, 0)NULL,CONSTRAINT [PK_Campaign] PRIMARYKEYCLUSTERED(

and the stack trace

Code:

[FormatException: Input string was not in a correct format.]
  System.Number.StringToNumber(String str, NumberStyles options, NumberBuffer& number, NumberFormatInfo info, Boolean parseDecimal) +2781995
  System.Number.ParseInt32(String s, NumberStyles style, NumberFormatInfo info) +112
  System.String.System.IConvertible.ToInt32(IFormatProvider provider) +43
  System.Convert.ChangeType(Object value, TypeCode typeCode, IFormatProvider provider) +293
  System.Web.UI.WebControls.Parameter.GetValue(Object value, String defaultValue, TypeCode type, Boolean convertEmptyStringToNull, Boolean ignoreNullableTypeChanges) +264
  System.Web.UI.WebControls.SqlDataSourceView.AddParameters(DbCommand command, ParameterCollection reference, IDictionary parameters, IDictionary exclusionList, String oldValuesParameterFormatString) +557
  System.Web.UI.WebControls.SqlDataSourceView.ExecuteUpdate(IDictionary keys, IDictionary values, IDictionary oldValues) +369
  System.Web.UI.DataSourceView.Update(IDictionary keys, IDictionary values, IDictionary oldValues, DataSourceViewOperationCallback callback) +78
  System.Web.UI.WebControls.GridView.HandleUpdate(GridViewRow row, Int32 rowIndex, Boolean causesValidation) +1215
  System.Web.UI.WebControls.GridView.HandleEvent(EventArgs e, Boolean causesValidation, String validationGroup) +837
  System.Web.UI.WebControls.GridView.OnBubbleEvent(Object source, EventArgs e) +95
  System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +35
  System.Web.UI.WebControls.GridViewRow.OnBubbleEvent(Object source, EventArgs e) +117
  System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +35
  System.Web.UI.WebControls.LinkButton.OnCommand(CommandEventArgs e) +115
  System.Web.UI.WebControls.LinkButton.RaisePostBackEvent(String eventArgument) +132
  System.Web.UI.WebControls.LinkButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7
  System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11
  System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +177
  System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1746

how can i try directly to the db?

bex · February 12th, 2009, 09:11 AM

i did it all i had to do was to use Float DataType