Saving Data in Data Grid View to MySQL

Question

I am new in creating application using Visual Studio 2010 C#. I am creating an application where the user will input data in a data grid view in C# and automatically save it in MySQL.

I have this code to save the data from a textbox:

private void buttonSaveEmployee_Click(object sender, EventArgs e)
    {
        string MyConString = "SERVER=localhost;" + "DATABASE=payroll;" + "UID=root;" + "PASSWORD=admin;";
        MySqlConnection connection = new MySqlConnection(MyConString);
        MySqlCommand command = connection.CreateCommand();
        command.Connection = connection;
        using (MySqlConnection conn = new MySqlConnection(MyConString))
        {
            connection.Open();
            using (MySqlCommand com = connection.CreateCommand())
            {
                command.CommandText = "insert into employee(employee_lastname) values(?employee_lastname)";
                command.Parameters.Add(new MySqlParameter("?employee_lastname", MySqlDbType.VarChar));
command.Parameters["?employee_lastname"].Value = textBoxEmpLastName.Text;
                command.ExecuteNonQuery();
            }
        }
    }

I am wondering if this is the code to save a data from a textbox, how can I save the data from data grid view to MySQL. Any help will be much appreciated. Thanks.

Michael D. Irizarry · Accepted Answer · 2011-10-10 02:43:49Z

2

You should bind your datagrid to the database thru its DataSource property this way any changes done to the grid will be reflected in the database.

Example

MySqlDataAdapter mySqlDataAdapter = new MySqlDataAdapter("select * from employee", connection);
DataSet DS = new DataSet();
mySqlDataAdapter.Fill(DS);
dataGridView1.DataSource = DS.Tables[0];

So it would be as easy as calling

mySqlDataAdapter.Update(DS.Tables[0]);

edited Oct 10, 2011 at 2:43

answered Oct 10, 2011 at 2:38

Michael D. Irizarry

6,3825 gold badges33 silver badges35 bronze badges

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

2 Comments

Brock Hensley Over a year ago

Update requires a valid UpdateCommand when passed DataRow collection with modified rows.

Lorenzo Belfanti Over a year ago

Same problem of @BrockHensley

Collectives™ on Stack Overflow

Saving Data in Data Grid View to MySQL

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related