Data reader with gridview ?

SUNIL GUTTA

13y10.2kVisual Basic .NET

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

8 Replies

Know the answer? Post it — somebody with the same question will find it here.

Satyapriya Nayak13y ago
Accepted 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();
            }
        }
    }
}
0
SUNIL GUTTA13y ago
data table does the trick here :D super Satyapriya Nayak ty ... But why direct binding with gridview not possible with Data reader any ideas ???
0
SUNIL GUTTA13y ago
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
0
Iftikar Hussain13y ago
I suggest you better use DataSet, since you want to display all record into grid

Regards,
Iftikar
0
Joxin Stanly13y ago
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];
0
SUNIL GUTTA13y ago
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 ??
0
Iftikar Hussain13y ago
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
0
Pankaj Kumar13y ago
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());
0