Interested to Buy Any Domain ? << Click Here >> for more details...
Can we use data reader to bind gridview?
- 3 Answers
- 7136 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
How is threading done in .net?
Is there built-in support for tracing?
How does you handle this COM components developed in other programming languages in .NET?
What are the important components of .net?
i m fresher,hav SQL knowledge but in my ofc. i hav to work on dotnet. so plz tell me how to learn it,? from where to stat? i hav C prog. knowledge, ASP.net
What is the need of OLE-automation?
What is Assembly manifest? what all details the assembly manifest will contain.
What's the problem with .net generics?
State the differences between the dispose() and finalize().
Please explain the difference between constants and read-only variables?
If we write any code for DataGrid methods, what is the access specifier used for that methods in the code behind file and why?
Explain the code behind wors and contrast that using the inline style.
Dot Net Framework 
