Add "empty" double value to database

Question

I would like to insert data from xml files to sql database. In my xml files are a lot of diffrent rows. But many rows contain empty double values. When i try to add this to my database i get an error.

Here is a short cut from my database insert:

   Table<Step> step = Accessor.GetStepTable();
                Step stp = new Step();

                stp.Angle1Actual = stepData.Columns.Contains("Angle1Actual") ? double.Parse(stepData.Rows[index][Array.IndexOf(argsStep, "Angle1Actual")].ToString()) : DBNull.Value;

                step.InsertOnSubmit(stp);
                step.Context.SubmitChanges();

The problem is the DBNull is diffrent type

What is the error message you receive? Are you sure the column allows nulls? — SqlZim, Jan 19 '17 at 19:55
DBNull is not "null". [It is a type, a class in the framework](https://msdn.microsoft.com/en-us/library/system.dbnull(v=vs.110).aspx). — radarbob, Jan 19 '17 at 20:00
I found the answer for my problem here [link](http://stackoverflow.com/questions/37202141/parsing-a-dbnull-value-into-double) — Dennis Pichlmeier, Jan 20 '17 at 08:49

Piotshe · Answer 1 · 2017-01-19T20:01:50.410

0

Try using double.TryParse instead of double.Parse. It returns boolean value if the operation was successfull.
Reference: https://msdn.microsoft.com/en-us/library/system.double.tryparse(v=vs.110).aspx

edited Jan 19 '17 at 20:01

answered Jan 19 '17 at 19:56

Piotshe

59
7

score 0 · Answer 2 · edited May 23 '17 at 12:08

0

DBNull is not "null". It is a type, a class in the framework.

Here is an SO question: What is the best way to deal with DBNull's

edited May 23 '17 at 12:08

Community

1
1

answered Jan 19 '17 at 20:03

radarbob

4,964
2
23
36

Add "empty" double value to database

2 Answers2