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