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

ADO.Net - how to get data from database and bind to the
controls -- write this small code

Question Posted / kinjal panchal

3 Answers
5782 Views
Syntel, I also Faced
E-Mail Answers

Answer Posted / 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();

Is This Answer Correct ?

2 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How is the asp.net mvc architecture different from others? : asp.net mvc

1010

How does asp.net page work?

941

Which method has beenintroduced in asp.net 4.0 to redirect a page permanently?

964

What is caching? What are different ways of caching in asp.net?

1296

What are themes and skins in 2.0, explain usage scenario?

937

What is server side session management?

927

What is the use of asp.net web api?

1081

What is session mode in asp.net?

1043

What is session authentication?

986

What is a master page and what does it do?

924

What are Master Pages in ASP.NET?

1064

What is difference between mvc and asp.net? : Asp.Net MVC

1189

How do I create a web form?

1033

What is a nested masterpage in asp.net 2.0? Can there be a master page inside a masterpage?

887

What is asp.net mvc5? : Asp.Net MVC

1023