Solved

Can I create table adaptor on SQL Server database for web application in Visual Studio 2005?

Posted on 2009-05-18
2
154 Views
Last Modified: 2013-11-26
Using Visual Studio 2005, I have created a new website (not project) on the webserver.   It's working fine.  

Now I added a server connection to a database on the sql 2005server.  

In the past, with VB projects, I've been able to create a datasource for the tables and create table adaptors.  However, when I click on the datasource tab everything is dimmed out and it has no commands available.  Can I not use datasources on a web application?

Thanks!
0
Comment
Question by:okcuser
2 Comments
 
LVL 51

Accepted Solution

by:
Mark Wills earned 500 total points
ID: 24419522
Yes, but you will now need to create a project as a data access layer the content on that web site.

Have a look at : http://www.asp.net/learn/data-access/?lang=cs

They have a lot of good examples, particularly lesson 1 - creating a data access layer. Then they have some good examples further down of how it actually works - might like to jump straight into one of those if you have a bit of experience.
0
 

Author Closing Comment

by:okcuser
ID: 31582740
Thanks!
0

Featured Post

Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

766 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question