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 / chauhan rakesh botad

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

Answer Posted / 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 View All Answers

Please Help Members By Posting Answers For Below Questions

What is the difference between viewstate and hidden field in asp.net?

1003

Explain method to handle error using HttpError in Web API?

1015

Explain client-side scripting?

946

How to store checkbox value in database in asp.net mvc? : Asp.Net MVC

931

Why is global asax is used?

978

What is a form tag?

842

Explain the server control events of asp.net ?

947

What is the main differences between asp and asp.net?

1019

What are the differences between application object and session object?

957

Are xaml file compiled or built on runtime?

918

What are the versions of garbage collection?

1839

Why is mvc better than asp.net?

1014

What is the difference between system.stringbuilder and system.string

718

What is a session government?

859

Explain the asp.net mvc folder conventions? : asp.net mvc

966