dbcomm = New OleDbCommand("SELECT name FROM members", conn

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 / wriju b

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

Answer Posted / 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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How can you use a custom controls in ASP.NET application?

1005

Is asp.net web forms dead?

1126

Is it right that ASP.NET Web API has replaced WCF?

975

Diff between web user control and web custom control?

978

What are web beacons used for?

1022

Why is the standalone environment only useful during the development process?

1838

How many web config files can be created for an application?

865

Explain about Application and Session Events ?

1074

What is a form tag?

881

What is server infrastructure?

1126

i want to implement grid view value in paypal site. so how to create this code in asp.net with C#

1936

How Can assign alias name for ASP.NET Web API Action?

1457

Explain the advantages of passport authentication.

927

What are the merits and demerits of viewstate?

1042

Can asp.net work on an nt server?

1043