Retrieve a float from database and adding to local variable

Question

i have a problem with setting the value of the local variable, after i have retrieved the float value from my database. It says it is not the same type, samplerate and the value from (float)rdr["samplerate_hz"]; My code i like this.

    public float hentSampleRateDOEDB(Int64 ekgmaaleid)
    {
        float samplerate = 0.0f;
        connDOEDB.Open();

        SqlCommand cmd = new SqlCommand("SELECT samplerate_hz FROM EKGDATA WHERE ekgmaaleid = '" + ekgmaaleid + "'", connDOEDB);
        SqlDataReader rdr = cmd.ExecuteReader();
        while(rdr.Read())
            samplerate = (float)rdr["samplerate_hz"];
        rdr.Close();
        connDOEDB.Close();
        return samplerate;


    }

Please tag your questions with the language you're using. – Barmar Nov 20 '13 at 19:53 — Barmar, Nov 20 '13 at 19:53

score 0 · Accepted Answer · answered Nov 20 '13 at 19:47

0

Maybe try...

samplerate = Convert.ToSingle(rdr["samplerate_hz"]);

Otherwise, I would double check that the "samplerate_hz" column is of type float in the database.

answered Nov 20 '13 at 19:47

Andrew Peterson

56
9

Retrieve a float from database and adding to local variable

1 Answers1