PC Review


Reply
Thread Tools Rate Thread

How can i save the data in the database using the BindingSource?

 
 
giannis
Guest
Posts: n/a
 
      20th Feb 2007
I am a newbie with VB.
I'm trying to add a new row to my database using the BindingSource.
I use the AddNew() and EndEdit() methonds but my changes dont
saved at my database ...
What is wrong ? How can i save my changes in the database (datasourse) ?
Some code it will acceptable.
Sorry for my english and thank you !


 
Reply With Quote
 
 
 
 
ClayB
Guest
Posts: n/a
 
      20th Feb 2007
Are you using DataTables, DataSets and DataAdapters to load your data
into your application? If so, you would call dataAdapter1.Update to
save your changes back to the database.
===================
Clay Burch
Syncfusion, Inc.

 
Reply With Quote
 
giannis
Guest
Posts: n/a
 
      20th Feb 2007
ClayB wrote:
> Are you using DataTables, DataSets and DataAdapters to load your data
> into your application? If so, you would call dataAdapter1.Update to
> save your changes back to the database.


I have write :
BindingSource.EndEdit()
Me.TABLETableAdapter.Update(Me.DataSet.TABLE)

but the data dont saved at the database.

Can you give me an example please ?

Thank you !




 
Reply With Quote
 
RobinS
Guest
Posts: n/a
 
      20th Feb 2007

"giannis" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> ClayB wrote:
>> Are you using DataTables, DataSets and DataAdapters to load your data
>> into your application? If so, you would call dataAdapter1.Update to
>> save your changes back to the database.

>
> I have write :
> BindingSource.EndEdit()
> Me.TABLETableAdapter.Update(Me.DataSet.TABLE)
>
> but the data dont saved at the database.
>
> Can you give me an example please ?
>
> Thank you !
>
>


What type of database are you using? SQLServer, SQLServerEXpress, Access?

Robin S.


 
Reply With Quote
 
giannis
Guest
Posts: n/a
 
      20th Feb 2007
RobinS wrote:
> What type of database are you using? SQLServer, SQLServerEXpress,
> Access?


Access


 
Reply With Quote
 
RobinS
Guest
Posts: n/a
 
      20th Feb 2007

"giannis" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> RobinS wrote:
>> What type of database are you using? SQLServer, SQLServerEXpress,
>> Access?

>
> Access
>


Do some reading. You'll learn it better.

http://msdn2.microsoft.com/en-us/library/ms171932(VS.80).aspx

Robin S.


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
BindingSource does not update database RB Microsoft Dot NET Compact Framework 0 16th May 2008 03:02 AM
Save mix data in database =?Utf-8?B?SHVzYW0=?= Microsoft ADO .NET 2 29th Oct 2007 05:18 PM
setting BindingSource data types from an XML data source michael sorens Microsoft C# .NET 4 30th Aug 2006 09:32 PM
How to save data into the database with data in textbox in asp.net =?Utf-8?B?U2h1YmhhbW0=?= Microsoft Dot NET 1 28th Sep 2004 01:59 PM
Re: How to save data to a database in vb... One Handed Man \( OHM - Terry Burns \) Microsoft VB .NET 0 2nd Jul 2004 04:42 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 03:05 AM.