Display Records from Database to DataGridView using DataReader

In this blog we will know how to Display records from database to datagridview using datareader.

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Linq;

using System.Text;

using System.Windows.Forms;

using System.Data.SqlClient;

namespace Datareader_datagridview

{

    public partial class Form1 : Form

    {

        SqlConnection con = new SqlConnection(@"server = HOME-SAT/SQLEXPRESS;data source = .; initial catalog = test; user id=sa;pwd =pintu ;integrated security = SSPI");

        SqlCommand com;

        string str;

 

        public Form1()

        {

            InitializeComponent();

        }

 

        private void btn_Show_Click(object sender, EventArgs e)

        {

            try

            {

                com = new SqlCommand();

                com.Connection = con;

                com.CommandText = "select * from emp";

                con.Open();

                SqlDataReader reader = com.ExecuteReader();

                if (reader.HasRows)

                {

                    DataTable dt = new DataTable();

                    dt.Load(reader);

                    dataGridView1.DataSource = dt;

                }

            }

            finally

            {

                con.Close();

            }

        }

    }

}