多項選擇題

You are creating a Web Form. You write the following code segment to create a SqlCommand object. SqlConnection conn = new.SqlConnection(connString); conn.Open(); SqlCommand cmd = conn.CreateCommand(); cmd.CommandText = “select cont(*) from Customers”; You need to display the number of customers in the Customers table. Which two code segments can you use to achieve this goal? （）

A. object customerCount = cmd.ExecuteScalar();lblCompanyName.Text = customerCount.ToString();
B. int customerCount = cmd.ExecuteNonQuery();lblCompanyName.Text = customerCount.ToString();
C. SqlDataReader dr = cmd.ExecuteReader();dr.Read();lblCompanyName.Text = dr[0].ToString();
D. SqlDataReader dr = cmd.ExecuteReader();dr.Read();lblCompanyName.Text = dr.ToString();

你可能感興趣的試題

單項選擇題

You are transferring records from one database to another. You need to decide whether you can use the SqlBulkCopy class to transfer the records. What should you do? （）

A. Ensure that the source database is Microsoft SQL Server.
B. Ensure that the destination database is Microsoft SQL Server.
C. Ensure that the column names in the source table match the column names in the destination table.
D. Ensure that the bulk copy program (bcp) utility is installed on the destination server.

多項選擇題

Your Web site processes book orders. One of the application methods contains the following code segment. XmlDocument doc = newXmlDocument(); doc.LoadXml(“10”+” Dictionary”); You need to remove the discount element from XmlDocument. Which two code segments can you use to achieve this goal? (Each correct answer presents a complete solution. （）

A. XmlNode root = doc.DocumentElement;root.RemoveChild(root.FirstChild);
B. XmlNode root = dec.DocumentElement;root.RemoveChild(root.SelectSingleNode(“discount”));
C. doc.RemoveChild(doc.FirstChild);
D. doc.DocumentElement.RemoveChild(doc.FirstChild);