Can we use data reader to bind gridview?

Question Posted / mohammad afraz uddin

3 Answers
7294 Views
TCS, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Can we use data reader to bind gridview?..

Answer / prasanth

data reader can be used to databind gri view

void Page_Load(Object sender, EventArgs e){ String Q; Sql
command cmd; Sql DataReader dr; SqlConnection conn = new
SqlConnection(); conn.ConnectionString =
ConfigurationManager.ConnectionStrings
["cn"].ConnectionString.ToString(); conn.Open
(); Q = "select * from tablename";
cmd= New Sqlcommand(Q, conn); dr =
cmd.ExecuteReader();
Gridview1.DataSource = dr; Gridview1.DataBind();}

Is This Answer Correct ?

17 Yes

4 No

Can we use data reader to bind gridview?..

Answer / swathi

this is also same as the Dataset.
these are steps:
1. SqlConnection con=new SqlConnection(ConnectionString);
2. SqlCommand com=new SqlCommand("Select * from
TableNAme",con);
3. SqlDataReader dr;
4. con.open();
5. dr=com.ExecuteReader();
6. Datagrid1.DataSource=dr;
7. DataGrid1.DataBind();

Is This Answer Correct ?

6 Yes

0 No

Can we use data reader to bind gridview?..

Answer / minhaj

yes, we can bind
but datagrid can
not be backword
because DR is
forward only

Is This Answer Correct ?

2 Yes

0 No

Post New Answer

More Dot Net General Interview Questions

How do you turn off cookies for one page in your site? Give an example.