how to fill DataGridView with DataReader

Question

hi
i need to fill DataGridView with DataReader
i have this code:

 

OracleConnection con = new OracleConnection ("Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=" + IP + ")(PORT=" + PORT + ")))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=" + Server + ")));User Id=" + UID + ";Password=" + PASS + ";");

 

OracleCommand cmd;

 

OracleDataReader dr;

cmd =

new OracleCommand("SELECT * FROM trap", con);

con.Open();

dr = cmd.ExecuteReader();

Answer 1

hi
i need to fill DataGridView with DataReader
i have this code:

 

OracleConnection con = new OracleConnection ("Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=" + IP + ")(PORT=" + PORT + ")))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=" + Server + ")));User Id=" + UID + ";Password=" + PASS + ";");

 

OracleCommand cmd;

 

OracleDataReader dr;

cmd =

new OracleCommand("SELECT * FROM trap", con);

con.Open();

dr = cmd.ExecuteReader();

Answer 2

COuld you try this code.

            DataSet ds = new DataSet();
            DataTable dt = new DataTable("trap");
            ds.Tables.Add(dt);
            ds.Load(dr, LoadOption.PreserveChanges, ds.Tables[0]);
            gridControl1.DataSource = ds.Tables[0];

Answer 3

Use the code to read into a DataTable instead  of reading using a DataReader and then you can build the table.

If you really have to use a datareader, I believe that there is a command to create a DataTable from the results of your data reader.

Hope this helps.

---

www.insteptech.com ; msmvps.com/blogs/deborahk
We are volunteers and ask only that if we are able to help you, that you mark our reply as your answer. THANKS!

Answer 4

Ditto

---

www.insteptech.com ; msmvps.com/blogs/deborahk
We are volunteers and ask only that if we are able to help you, that you mark our reply as your answer. THANKS!

Answer 5

Hi
            If you want to use datagridview with Database , you must assign the datasource property for retrieving data,
you can not use the datareader as Datasource because it is a valid datasource element , you can use dataset or datatable for data retrieval , further refer this resouce

http://msdn.microsoft.com/en-us/library/system.windows.forms.datagridview.datasource%28VS.80%29.aspx

Answer 6

Generally you use a data reader to convert the "raw" data into a collection of business objects which you then apply to a DGV.

If you just need to go directly to a DGV, use a data table and data adapter instead as Raja states above as that's much simpler.