All Questions
6 questions
0
votes
1
answer
97
views
Input string was not in a correct format wtih cm.Parameters.AddWithValue
I got this error message : input string was not in a correct format
It throws this error message at these two codes:
cm.Parameters.AddWithValue("@price", double.Parse(frmCancelDetails....
- 113
0
votes
1
answer
122
views
Why does the Azure SQL Server store and display numbers but not exchange them with C#?
Column datatype
As seen in SSMS "edit top 200 rows"
As returned from a SELECT statement
decimal(29, 26)
< Unable to read data >
-795.00000000000000000000000000
decimal(29, 26)
-790....
- 1,033
1
vote
0
answers
979
views
Conversion between Numeric and Double/Decimal in C#
I'm trying to grab elements from a certain column/Listbox which has the type "numeric" and store them in a List in C#.
datTable = new DataTable();
sqlCmd = new SqlCommand(@
"...
- 175
0
votes
1
answer
494
views
C# correct alternative for SQL Numeric
I've been playing around with Numerics and the c# 128-bit counterpart decimal and noticed some differences. For one, C# decimal is 128-bit, while SQL numeric occupies an extra byte.
What I was ...
- 31.2k
0
votes
2
answers
400
views
Numeric data type formatting after SqlDataReader
I've got another issue, I have a SQL Server database in which I insert data using SqlCommand, one of the columns is numeric, but when I read this column back with this code:
zcena1.Text = precti....
- 3,595
0
votes
2
answers
13k
views
Insert numerical (decimal) data from textbox values
I am confused by the following issue;
I have a C# (WindowsForms) application which I connect to a SQL Server DB and have no problem to INSERT, SELECT, UPDATE... until I started to work with numerical ...
- 91