Connecting Tech Pros Worldwide Help | Site Map
bytes > topic > visual basic .net > answers

dataset link to database

  #1  
Old July 2nd, 2009, 04:28 PM
Member
  
Join Date: Oct 2006
Posts: 64
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.
  #2  
Old July 2nd, 2009, 05:29 PM
Newbie
  
Join Date: Jun 2009
Posts: 6

re: dataset link to database

Are you using a code to generate your dataset or using vb.net's wizard ?
  #3  
Old July 2nd, 2009, 11:59 PM
Member
  
Join Date: Oct 2006
Posts: 64

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?
  #4  
Old July 3rd, 2009, 12:21 AM
Newbie
  
Join Date: Jun 2009
Posts: 6

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
  #5  
Old July 3rd, 2009, 03:16 AM
Member
  
Join Date: Oct 2006
Posts: 64

re: dataset link to database

Thank you very much, it's working fine
Reply

« previous question | next question »

Similar Threads
Thread Thread Starter Forum Replies Last Post
Problem on INSERTING a record to database using typed datasets Surya answers 3 September 23rd, 2007 08:45 AM
How to push data from datatable to database Bhavna answers 5 November 22nd, 2005 08:10 AM
Dataset to database. Craig answers 2 November 16th, 2005 04:04 AM
How to push data from datatable to database Bhavna answers 5 July 21st, 2005 01:07 PM

/bytes/development

/bytes/it

/bytes/about

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over 225,662 network members.

dev questions:
algorithms | asp | asp.net | c/c++ | coldfusion | c# | flash | html/css | java | javascript |
mobile dev | .net | perl | php | python | ruby | software dev | vb.net | visual basic | xml
it questions:
access | apache | careers | db2 | iis | macosx | mysql | networking | oracle | postgresql | sql server | unix | windows

About Bytes | Copyright 1995-2009 BYTES. All rights Reserved