C# visual-studio-2010 MySQL datagridview

将数据网格视图中的数据保存到 MySQL

发布于 2024-12-08 23:55:53 字数 1110 浏览 0 评论 0原文

我是使用 Visual Studio 2010 C# 创建应用程序的新手。我正在创建一个应用程序，用户将在 C# 的数据网格视图中输入数据，并自动将其保存在 MySQL 中。

我有这段代码来保存文本框中的数据：

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();
            }
        }
    }

我想知道这是否是从文本框中保存数据的代码，如何将数据从数据网格视图保存到MySQL。任何帮助将不胜感激。谢谢。

原文

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.

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

野却迷人 2024-12-15 23:55:53

您应该通过其 DataSource 属性将数据网格绑定到数据库，这样对网格所做的任何更改都将反映在数据库中。

示例

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

所以这就像调用一样简单

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

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