SQL data source in MS Visual Studio 2008

Posted by Pjmiller under Regular Expressions on 8/2/2011 | Points: 10 | Views : 5623 | Status : [Member] | Replies : 3
Hi,
Relatively new to ASP.net (mostly VB and C++)
I am trying to add a simple database to a content page in MS Stuio 2008 using Data Source to start the Data Source Configuration Wizard.
OS: Vista Business
Studio: MS Visual Studio 2008; MS SQL Server 2005; ASP.net 3.5; C#.

File - New Website - ASP.net 3.5 - C#

Created a website: Created a Master Page and added content pages.
Using "Murach's ASP.Net 3.5 web programming with C# 2008".

Created a basic table in SQL Server 2005.

I am trying to create a SQLData source control so I can add, edit and delete data.

Problem: There is no window for the Configure Data Source or a Data heading in the Menu.
I was able to connect to the database using Server Explorer and drag table to the content page.

Question: Where is the Configure Data Source window?

Thank you,
Paul

Paul Miller


Responses

Posted by: A4u_6178 on: 8/2/2011 [Member] Starter | Points: 25

Up
0
Down
Hi Pjmiller,

open ur aspx page
from toolboox u will find various category of controls like STANDARD, DATA and others click on DATA
from DATA category grab gridview control drop it on ur aspx page
go to design view of ur aspx page
click on the gridview control u will get a small tag at top right side then click on it
u will get window with a dropdown list from dropdown select new datasource
ur will get Data Source Configuration Wizard. follow steps there to create connection to database

Thanks & Regards,

Pjmiller, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Pjmiller on: 8/2/2011 [Member] Starter | Points: 25

Up
0
Down
Thank you for your help.
I was able to connect to the database, but my book tells me that I should get 5 additional objects when I drag the grdview control to my aspx page. Binding Navigator control; Binding Source object; DataSet object; TableAdapter object; Table AdapterManaager object.
Any suggestions/
Thank you,
Paull

Paul Miller

Pjmiller, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: A4u_6178 on: 8/3/2011 [Member] Starter | Points: 25

Up
0
Down
Hi Pjmiller,

I have not read that book, i would recommend u to have a look at following article..
http://www.asp.net/data-access/tutorials/querying-data-with-the-sqldatasource-control-cs

Thanks & Regards,

Pjmiller, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response