Click here to Skip to main content
65,938 articles
CodeProject is changing. Read more.
Articles / Languages / ASP

dataGridview Using DataReader

3.12/5 (18 votes)
24 Sep 2008CPOL 1   1  
How to Fill dataGridview Using DataReader in Win App

Introduction

One of the most questions asked to me, how to fill dataGridview Using DataReader, if you note the behavior of DataReader you will note that when you read using DataReader you read row by row so you you make looping to read all records if you want to display all record or any element from record , in other hand dataGridview need to take all data of your records in one package, so the solution is to make centralize store by make class that contains properties and set value for each properties when you read the value of each record and store each object from class that you create in ArrayList so the ArrayList will represent your store.

Using the Code

Step1: Create class that contains properties

C#
public class MyDetails
    {
        private int age;

        public int Age
        {
            get { return age; }
            set { age = value; }
        }
        private string name;

        public string Name
        {
            get { return name; }
            set { name = value; }
        }

        private int id;

        public int Id
        {
            get { return id; }
            set { id = value; }
           } 
        }

Step 2: create ArrayList to represent your store

C#
ArrayList sequence = new ArrayList();

Step 3: When you retrieve do the following

C#
while (reader.Read())
               {
                   MyDetails m = new MyDetails();
                   m.Id = (int)reader[0];
                   m.Name = reader[1].ToString();
                   m.Age = (int)reader[2];
                   sequence.Add(m);
               }
               dataGridView1.DataSource = sequence;

The Final Code

C#
SqlConnection sqlCon = null;
           try
           {
               sqlCon = new SqlConnection();
               sqlCon.ConnectionString = "Your Connection String";
               SqlCommand cmd = new SqlCommand();
               cmd.Connection = sqlCon;
               cmd.CommandText = "SELECT * FROM StudentInfo";
               sqlCon.Open();
               SqlDataReader reader = cmd.ExecuteReader();
               while (reader.Read())
               {
                   MyDetails m = new MyDetails();
                   m.Id = (int)reader[0];
                   m.Name = reader[1].ToString();
                   m.Age = (int)reader[2];
                   sequence.Add(m);
               }
               dataGridView1.DataSource = sequence;
           }
           finally
           {
               sqlCon.Close();
           }

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)