- Q You are creating an ASP.NET application for TestKings Travel. TestKings Travel uses a Microsoft SQL Server 2000 database to store information about vacation packages. Your application will allow a user to request information about vacation packages for a specific destination. You want to display this data to the user in a DataGrid. You want the data to be displayed in read-only form. The users travel destination is contained in a form level string variable named destinationCode. In your Page.Load event handler, you create a SqlConnection object named SqlConnection1, initialize it, and call its Open() method. When your code runs the query, you want the data to be returned as quickly as possible. You define the following local variable to hold the destination code:string dest = destinationCode; What should you do? A. Create a stored procedure named GetDestinations and then use the following code to retrieve the data: SqlCommand cmd = new SqlCommand(GetDestinations, sqlConnection1); cmd.CommandType = CommandType.StoredProcedure; SqlParameter parm = new SqlParameter(@DestinationCode, dest); cmd.Parameters.Add(parm); SqlDataReader sqlDataReader1 = cmd.ExecuteReader(); B. Create a stored procedure named GetDestinations and then use the following code to retrieve the data: string qry = EXEC GetDestinations WHERE DestID = + dest + ; SqlDataAdapter da = new SqlDataAdapter(qry, sqlConnection1); DataSet ds = new DataSet(); da.Fill(ds); C. Use the following code to retrieve the data: string qry = SELECT * FROM Destination WHERE DestID = + dest + ; SqlCommand cmd = new SqlCommand(qry, sqlConnection1); cmd.CommandType = CommandType.Text; SqlDataReader sqlDataReader1 = cmd.ExecuteReader(); D. Use the following code to retrieve the data: string qry = SELECT * FROM Products WHERE DestID = @DestID; SqlCommand cmd = new SqlCommand(qry; sqlConnection1); cmd.CommandType = CommandType.Text; SqlParameter parm = new SqlParameter(@DestID, dest); cmd.Parameters.Add(parm); SqlDataReader sqlDataReader1 = cmd.ExecuteReader();
- Q From which documents can you create a Proforma invoice (pro forma)?
- Q And what's their greatest turn off
- Q What are the basic qualities of an anchor person? How best can he perform in a panel discussion on a controversial subject?
- Q How Wide Do You Want Your Page Content to Be?
- Q explain supportive connective tissue
- Q Under which form is nitrogen fixed by living beings?
- Q Name Jennifer Anniston's Godfather
-
Q
What is the purpose of binaryoperator
functional interface? - Q The sponges in a Battenberg cake are usually which two colours?
- Q If you want to use the text written in a "text field" response from page1 of your prototype, such as a person's name, and use this response on page 2 of your prototype, how would you do this?