Convert to float when using a reader

Tharake Gunatilake

15y5.9kVisual Basic .NET

2 commented lines give errors..plz help me to correct it...im a biginner...

if (reader.Read())

{

BE.InterestRate objir = new BE.InterestRate();

//objir.percentage = reader.GetFloat(Convert.ToString("percentage"));

//objir.percentage =float.Parse(Convert.ToString(reader.GetOrdinal("percentage")));

objir.Interest_Id = reader.GetInt32(reader.GetOrdinal("Interest_Id"));

objIR.Add(objir);

}

8 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vulpes15y ago
Accepted answer
Thank-you Tharake, pleased that I was able to help :)

Incidentally, if the column could be null, it might be a good idea to check for that before reading any more values:

int ordinal = reader.GetOrdinal("percentage");
if(!reader.IsDBNull(ordinal))
{
objir.percentage = (float)reader.GetDouble(ordinal);
}
0
Tharake Gunatilake15y ago
Yes...I'll do it..thanx a lot...
0
Tharake Gunatilake15y ago
Yes yes yes............It is working....Thank you very much for your help....
I have no words to thank you....Good luck..
I'm a sri lankan and tomorrow is our new year day...
Wish you a happy new year....
0
Vulpes15y ago
Because of the error you're getting my suspicion is that it's a double precision floating point number in the database.

I'd test this hypothesis with:

objir.percentage = (float)reader.GetDouble(reader.GetOrdinal("percentage"));
0
Tharake Gunatilake15y ago
1.In database "percentage" is a float and it allows null.
2.this is the BE.InterestRate class

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace EdiriPawnBro.BE
{
   public class InterestRate
   {
   public int Interest_Id { get; set; }
   public float percentage { get; set; }
   public DateTime end_date { get; set; }
   public DateTime start_date { get; set; }

   }
   public class InterestRateList : List
   { }
}
this is the SP to get the things....

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO

ALTER PROCEDURE [dbo].[getLatestInterestRate]

AS
BEGIN

SET NOCOUNT ON;
select top 1 percentage,Interest_Id
from InterrestRate
order by Interest_Id desc;

END
0
Vulpes15y ago
Can you tell me what are the types of the following: -

1. The "percentage" column in the database; and

2. The objir.percentage property.

Is there any chance that the column could contain null values?
0
Tharake Gunatilake15y ago
it gives an exception "Specified cast is not valid".........................

following one works...
objir.Interest_Id = reader.GetInt32(reader.GetOrdinal("Interest_Id"));
I want to get the percentage....Plz help me....

0
Vulpes15y ago
Try:

objir.percentage = reader.GetFloat(reader.GetOrdinal("percentage"));
0