Data reader with gridview ?

Question

Hi

i tried as below its not loading data into grid view when i tried using dataset it worked perfectly

OleDbCommand cmd = new OleDbCommand("select * from customer", con);

con.Open();

MessageBox.Show(con.State.ToString());

OleDbDataReader dr = cmd.ExecuteReader();

con.Close();

MessageBox.Show(con.State.ToString());

dataGridView1.DataSource = dr;

Cheers & thanks everyone

Satyapriya Nayak · Answer

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

Iftikar Hussain · Answer

I suggest you better use DataSet, since you want to display all record into grid Regards, Iftikar

Pankaj Kumar · Answer

try this code: OleDbCommand cmd = new OleDbCommand("select * from customer", con); con.Open(); MessageBox.Show(con.State.ToString()); OleDbDataReader dr = cmd.ExecuteReader(); if(dr.HasRows) { dataGridView1.DataSource = dr; } con.Close(); MessageBox.Show(con.State.ToString());

SUNIL GUTTA · Answer

data table does the trick here :D super Satyapriya Nayak ty ... But why direct binding with gridview not possible with Data reader any ideas ???

SUNIL GUTTA · Answer

Yes i do prefer to do using dataset its much felxible to deal but knowing a correct way to deal with datareader even tough not much needed here :) out of curiosity Joxin Stanly well you finally binded dataset to dataGrid which i don't want especially , i need Datareader & data grid binding ? .. TY mate

Joxin Stanly · Answer

hi, can u plz try something like below -: SqlConnection con = new SqlConnection("Connection String"); con.Open(); SqlCommand com = new SqlCommand("SQL Query", con); SqlDataReader read = com.ExecuteReader(); DataSet ds = new DataSet(); DataTable dt = new DataTable("Table1"); ds.Tables.Add(dt); ds.Load(read, LoadOption.PreserveChanges, ds.Tables[0]); gridControl1.DataSource = ds.Tables[0];

SUNIL GUTTA · Answer

Hi both of you TY again friends Well tried out ur both ways .. i am just not getting data to dataGridview ?? Problem still persists // in case of dataset its perfect ??

Iftikar Hussain · Answer

Hi, try like this OleDbCommand cmd = new OleDbCommand("select * from customer", con); con.Open(); MessageBox.Show(con.State.ToString()); OleDbDataReader dr = cmd.ExecuteReader(); dataGridView1.DataSource = dr; con.Close(); MessageBox.Show(con.State.ToString()); Regards, Iftikar

Data reader with gridview ?

Answers (8)