why TableAdapter.Insert method doesn't work? C#

Question

0.00/5 (No votes)

See more:

Hi everyone!

i'm using Ying Bai - Practical Database Programming with Visual C#.Net book to built my application(at least some parts of it).

about inserting data to db it says that you can use TableAdapter.Insert method to add data directly to the db. well I did it all like the example said and when I run my application I can see the added data but when I close the application and run it again then the data is not there.

One thing that makes me confused is that it says in the theory part that you need to run executeNonQuery command for this method to work, but in the example code the command is not there and it's suppose to work!

please Help! :)

Am I missing something or missunderstanding?

here's my code:

this is my insert statement built in the tableAdapter via dataset designer, the query is called InsertNewKombiQuery:

SQL

INSERT INTO KombiStateTbl(NumberPlate, LicenseExpiryDate, ControlDate, Documentos, FaróisLanternas, EstepeMacacoChaveDeRoda, Triângulo, Extintor, Acendedor, RodasCalota, Retrovisores, Párabrisa, BancosTapetes, Pneus, ParachoqueDianteiro, ParachoqueTraseiro, PortaDianteiraDireitaM, PortaDianteiraEsquerdaP, PortaLateral, LateralEsquerda, LateralEsquerdaTraseira, LateralDireitaTraseira, ParalamaTraseiroDireito, ParalamaTraseiroEsquerdo, Teto, PortaDoPortaMalas, PortaTraseiraDoMotor, Traseira, Dianteira, FaróisDianteiros, FaroisTraseiros, CurrentPic, CurrentPicPath) VALUES (@Param1,@Param2,@Param3, 'OK', 'OK', 'OK', 'OK', 'OK', 'OK', 'OK', 'OK', 'OK', 'OK', 'OK', 'OK', 'OK', 'OK', 'OK', 'OK', 'OK', 'OK', 'OK', 'OK', 'OK', 'OK', 'OK', 'OK', 'OK', 'OK', 'OK', 'OK', NULL, NULL);

and code in my form:

C#

private void okButton_Click(object sender, EventArgs e)
int intInsert = 0;
            
intInsert = kombiStateTblTableAdapter.InsertNewKombiQuery(noPlateTextBox.Text,
                licenseDateTimePicker.Value.Date, controlDateTimePicker.Value.Date);
            
            if (intInsert != 0)
            {
                MessageBox.Show("The data insertion is successful", "Success", MessageBoxButtons.OK,
                    MessageBoxIcon.Information);
                noPlateTextBox.Text = "";                
                okButton.Enabled = false;
                this.Close();
            }
            else
            {
                MessageBox.Show("The data insertion is failed", "Error", MessageBoxButtons.RetryCancel,
                    MessageBoxIcon.Error);
            }            
        }
        {

Posted 10-Dec-12 8:53am

tyska

Add a Solution

2 solutions

Solution 2

Try calling the table adpaters .Update(dataset) method after the insert call. This should commit the changes to the database.

Posted 10-Dec-12 9:35am

Dave Kreskowiak

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Jibesh · Accepted Answer · 2012-12-10T09:19:00

You havent mentioned about what is written inside the method InsertNewKombiQuery but you said the Author explained about calling ExecuteNonQuery method to dataAdapter class.

Yes inorder insert into the database table you need to perform the action on the database itself having the data's inside your local adapter class doesnt mean that you have inserted the data successfully to your database.

using (SqlConnection connection = new SqlConnection(
               connectionString))
    {
        SqlCommand command = new SqlCommand(queryString, connection);
        command.Connection.Open();
        command.ExecuteNonQuery();
    }

check your code/class for above piece of code which performs the actual database insert.
you may modify your code to pass the insert statement as the query string.