Our Training Programs

All contents are copyright of their authors.

get specific value from Datareader

get specific value from Datareader

Vamsi k

7yAsked Jan 29, 2019, 1:04 PM1.1kLearn iOS Programming

Hi All,

I am displaying 100 records in gridview using execute reader.

dr contains 100 records.

Gridview.datasource=dr;

Gridview1.Databind;

Requirements:

Gridview should display 100 records.

get specific record value i,e dr["initial_rate];

How can i get that specific record value.

i want to store that specific value into a variable which can be used to check condition.

Please help me on this requirement. It is urgent

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

It is the same account you read, post and publish with — and you will come straight back to this page.

Jignesh Kumar7y ago
Hi Vamsi,

Please try below link,
while (rdr.Read())
    {
        // get the results of each column
        string contact = (string)rdr["ContactName"];
        string company = (string)rdr["CompanyName"];
        string city    = (string)rdr["City"];

    }
For reference
https://csharp-station.com/Tutorial/AdoDotNet/Lesson04
Munesh Sharma7y ago
read.GetValue(read.GetOrdinal("ColumnID"));
Salman Beg7y ago
Hi. You can use like this, while (rdr.Read()) { // get the results of each column string contact = (string)rdr["ContactName"]; string company = (string)rdr["CompanyName"]; string city = (string)rdr["City"];} For more you can follow this link, https://csharp-station.com/Tutorial/AdoDotNet/Lesson04 Thanks