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()
- 4 Answers
- 6771 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
How does asp page work?
What is the difference between custom web user control and a custom web server control?
What is the use of view state?
To display data in the combo box, prior to setting the Data Source, what kind of property on a Combo Box do you set with a column name?
Describe the .net base class library.
What are the different types of sessions in asp.net?
What is query string with example?
What are the uses of reflection?
When Cookies are expired in ASP.NET?
Define xmlvalidatingreader class.
Define secured sockets layer.
List of words of preprocessor in .net?
What is form method?
How many types of file extensions for razor views in ASP.Net MVC?
Why web api is better than wcf?
