试题详情
多项选择题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();

  • A,C

  • 关注下方微信公众号，在线模考后查看

热门试题