Below is a code extract from an ASP.Net application.
The code basically reads data from the “name” field in
the “members” table and prints them onto the webpage.
Using the assumptions provided, fill in the 4 blanks below
so that the code will run correctly.
‘Assumptions:
‘conn_str is a variable that holds the connection string to
the database
‘Objects dbcomm and dbread are already declared earlier
dbcomm = New OleDbCommand("SELECT name FROM members",
conn_str)
dbread = dbcomm._______________
_____________________
response.write(_______________)
_____________________
dbread.Close()
Answers were Sorted based on User's Feedback
Answer / wriju b
dbcomm = New OleDbCommand("SELECT name FROM members",
conn_str)
dbread = dbcomm.ExecuteReader()
while(dbread.Read())
response.write(dbread.GetString(1)))
dbread.NextResult()
dbread.Close()
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / karna
dbcomm = New OleDbCommand("SELECT name FROM members",
conn_str)
dbread = dbcomm.ExecuteReader();
while(dbread.Read())
{
response.write(dbread("name"))
}
dbread.Close()
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / jerry joseph
dbcomm = New OleDbCommand("SELECT name FROM members", conn_str);
dbread = dbcomm.ExecuteReader();
while(dbread.Read()){
response.write(dbread.("name"));
}
dbread.Close();
| Is This Answer Correct ? | 3 Yes | 1 No |
Answer / chauhan rakesh botad
dbcomm = New OleDbCommand("SELECT name FROM members",
conn_str)
dbread = dbcomm.ExecuteReader()
while(dbread.Read())
response.write(dbread.GetString(1)))
dbread.NextResult()
dbread.Close(
| Is This Answer Correct ? | 1 Yes | 0 No |
By default, Web API sends HTTP response with which of the following status code for all uncaught exception?
any body help me. Is it possible to convert text in gif images into word document with the same text? thanks in advance.
What will happen if the server confugration file and the application confugration file have different values for sassion state ASP.NET?
How do you specify whether your data should be passed as Query string and Forms (Mainly about POST and GET)
Why will you usually create an aspnet user account in the database for an asp.net web application?
What events will occur when a page is loaded?
What is the maximum number of classes that can be contained in one dll file?
how we use web services
Where sessions are stored in asp.net?
Usage of web.configuration ?
Types of session management in ASP.NET?
What is a ashx file?
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)