MS.NET Framework 2.0-Web-based Client Development 70-528(Csharp) 시험문제는IT 인증강사 및 제품 전문가가 시험문제를 완벽하게 만들었습니다. 2010년 6월28일 최신 업데이트 된 버전입니다.Killtest 인증시험문제를 구매한 고객분들은 일년 동안 무료로 업그레이드 서비스를 받을 수 있습니다. /MCTS/70-528(Csharp).asp 시험문제는 고객님이 한번에 인증시험을 통과할 수 있는 것을 도와 줄 것입니다. 떨어지는 경우 전액 환불을 약속합니다.즐거운 하루 되세요.
VUE/Prometric Code: 70-528(Csharp)
Exam: MS.NET Framework 2.0-Web-based Client Development
Q&A:162 Q&As
업그레이트:2010-06-28
무료 덤프 보기:
6. 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 count(*) 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? (Each correct answer presents a complete
solution. Choose two.)
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();
Answer: AC
8. You are creating a Web Form that displays product data. You create a DataView named dvOrders and
bind it to a GridView.
You need to display the rows from dvOrders where the CategoryID is 2, in descending order of unit price.
Which code segment should you use?
A. dvOrders.Find(”CategoryID = 2, UnitPrice desc”);
dvOrders.Table.AcceptChanges();
B. dvOrders.RowFilter = “CategoryID = 2″;
dvOrders.Sort = “UnitPrice desc”;
C. dvOrders.Table.Select(”UnitPrice desc”, “Category = 2″);
D. dvOrders.Table.Select(”CategoryID = 2″, “UnitPrice desc”);
Answer: B
9. You create a Web Form that displays a GridView. The GridView s data source is a DataSet named
dsOrders. The DataSet contains two DataTables named Orders and OrderDetails. You create a relation
between the two DataTables using the following code segment. (Line numbers are included for reference
only.)
01 dtOrders = dsOrders.Tables["Orders"];
02 dtOrderDetails = dsOrders.Tables["OrderDetails"];
03 colParent = dtOrders.Columns["OrderID"];
04 colChild = dtOrderDetails.Columns["ParentOrderID"];
05 dsOrders.Relations.Add(”Rel1″, colParent, colChild, false);
You need to find the cause of the exception being raised in line 05.
What should you do?
A. Ensure that the child column and the parent column have the same names.
B. Ensure that the child table and the parent table have the same names.
C. Ensure that the child column and the parent column have the same data types.
D. Ensure that each row in the child table has a corresponding row in the parent table.
E. Ensure that the tables have an explicit relationship defined by a foreign key constraint in the database.
Answer: C