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 |
How to improve performance of web application asp.net mvc? : Asp.Net MVC
Explain what is postback in asp. Net?
Explain the main differences between asp and asp.net?
How can we create custom controls in asp net?
Caching techniques in .NET ?
What is the difference between client-side and server-side validations in ASP.NET?
0 Answers Sans Pareil IT Services,
Difference between asp and asp.net ?
4 Answers Accenture, BirlaSoft, TCS,
In try catch blocks one is normal catch block and another is sqlcatchexception block
How to create a permanent cookie?
Which is the namespace used to write error message in event Log File?
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?s the difference between Response.Write() andResponse.Output.Write()?
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)