How to cast SQLiteDataReader values into float in c#

Question

I am struggling with a small issue: conversion of SqliteDataReader values into float. I am demonstrating how I am trying to cast.

Pricing pricing = null;
SQLiteConnection con = new SQLiteConnection(thisApp.dbConnectionString);
try
{
   string _sql = "select * from pricing where id=@id";
   SQLiteCommand command = new SQLiteCommand(_sql, con);
   command.Parameters.AddWithValue("id", myid);
   con.Open();
   SQLiteDataReader reader = command.ExecuteReader();
   if (reader.HasRows)
   {
      while (reader.Read())
      {
          pricing = new Pricing()
          {
              // "ActualPrice" in my model and "actual_price" in sqlite db are Float type.
              // But here i am getting error saying cast is not allowed
              // It tried one more way as well but didn't work.
              ActualPrice = Convert.ToInt32(reader["actual_price"])
              // OR
              ActualPrice = (float) Convert.ToInt32(reader["actual_price"])
          };
      }
   }               
 }
 catch
 {
 }
 finally
 {
    if (con.State != ConnectionState.Closed)
       con.Close();
 }
 return pricing;

Can you help me how can I get values from reader["actual_price] into my property ActualPrice?

Sebastian · Accepted Answer · 2016-02-24 09:00:09Z

1

My suggestion is

First try to read the column value as a string like

   Pricing pricing = new Pricing();
    string string_val=convert.ToString(reader["actual_price"]);

Then use a TryParse

If your property is of type double use double.TryParse

float _val=0;

float.Tryparse(string_val,out _val);

Then assign model property like

pricing.ActualPrice =_val;

The benefit of doing string conversion & then Tryparse is it will helps you to handle null value exceptions

Might be this can be done in some other simpler ways as well

edited Feb 24, 2016 at 9:00

answered Feb 24, 2016 at 8:50

Sebastian

4,86119 gold badges89 silver badges161 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Ashish-BeJovial Over a year ago

my property dataType is not double its float, so this double.Tryparse will work ? But i try first this solution.

Sebastian Over a year ago

Use float Trypasre [ see edit in answer] . My point is instead of trying direct type conversion Use TryParse

Collectives™ on Stack Overflow

How to cast SQLiteDataReader values into float in c#

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related