MCAD cert SQL question

[ewingate]

I am currently going through an MCAD/MCSD training guide for Exam#
70-316. It is a great book but it shows it's age with certain subjects.
The chapter on databinding is one of these. This somewhat wordy
introduction is because I actually have 2 questions. The first one
concerns SQL. My training guide has me bringing up the Northwind sample
DB in the server explorer and it then tells me to drag and drop one of
the tables onto a form that I crafted. The idea behind this exercise
being to eventually databind this table to a gridview control on the
form. I cannot seem to drag and drop the required table anywhere as the
cursor turns into the NOT symbol and stays that way until I release the
MB. I am assuming that this is because either SQL 2005 or .NET 2005 no
longer allows 'drag and drop' although since I am a complete beginner
at SQL I could be quite mistaken. So my first question is how do I get
'drag and drop' to work in the .NET 2005 server explorer or what is the
alternative if things are done differently now.

For my second question I would like to know if there is another
training guide available that was written for use with .NET 2005 that
is recommended for beginners. I have done some research on this but the
guide that I am using keeps popping up and I haven't managed to
identify a suitable replacement.

Thank you for your consideration.

EMW

[Dave Sexton]

Hi EMW,

Check out the "Data" menu in VS.NET 2005. Click "Show Data Sources"... to open the "Data Sources" window. From here, you can add a
new data source and drag & drop nodes onto a Form. Check out the types of data sources that you can add. You can now bind to
objects and Web Services, for example, which you couldn't do using the designer in earlier versions of VS.NET. (The new
functionality is partly due to the new BindingSource component, which you can add to the Form yourself if you'd like by going to the
"Data" tab of the Toolbox and dragging the BindingSource item onto a Form.)

Something else of interest might be that each bindable property node in the "Data Sources" window is actually a drop-down list.
From here you can specify the default Control that will be used when that node is dropped onto a Form.

All of this functionality is new to VS.NET 2005. It will save you the trouble of a fair amount of work that was required in earlier
versions of the IDE to setup data-binding.

Unfortunately, I don't know of any good books to recommend. Hopefully someone else will help you out there.

--
Dave Sexton

<ew******@gmail.comwrote in message news:11*********************@p79g2000cwp.googlegro ups.com...

>I am currently going through an MCAD/MCSD training guide for Exam#
70-316. It is a great book but it shows it's age with certain subjects.
The chapter on databinding is one of these. This somewhat wordy
introduction is because I actually have 2 questions. The first one
concerns SQL. My training guide has me bringing up the Northwind sample
DB in the server explorer and it then tells me to drag and drop one of
the tables onto a form that I crafted. The idea behind this exercise
being to eventually databind this table to a gridview control on the
form. I cannot seem to drag and drop the required table anywhere as the
cursor turns into the NOT symbol and stays that way until I release the
MB. I am assuming that this is because either SQL 2005 or .NET 2005 no
longer allows 'drag and drop' although since I am a complete beginner
at SQL I could be quite mistaken. So my first question is how do I get
'drag and drop' to work in the .NET 2005 server explorer or what is the
alternative if things are done differently now.

For my second question I would like to know if there is another
training guide available that was written for use with .NET 2005 that
is recommended for beginners. I have done some research on this but the
guide that I am using keeps popping up and I haven't managed to
identify a suitable replacement.

Thank you for your consideration.

EMW

[ewingate]

Thank you very much for the reply. I will try these methods and see if
I can get the results that the book is expecting. I had to skip several
practical exercises due to these version differences. Thank you again
for the help.
-EMW