|
Home > Archive > microsoft.public.cert.exam.mcsd > May 2003 > 70-316 Question
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
|
| I have this question .Any ideas ? None of them seems right to me..
You use Visual Studio .NET to develop a Microsoft Windows-based application.
Your application contains a form named CustomerForm, which includes the
following design-time controls:
.. SQLConnection object named RetailConnection
.. SQLDataAdapter object named RetailDataAdapter
.. DataSet object named CustomerDataSet
.. Five TextBox controls to hold the values exposed by CustomerDataSet
.. Button control named saveButton
At design time you set the DataBindings properties of each TextBox control
to the appropriate column in the DataTable object of CustomerDataSet.
When the application runs, users must be able to edit the information
displayed in the text boxes. All user changes must be saved to the
appropriate database when saveButton is executed. The event handler for
saveButton includes the following code segment:
RetailDataAdapter.Update(CustomerDataSet)
You test the application. However, saveButton fails to save any values
edited in the text boxes.
You need to correct this problem.
What should your application do?
A. Call the InsertCommand method of RetailDataAdapter.
B. CALL THE Update method of RetailDataAdapter and pass in
RetailConnection.
C. Before calling the Update method, ensure that a row position change
occurs in CustomerDataSet.
D. Reestablish the database connection by calling the Open method of
RetailConnection.
| |
| Jimmy Cooks 2003-05-21, 3:23 pm |
| B
On Tue, 20 May 2003 20:40:10 -0500, "Sahil" <sahil@hh.com> wrote:
>I have this question .Any ideas ? None of them seems right to me..
>
>
>You use Visual Studio .NET to develop a Microsoft Windows-based application.
>Your application contains a form named CustomerForm, which includes the
>following design-time controls:
>
>. SQLConnection object named RetailConnection
>. SQLDataAdapter object named RetailDataAdapter
>. DataSet object named CustomerDataSet
>. Five TextBox controls to hold the values exposed by CustomerDataSet
>. Button control named saveButton
>
>At design time you set the DataBindings properties of each TextBox control
>to the appropriate column in the DataTable object of CustomerDataSet.
>When the application runs, users must be able to edit the information
>displayed in the text boxes. All user changes must be saved to the
>appropriate database when saveButton is executed. The event handler for
>saveButton includes the following code segment:
>
>RetailDataAdapter.Update(CustomerDataSet)
>
>You test the application. However, saveButton fails to save any values
>edited in the text boxes.
>You need to correct this problem.
>What should your application do?
>
>A. Call the InsertCommand method of RetailDataAdapter.
>B. CALL THE Update method of RetailDataAdapter and pass in
>RetailConnection.
>C. Before calling the Update method, ensure that a row position change
>occurs in CustomerDataSet.
>D. Reestablish the database connection by calling the Open method of
>RetailConnection.
>
>
| |
| Mcad.net 2003-05-22, 2:23 pm |
| There is no overload in Update method that can take a connection param . So
I think B is incorrect .
But I can't think of any other possibel solution.. May be D is correct then
... any comments ?
"Jimmy Cooks" <jamescooks@hardee.com> wrote in message
news:umkncvk6bg0i5glqgcl3t789e
jmgrrevue@4ax.com...
> B
>
> On Tue, 20 May 2003 20:40:10 -0500, "Sahil" <sahil@hh.com> wrote:
>
> >I have this question .Any ideas ? None of them seems right to me..
> >
> >
> >You use Visual Studio .NET to develop a Microsoft Windows-based
application.
> >Your application contains a form named CustomerForm, which includes the
> >following design-time controls:
> >
> >. SQLConnection object named RetailConnection
> >. SQLDataAdapter object named RetailDataAdapter
> >. DataSet object named CustomerDataSet
> >. Five TextBox controls to hold the values exposed by CustomerDataSet
> >. Button control named saveButton
> >
> >At design time you set the DataBindings properties of each TextBox
control
> >to the appropriate column in the DataTable object of CustomerDataSet.
> >When the application runs, users must be able to edit the information
> >displayed in the text boxes. All user changes must be saved to the
> >appropriate database when saveButton is executed. The event handler for
> >saveButton includes the following code segment:
> >
> >RetailDataAdapter.Update(CustomerDataSet)
> >
> >You test the application. However, saveButton fails to save any values
> >edited in the text boxes.
> >You need to correct this problem.
> >What should your application do?
> >
> >A. Call the InsertCommand method of RetailDataAdapter.
> >B. CALL THE Update method of RetailDataAdapter and pass in
> >RetailConnection.
> >C. Before calling the Update method, ensure that a row position change
> >occurs in CustomerDataSet.
> >D. Reestablish the database connection by calling the Open method of
> >RetailConnection.
> >
> >
>
| |
| K.Hakvoort 2003-05-24, 11:23 am |
| if you make the program described in the question, you'll
find out that c is the answer.
>-----Original Message-----
>There is no overload in Update method that can take a
connection param . So
>I think B is incorrect .
>
>But I can't think of any other possibel solution.. May be
D is correct then
>... any comments ?
>
>
>"Jimmy Cooks" <jamescooks@hardee.com> wrote in message
> news:umkncvk6bg0i5glqgcl3t789e
jmgrrevue@4ax.com...
>> B
>>
>> On Tue, 20 May 2003 20:40:10 -0500, "Sahil"
<sahil@hh.com> wrote:
>>
>> >I have this question .Any ideas ? None of them seems
right to me.. [colo
r=darkred]
>> >
>> >
>> >You use Visual Studio .NET to develop a Microsoft[/color]
Windows-based
>application.
>> >Your application contains a form named CustomerForm,
which includes the[c
olor=darkred]
>> >following design-time controls:
>> >
>> >. SQLConnection object named RetailConnection
>> >. SQLDataAdapter object named RetailDataAdapter
>> >. DataSet object named CustomerDataSet
>> >. Five TextBox controls to hold the values exposed by[/color]
CustomerDataSet[co
lor=green]
>> >. Button control named saveButton
>> >
>> >At design time you set the DataBindings properties of[/color]
each TextBox
> control
>> >to the appropriate column in the DataTable object of
CustomerDataSet. [colo
r=darkred]
>> >When the application runs, users must be able to edit[/color]
the information
>> >displayed in the text boxes. All user changes must be
saved to the[c
olor=darkred]
>> >appropriate database when saveButton is executed. The[/color]
event handler for[c
olor=darkred]
>> >saveButton includes the following code segment:
>> >
>> >RetailDataAdapter.Update(CustomerDataSet)
>> >
>> >You test the application. However, saveButton fails to[/color]
save any values
>> >edited in the text boxes.
>> >You need to correct this problem.
>> >What should your application do?
>> >
>> >A. Call the InsertCommand method of RetailDataAdapter.
>> >B. CALL THE Update method of RetailDataAdapter and
pass in[co
lor=darkred]
>> >RetailConnection.
>> >C. Before calling the Update method, ensure that a[/color]
row position change
>> >occurs in CustomerDataSet.
>> >D. Reestablish the database connection by calling the
Open method of[co
lor=darkred]
>> >RetailConnection.
>> >
>> >
>>
>
>
>.
>[/color]
|
|
|
|
|