-
Oct 1st, 2014, 09:49 AM
#1
Thread Starter
New Member
Insert Data in a local Database
Hi everyone, i'm a new member and i'm learning vb. I need help for a simple project. I need to build a Database (.sdf) with vb 2010 and insert/get data from it. The problem is when I insert the data with INSERT INTO queries (previously created in Data Set with Wizard), it doesn't seem to fill. Every time i click Show Data Preview in Database Explorer. it shows me a empty table.
well... this is the code in the insertion form:
Me.ScommessaTableAdapter.InserimentoDati(Data.Text, Mercato.Text, Partita.Text, Segno.Text, Soldi.Text, Val(Quota.Text), Motivazione.Text, Netto.Text, Sito.Text, Esito.SelectedItem)
Me.ScommessaTableAdapter.Update(Me.BetDataDataSet)
this is the query created:
this is the program with 1 record:
so... this means that now the database contains a record: but...
nothing
and puff, if i retry with the program, the record has disappeared
The rest of the code is useless regard to the error
Last edited by Karapost; Oct 1st, 2014 at 01:44 PM.
Reason: Adding things
-
Oct 1st, 2014, 12:49 PM
#2
Re: Insert Data in a local Database
Do you get an error? If not here is a link I got from jmc that talks about the topic. http://msdn.microsoft.com/en-us/libr...89(VS.80).aspx
It would help to see you code, we have no idea what's going on without that.
-
Oct 1st, 2014, 12:58 PM
#3
Re: Insert Data in a local Database
Yes, please post your code so we can examine it. Also, please use [CODE] tags. Oh, and welcome to the forums!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|