SQL data source in MS Visual Studio 2008

Posted by Pjmiller under Regular Expressions on 8/2/2011 | Points: 10 | Views : 6904 | Status : [Member] | Replies : 3

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

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

Reply | Reply with Attachment

Alert Moderator

Responses

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

0	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

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

0	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

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

0	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

Latest Posts