take value from empty datagridview and insert it to database c#

Question

I want to insert data from empty DataGridView to database (the DataGridView doesn't load from the database, but I just take the value in DataGridView).

I tried this code:

private void vButton12_Click(object sender, EventArgs e)
    {
        MySqlConnection conn = new MySqlConnection("server=localhost;User Id=root;database=sma9");
        DataTable dtable = new DataTable();
        MySqlDataAdapter adp = new MySqlDataAdapter("select * from tdetpinjam", conn);
        adp.Fill(dtable);            
        for (int i = 0; i < dtable.Rows.Count; i++)
        {
            MySqlDataAdapter adp1 = new MySqlDataAdapter("INSERT INTO tdetpinjam (nopinjam,kodebuku,jumlah,tglkembali,status) VALUES ('" + dtable.Rows[i][dtable.Columns.IndexOf("Column1")] + "','" + dtable.Rows[i][dtable.Columns.IndexOf("Column2")] + "','" + dtable.Rows[i][dtable.Columns.IndexOf("Column3")] + "','" + dtable.Rows[i][dtable.Columns.IndexOf("Column4")] + "','" + dtable.Rows[i][dtable.Columns.IndexOf("Column5")] + "')", conn);
            conn.Open();
            adp1.Fill(dtable);
            conn.Close();
        }
    }

But I get the error "cannot find column -1".

What is wrong in my code? What is the best solution to do this?

Adam · Accepted Answer · 2012-06-02 15:11:30Z

1

I guess one of these return -1:

dtable.Columns.IndexOf("ColumnX")

answered Jun 2, 2012 at 15:11

Adam

27k8 gold badges65 silver badges85 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Damith · Accepted Answer · 2012-06-03 09:04:43Z

0

what you are doing is completely wrong, there is no datagrid related code in your code, you just get data from database table and loop though each row returned and try to insert same data again to same table in the database. in each item you try to fill same table from database.

actual error occur when you get index of given column, you need to validate it before insert

    if(dtable.Columns.IndexOf("Column1") != -1 && 
    dtable.Columns.IndexOf("Column2") != -1 && 
    dtable.Columns.IndexOf("Column3") != -1 && 
    dtable.Columns.IndexOf("Column4") != -1 && 
    dtable.Columns.IndexOf("Column5") != -1)
    {
       // insert related code 
    }

if you need to insert records using MySqlDataAdapter, fist set select, update and insert commands of MySqlDataAdapter, then you can call MySqlDataAdapter.Update method.

check this for more info.

EDIT

foreach (DataGridViewRow row in dataGrid.Rows)
{
         foreach (DataGridViewCell cell in row.Cells)
        {
            string value = cell.Value.ToString();

        }
 }

edited Jun 3, 2012 at 9:04

answered Jun 2, 2012 at 15:50

Damith

63.2k13 gold badges106 silver badges154 bronze badges

1 Comment

Isyar Harun Over a year ago

so how to read the data from datagridview ? so i can insert it to database ?

Collectives™ on Stack Overflow

take value from empty datagridview and insert it to database c#

2 Answers 2

Comments

EDIT

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

EDIT

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related