Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
HomeAnnouncementsFree MagazinesWhite PapersSubmit Content
Discussion GroupsASP.NETWindows FormsLanguages.NET FrameworkVisual Studio.NET
Articles.NET FrameworkASP.NETToolsWindows Forms
.NET DirectoryOpen Source ProjectsUser GroupsWeb Resources
Related Topics
Visual Basic 6SQL ServerMS AccessOther DB ProductsMS Server ProductsMore Topics ...

.NET Forum / Languages / C# / August 2006

Tip: Looking for answers? Try searching our database.

MCAD cert SQL question

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
ewingate@gmail.com - 21 Aug 2006 18:25 GMT
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 - 22 Aug 2006 04:37 GMT
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.

Signature

Dave Sexton

>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.
[quoted text clipped - 21 lines]
>
> EMW
ewingate@gmail.com - 23 Aug 2006 21:11 GMT
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

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...

Oracle MagazineNetwork ComputingComputer WorldBio-IT WorldeWeekInformation WeekInfosecurity
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.