单项选择题
You work as an application developer at Contoso.com. You use Microsoft .NET Framework 3.5 and Microsoft ADO.NET to develop an application that will connect to the Microsoft SQL Server 2005 database. Your application contains the following code.
string queryString = "Select * from dbo.Users"；
SqlCommand command = new SqlCommand（queryString， （SqlConnection）connection））；
You want to get the value that is contained in the first column of the first row of the result set returned by the query.
What should you do？ （）
A.A
B.B
C.C
D.D
相关考题
-
单项选择题
You work as an application developer at Contoso.com. You use Microsoft .NET Framework 3.5 and Microsoft ADO.NET to develop an application that will connect to the Microsoft SQL Server 2005 database. The application is used under a Least-Privilege User Account （LUA） of the operating system. You want to configure the SQL Server 2005 connection string in the app.config file to use SQL Server Express user instances. What should you do？（）
A.A
B.B
C.C
D.D -
多项选择题
You work as an application developer at Contoso.com. You use Microsoft .NET Framework 3.5 and Microsoft ADO.NET to develop an application that will connect to the Microsoft SQL Server 2005 database. You have written the following code to generate a storage schema definition for a stored procedure from the database. You application uses two namespaces named ContosoModel.Store and ContosoModel. The ContosoModel.Store has the storage schema and the ContosoModel has the conceptual schema that has an entity named Supplier. You want to create a function named GetSuppliersInRegion that returns a list of Supplier entity instances. What should you do？（）
A.A
B.B
C.C
D.D
E.E
F.F -
单项选择题
You work as an application developer at Contoso.com. You use Microsoft .NET Framework 3.5 and Microsoft ADO.NET to develop an application. The Contoso.com network contains a Microsoft SQL Server 2005 server named DB01. Your application retrieve records from a database named Trades that resides on DB01. The application connects to Trades by using an instance of the SqlConnection class with the following connection string. "Data Source=DB01；UID=’mhamm’；PWD=’password’；" When the application calls the Open method of the SqlConnection object， it displays the following： "Cannot open user default database. Login failed. Login failed for user ’mhamm’". You need to make sure that you can connect to Trades when the user account for the connection is mhamm. What should you do？ （）
A. Change the connection string as follows：Data Source=DB01；Initial Catalog=Trades；UID=mhamm； PWD=password；"
B. Create a login for Mia Hamm on DB01.
C. Create a database user object in Trades and map the object to the SQL Server 2005 Login of Mia Hamm.
D. Change the connection string as follows："Server=DB01；Database=Trades；UID=mhamm；PWD=password；"
