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 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? （）”相关的问题

第1题

[单选题] Which describes the default behavior when you create a table?（）

A、The table is accessible to all users. B、Tables are created in the public schema. C、Tables are created in your schema. D、Tables are created in the DBA schema. E、You must specify the schema when the table is created.

点击查看答案

第2题

[单选题] Which describes the default behavior when you create a table? （）

点击查看答案

第3题

[单选题] You are granted the CREATE VIEW privilege. What does this allow you to do?（）

A、Create a table view. B、Create a view in any schema. C、Create a view in your schema. D、Create a sequence view in any schema. E、Create a view that is accessible by everyone. F、Create a view only of it is based on tables that you created.

点击查看答案

第4题

[单选题] You are granted the CREATE VIEW privilege. What does this allow you to do? （）

点击查看答案

第5题

[] You are granted the CREATE VIEW privilege. What does this allow you to do?（）

A、A. Create a table view. B、B. Create a view in any schema. C、C. Create a view in your schema. D、D. Create a sequence view in any schema. E、E. Create a view that is accessible by everyone. F、F. Create a view only of it is based on tables that you created.

点击查看答案

第6题

[单选题] You are the network administrator for All servers run Windows Server 2003. You are creating a backup schedule for the main file server. You need to create a schedule so that backup jobs are completed in the shortest amount of time possible. What should you do?（）

A、Schedule a normal backup every Sunday. Schedule incremental backups every Monday through Saturday. B、Schedule a normal backup every Sunday. Schedule differential backups every Monday through Saturday. C、Schedule a copy backup every day. D、Schedule a normal backup every day.

点击查看答案

第7题

[单选题] You are developing an ASP.NET Web application. You create a master page. The master page requires a region where you can add page-specific content by using theASP.NET page designer. You need to add a control to the master page to define the region. Which control should you add？（）

A、PlaceHolder B、ContentPlaceHolder C、Content D、Substituition

点击查看答案

第8题

[单选题] 下面代码执行后，正确的输出结果是（）。

A、You are fired! You are hired! B、You are fired! You are fired! C、You are hired! You are hired! D、You are hired! Youarefired!