- Q Tell me how would you account for the leasing of a vehicle?
- Q Where the user store resides in OS?
- Q At which session was the Indian National Congress (INC) divided into two groups - 'Naram Dal' (the moderates) and 'Garam Dal' (the extremists) ?
- Q Where should physical and human geography be looked at together?
- Q So can you guarantee objects destruction
- Q An orange vendor makes a profit of 20 % by selling oranges at a certain price. If he charges Rs. 1.2 higher per orange he would gain 40 %. Find the original price at which he sold an orange.
- Q How do i print my document as mirrored?
- Q What is the difference between a logical and physical data model?
- Q How many custom evars are available in each sitecatalyst report suite?
- Q What does a 2MB pulse code modulation consist of?
- Q You create an ASP.NET application for TestKing. This application will display information about products that the company sells. The application uses a Microsoft SQL Server database. You add two DropDownList controls to your .aspx page. One drop-down list box will display product information. The control for this drop-down list box is named Products. The other drop-down list box will display category information. The control for this drop-down lost box is named Category. You have an open SqlConnection object named con. The Page.Load event handler uses the following code segment to populate the drop-down list boxes by binding the SqlDataReader. (Line numbers are included for reference only) 01 SqlCommand cmd1 = new SqlCommand(SELECT * FROM Products,con); 02 SqlDataReader dr1 = cmd1.ExecuteReader(); 03 Products.DataTextField = ProductName; 04 Products.DataValueField = ProductID; 05 Products.DataSource = dr1; 06 Products.DataBind(); 07 cmd1.CommandText = SELECT * FROM Category; 08 SqlDataReader dr2 = cmd1.ExecuteReader(); 09 Category.DataTextField = CategoryName; 10 Category.DataValueField = CategoryID 11 Category.DataSource = dr2; 12 Category.DataBind(); During testing, the page raises an invalid operation exception. You need to ensure that the page displays correctly without raising an exception. What should you do? A. Replace the code for line 02 of the code segment with the following code: dr1.ExecuteReader(CommandBehavior.CloseConnection; B. Add the following code between line 06 and line 07 of the code segment: dr1.Close(); C. Replace the code for line 07 and line 08 of the code segment with the following code: SqlCommand cmd2 = new SqlCommand(SELECT * FROM Category,con); SqlDataReader dr2 = cmd2.ExecuteReader(); D. Remove the code for line 06 of the code segment. Replace the code for line 12 of the code segment with the following code: Page.DataBind();