ADO.Net - how to get data from database and bind to the
controls -- write this small code
Answers were Sorted based on User's Feedback
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.
| Is This Answer Correct ? | 5 Yes | 0 No |
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();
| Is This Answer Correct ? | 3 Yes | 0 No |
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();
| Is This Answer Correct ? | 2 Yes | 0 No |
What are directives in asp.net?
What are the server controls in asp.net?
What is MVVM in dot net?
Is it possible to perform data validations in the database?
how to convert from sql2000 numeric to int in asp.net with sqlparameter?
why we should use more than one web.config files in our application? I have two web.config files in my application. One in the root directory and another one inside a sub folder. When the application runs which web.config file will run? why?
we are working in .net namespaces like using system.io,system.text. these namespace before we use "using " keyword what means of using?
7 Answers CEI, CSC, HCL, Tech Mahindra,
What layout mode is the default when a new Web Form is created? a) GridBagLayout b) GridLayout c) FlowLayout d) FormLayout
Explain about solution explorer window?
To display data in a Repeater control which templete is provided ?
What is the use of location tag in web.config file
2 Answers Karur Vysya Bank KVB,
What are session objects?
Visual Basic (800)
C Sharp (3816)
ASP.NET (3180)
VB.NET (461)
COM+ (79)
ADO.NET (717)
IIS (369)
MTS (11)
Crystal Reports (81)
BizTalk (89)
Dot Net (2435)
Exchange Server (362)
SharePoint (720)
WCF (340)
MS Office Microsoft (6963)
LINQ Language-Integrated Query (317)
WPF (371)
TypeScript (144)
Microsoft Related AllOther (311)