data formatting expression

[Member 3879881]

Hi i am doing some calculation & getting values in decimal..., And i am displaying it in datagrid, in that datagrid columns "data formatting expression" i given as {0:N} Like..., So in that columns,after the decimal i am getting 2 values only..., I tried to store the values in my table..., But its store my first value only..., It Means,its store all row values...,But the value first number only store in the table..., Example value will be 510.01 means...,in table its store only 5..., If i remove the {0:N} "data formatting expression".., then its store the full value like 510.0123..., Whats the probs?, y if i give "data formatting expression" its not store properly..., Anyone solve my probs...,

Magi

[ash04]

Using the data formatting expression does not cause the problem like this. I think it is related with your Database code. Please check it or give the details about the method you are using to save the data into database.

DAsh04

[Member 3879881]

See in datadrid i am getting values in that column like..., Col1 510.09 234.78 12344.76 Values for with in datagrid so i try to store those value in this format(my add button click event) For Each MainGRD As DataGridItem In Me.dgrdsub.Items sqlconn.Open() Dim strInsertproc As String Dim GTotal As Decimal = Val(MainGRD.Cells(3).Text) Dim BonusAmt As Decimal = Val(MainGRD.Cells(5).Text) Try strInsertproc = "BonusAdd'" & GTotal & "','" & BonusAmt & "'" sqlCmd = New SqlCommand(strInsertproc, sqlconn) sqlCmd.ExecuteNonQuery() lblMessage.Text = "Record Inserted............" Catch ex As Exception If Mid(ex.Message, 1, 9) = "Violation" Then lblMessage.Text = "Already exist in the DataBase......" Else lblMessage.Text = Mid(ex.Message, 1, 75) ' Show friendly error message. End If End Try sqlconn.Close() In that col1 if i give {0:N} then the values store in my table like: 5 2 1 If i remove the data formatting expression {0:N} then the values store in my table like: 510.09010 234.787778 12344.766576

Magi

[ash04]

Hi, have you checked what is being stored in the variables "GTotal" and "BonusAmt" during the program execution.

DAsh04

[Member 3879881]

ya i checked if i give data formatting expression{0:N} Then first value..,first number only i am getting..., If i remove that format exp then i am getting correct value...,

Magi

[ash04]

Hi, Format does not cause error like this. Please check the variables' value after statement like Dim GTotal As Decimal = Val(MainGRD.Cells(3).Text) Dim BonusAmt As Decimal = Val(MainGRD.Cells(5).Text) and check your stored procedure "BonusAdd" and its parameter type and width.

DAsh04