What is sequence of code in retrieving data from database?
Answers were Sorted based on User's Feedback
Answer / seshu
SQLConnection conn = new
SQLConnection("DataSource=;InitialCatalog=;User Id=;Password=");
SQLCommand cmd=new SQLCommand("select * from tablename",conn);
DataAdapter da=new DataAdapter(cmd);
Dataset ds=new Dataset();
da.fill(ds,"tablename");
| Is This Answer Correct ? | 8 Yes | 0 No |
Answer / chandra
system.data.oledb
dim oledb as new oledbconnection
oledbconnection1.open()
dim com as new oledbcommand("select empname from emp where
empid=100".oledbconnection)
dim dr as oledbdatareader=com.executereader()
if dr.read() then
textbox1.text=dr(0)
end if
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / srujana
using data.sqlclient;
sqlconnection cn;
cn=new sqlconnectin("user id=sa;database=pubs;data
source=server");
cn.open();
| Is This Answer Correct ? | 2 Yes | 2 No |
what is impersonation in ASP.NET?
7 Answers Accenture, Merrill Lynch, Wipro,
What is .net framework and what are the main components of it?
What is CLS?
5 Answers IBM, PrimeLine, TCS,
Is asp.net mvc front end or backend? : Asp.Net MVC
Name two properties common in every validation control?
Do you know using sql cache invalidation?
what is assembly?
How to retrieve the information from datatable citywise in c#?
what is view state and its use
10 Answers DELL, Efextra, HCL,
What is the main differences between asp and asp.net?
About CLR, reflection and assemblies?
Can I have a unique key as foreign key?
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)