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
7584 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

Explain about secure socket layer?

943

What is autopost?

979

Can we add code files of different languages in app_code folder?

1092

Explain the difference between panel and groupbox classes using .net?

965

Will the asp.net validators run in server side or client side?

1133

Can you explain one critical mapping? Performance issue which one is better?

889

What are the Types of authentications in IIS

1060

What is server side in asp.net?

978

How do you open a page in a new window?

982

How do I use response redirect?

974

How can we prepairing Interview

2331

How to manage different kinds of sessions in ASP.NET?

1063

What is the good practice to implement validations in aspx page?

1098

List all templates of the repeater control.

1081

Why do we need asp.net?

1007