Answer / alb.shah

Creating a Database Connection at Run Time
Create the data connection object.
Create a data adapter object.
Create a data set object.
Invoke methods on the adapter object to fill or update the
data set.
Use data binding or another technique to display the data
from the data set.

Answer / kaarthikeyan

establish a connection and declare sqldataadapter,dataset
sda=new sqldataadapter("select the appropriate
table",connectionobj);
ds=new dataset();
sda.fill(ds);
gridview1.datasource=ds;
gridview1.databind();

Answer / kinjal panchal

first of all write namespace in your page.
using Syste.data.sqlclient;

//code
sqlconnection cn=new sqlconnection();
cn.open();
sqlcommand cmm=new sqlcommand("write select query here",cn);
sqldataAdupter da=new sqldataAdupter(cmm);
datatable dt=new datatable();
da.fill(dt);
cn.close();

suppose u have gridview control then

gridview.datasource=dt;
gridview.databind();

What is viewstate parameter?

0 Answers  

---

What is role-based security in asp.net?

0 Answers  

---

In asp.net, if a webpage seems too slow to load completely in th ebrowser. In this case what are the checkings or actions you will take to rectify the slowness or which are the factors related to this issue? How we can trace it?

3 Answers  

---

What is intrinsic objects in asp.net?

0 Answers  

---

What are validator? Name the validation controls in asp.net?

0 Answers  

---

what are the events raised in asp.net page life cycle?in which stage view state can be loaded?

0 Answers   EDS,

---

what are the new server controls added in Asp.net 2.0?

1 Answers   DOSPL,

---

How do you define authentication in Web.Config?

2 Answers   Accenture, BirlaSoft, IBM,

---

What are the asp.net security controls?

0 Answers  

---

How to limit table cell size with long strings?

1 Answers   IBS,

---

If I update session state, should I lock it, too? Are concurrent accesses by multiple requests executing on multiple threads a concern with session state?

1 Answers  

---

What is the use of @Register directives?

3 Answers  

---