I have taken the microsoft self evaluation test.
I don't know the answers to the following questions and I was wondering if someone could help me.
what is the right answer? and maybe why?
Code:
1)A Microsoft(R) Windows(R) Forms application connects to a 
Microsoft SQL Server(TM) 2000 data source.
Which code fragment illustrates the preferred method 
of creating the connection to the SQL server?
 	Dim cn As OleDbConnection = New _ OleDbConnection("Provider=MSDAORA.1;User ID=MyID;Password=MyPassword;Data Source=CUSTOMER")
 	Dim cn As OleDbConnection = New OleDbConnection("Provider _ =Microsoft.Jet.OLEDB.4.0;Data Source=\applications\customer.mdb")
 	Dim cn As OleDbConnection = New OleDbConnection("Provider=SQLOLEDB;Data Source=APPLICATION;Initial Catalog=customer;Integrated Security=True")
 	Dim cn As SqlConnection = New SqlConnection("Data _ Source=APPLICATION;Initial Catalog=customer;Integrated _ Security=SSP1")





2)You have added a DataGrid control to a Microsoft(R) Windows(R) form that displays all 
records from a DataSet. What step is necessary to enable the user to make changes to 
the records that the DataGrid control displays?
 	Modify the RowChanging event.
 	Modify the ColumnChanging event.
 	Modify the GotFocus event.
 	Modify the ColumnChanged event.
 	Modify the OnEditCommand method.
 	Modify the RowChanged event




3)You place a ListBox control on a Microsoft(R) Windows(R) form that will display customer names. 
When the user selects a customer name, a DataGrid control displays the associated customer orders. 
What property or properties do you use to bind the ListBox control to the data source?
 	The DisplayMember and DataSource properties
 	The DataMember and DataSource properties
 	The DataSet and DataSource properties
 	The DataBinding property








4)You are part of a team that is developing a database-driven Microsoft(R) 
Windows(R) application. You are looking through code from one of your coworkers, 
and you see the SqlCommand command. 

What can this command do? (Select all that apply.)


 	Execute stored procedures in a Microsoft SQL Server(TM) data source.
 	Manage the interaction between a DataSet and the data in a Microsoft SQL Server(TM) data source.
 	Execute SQL statements in a Microsoft SQL Server(TM) data source.
 	Read a forward-only stream of data from a Microsoft SQL Server(TM) data source.
 	Populate a DataSet from the data in a Microsoft SQL Server(TM) data source











5)You are using Microsoft(R) Visual Studio(R) .NET to develop a
Microsoft Windows(R) 
application for a public library. Your 
application uses a DataSet named 
BookList that is populated from
 a Microsoft SQL Server(TM) database. On your application's main
 form, you would like to add a list box that displays in
 descending order the titles of the books that were published in
 Texas. 

Which of the following code fragments should you use to achieve your goal?
 	Me.DataGrid1.RowFilter = "State = 'TX'" Me.DataGrid1.DataMember = "Title Desc" Me.DataGrid1.DataSource = Me.BookList
 	Me.DataGrid1.Sort = "State = 'TX'" Me.DataGrid1.DataMember = "Title" Me.DataGrid1.DataSource = Me.Booklist
 	Me.DataView1.RowStateFilter=System.Data.DataViewRowState.OriginalRows Me.DataView1.Sort = "State = 'TX'" Me.DataView1.Table = Me.BookList.Titles
 	Me.DataView1.RowFilter = "State = 'TX'" Me.DataView1.Sort = "Title Desc" Me.DataView1.Table = Me.BookList.Titles