Connecting Tech Pros Worldwide Forums | Help | Site Map

dataset link to database

Member
 
Join Date: Oct 2006
Posts: 64
#1: Jul 2 '09
Hi

I had a dataSet which link to a database. I need to add one field inside the database, After adding the field, how can I update and link it to the dataSet? thanks.

Newbie
 
Join Date: Jun 2009
Posts: 6
#2: Jul 2 '09

re: dataset link to database


Are you using a code to generate your dataset or using vb.net's wizard ?
Member
 
Join Date: Oct 2006
Posts: 64
#3: Jul 2 '09

re: dataset link to database


I already have a dataset generated using vb.net control, but my database table modified, adding one field, how can I update the dataset?
Newbie
 
Join Date: Jun 2009
Posts: 6
#4: Jul 3 '09

re: dataset link to database


Click your Datasource object until you see the little "Play Button"

Click the play button and select "Configure Data Source"

Click past your connection string setup

Click on "Specify Columns from a table or view"

In there you can add your extra column
Member
 
Join Date: Oct 2006
Posts: 64
#5: Jul 3 '09

re: dataset link to database


Thank you very much, it's working fine
Reply