Below is a code extract from an ASP.Net application. The code basically reads d

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()

Question Posted / raghu_113

4 Answers
6348 Views
Techno Solutions, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Below is a code extract from an ASP.Net application. The code basically reads data from the “name..

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

Below is a code extract from an ASP.Net application. The code basically reads data from the “name..

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

Below is a code extract from an ASP.Net application. The code basically reads data from the “name..

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

Below is a code extract from an ASP.Net application. The code basically reads data from the “name..

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

Post New Answer

More ASP.NET Interview Questions

What is the difference between Postback and Ispostback Property?

7 Answers Atrocity Apps Technologies, DC Infotech, HCL, Maples, Visual Soft,

How can you ensure a permanent cookie?

0 Answers

What is the significance of attaching a profile while creating a user?

0 Answers MCN Solutions,

What does WSDL stand for?