Insert Data in a local Database

[Karapost]

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

[wes4dbt]

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.

[Jenner]

Yes, please post your code so we can examine it. Also, please use [CODE] tags. Oh, and welcome to the forums!