Convert to float when using a reader

Question

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);

}

Vulpes · 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); }

Tharake Gunatilake · Answer

Yes...I'll do it..thanx a lot...

Tharake Gunatilake · Answer

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....

Vulpes · Answer

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));

Tharake Gunatilake · Answer

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 percentageInterest_Id from InterrestRate order by Interest_Id desc; END

Vulpes · Answer

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?

Tharake Gunatilake · Answer

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....

Vulpes · Answer

Try: objir.percentage = reader.GetFloat(reader.GetOrdinal(percentage));