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 Are The Difference Between AutoEventWireup="true" and AutoEventWireup="False"

12 Answers   Phoenix Technologies,

---

What is localization and Globalization?

3 Answers  

---

How many column in table of sql server?

3 Answers  

---

Differentiate between namespace and assembly.

0 Answers  

---

What tags do you need to add within the asp:datagrid tags to bind columns manually?

5 Answers   Siebel Systems,

---

I want to connect a system in LAN and I want to access that. Whenever I am moving a mouse in my desktop, the similar thing has to happen in another system in which I have connected. I need coding for this in C# and ASP.NET Can anyone please help me. It is very urgent. Thanks in advance. My email id is manojkumarchallagundla@gmail.com Will you please?

0 Answers   Excel,

---

How to create multi language website in asp.net mvc? : Asp.Net MVC

0 Answers  

---

What are custom controls?

0 Answers  

---

How many rounds are there for a software programmer to clear interview in any IT industries(MNC).

3 Answers   HCL,

---

How you can manage the state of application at the server side in ASP.NET?

0 Answers  

---

What is use of Master Page in ASP.NET web pages?

0 Answers   Sans Pareil IT Services,

---

What is difference between session and cookies in asp net?

0 Answers  

---