How do I get my data from datagridview to sqlite database

Question

1.00/5 (2 votes)

See more:

I want to save my data from datagridview to my SQLite database but there is some errors.

The data could not get saved into the database and the error message box keeps popping up

What I have tried:

SQLiteConnection sa = new SQLiteConnection("Data Source=|DataDirectory|\\trendchart.db");
           sa.Open();

           using (SQLiteConnection sqlconn = new SQLiteConnection(sa))
           {

               foreach (DataGridViewRow row in dataGridView1.Rows)
               {
                   for (int z = 0; z < 31; z++)

                   {
                       using (SQLiteCommand sqlcomm = sqlconn.CreateCommand())
                       {

                           sqlcomm.CommandText = "Insert into data (TOP(1),TOP(2) ) values(@TOP(1),@TOP(2))";
                           try
                           {
                               sqlcomm.Parameters.AddWithValue("TOP(1)", dataGridView1.CurrentRow.Cells["TOP(1)"].Value.ToString());
                               sqlcomm.Parameters.AddWithValue("TOP(2)", dataGridView1.CurrentRow.Cells["TOP(2)"].Value.ToString());
                               sqlcomm.ExecuteNonQuery();
                               MessageBox.Show("Data is save please check thks ");

                           }
                           catch (Exception ex)
                           {
                               MessageBox.Show("Error Please fix ");
                           }
                       }
                   }

Posted 4-Jul-18 22:48pm

Member 13809133

Updated 5-Jul-18 1:28am

v2

Add a Solution

Comments

Richard MacCutchan 5-Jul-18 5:25am

What errors? Please do not expect us to guess what happens when you run your code, we cannot see your screen.

2 solutions

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)

CHill60 · Answer 1 · 2018-07-05T01:28:00

I'm pretty sure it's the way you've named your columns and your sql parameters. Try this instead

C#

sqlcomm.CommandText = "Insert into data ([TOP(1)],[TOP(2)] ) values(@TOP1,@TOP2)";
 try
 {
     sqlcomm.Parameters.AddWithValue("@TOP1", dataGridView1.CurrentRow.Cells["TOP(1)"].Value.ToString());
     sqlcomm.Parameters.AddWithValue("@TOP2", dataGridView1.CurrentRow.Cells["TOP(2)"].Value.ToString());
     sqlcomm.ExecuteNonQuery();

Points to Note:
- the square brackets around the column names - they'd be illegal otherwise.
- The @ symbols when adding the parameters
- Removal of the (illegal) characters in the parameter names - TOP(1) becomes @TOP1

Graeme_Grant · Answer 2 · 2018-07-05T01:15:00

Solution 1

This is one way to do it: Portable databases (II): using SQLite with Entity Framework[^]

Posted 5-Jul-18 1:15am

Graeme_Grant