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

}