How to load data from database into DataGridView using DataReader in C#

Question

How to load data from database into DataGridView when we use DataReader ?

Sam Hobbs · Answer

Why must you use a DataReader? Did you look a the articles in this web site?

Crish · Answer

binding any .net control you can use control.Datasource = resultdata and then bind using control.DataBind() method

Vijay Yadav · Answer

Haha.. Rohatash bymistakely i have written DatGridview1 instead of DataGridview1 and the same code he had copied and pasted it here. Anyway i hope your query got resolved. :)

Rohatash Kumar · Answer

Vijay Good question.

Vijay Yadav · Answer

Piyush Thanks for your reply..What a copy and paste...:) :) :)

Vijay Yadav · Answer

Hi Give your DataReader object say dr to DataTable object say dt for eg: SqlDataReader dr; DataTable dt = new DataTable (); dt.Load(dr); DatGridView1.DataSource = dt; and it will work. :)