编辑gridview数据并保存在Mysql数据库中，Winforms [英] edit gridview data and save in Mysql database,Winforms

问题描述

在按钮中单击我填充的gridview（数据库中的列没有主键），使用dataAdapter，数据集。



当我选择一个单元格时，该记录应该在文本框中进行编辑，编辑后应保存在数据库中。



编辑按钮应该在gridview单元格的数据库列的末尾怎么办.....



这里是我的代码：

Hi,

In button click i populated gridview (no primary key for columns in database), using dataAdapter,dataset.

when i select a cell , that record should come in textboxes for editing data, after editing that should be saved in database.

edit button should be in gridview cell at the end of columns of database how to do.....

here is my code:

<pre lang="c#">using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using MySql.Data.MySqlClient;
using System.Data.OleDb;
using System.Text.RegularExpressions;

namespace Billling_Machine
{
    public partial class EditTransaction : Form
    {

        String ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["myConnectionString"].ConnectionString;
        DataSet ds = new DataSet();
        MySqlDataAdapter da;
        MySqlCommandBuilder commandbuilder;
        String query;

        public EditTransaction()
        {
            InitializeComponent();
        }

        private void btnedittxok_Click(object sender, EventArgs e)
        {
            String date1 = dateTimePicker1.Text;
            String[] date = Regex.Split(date1, "[/: ]");
            StringBuilder sb = new StringBuilder();
            sb.Append(date[2]);
            sb.Append("-");
            sb.Append(date[0]);
            sb.Append("-");
            sb.Append(date[1]);
            String fromdate = sb.ToString();


            String date2 = dateTimePicker2.Text;
            String[] date3 = Regex.Split(date2, "[/: ]");
            StringBuilder sb1 = new StringBuilder();
            sb1.Append(date3[2]);
            sb1.Append("-");
            sb1.Append(date3[0]);
            sb1.Append("-");
            sb1.Append(date3[1]);
            String todate = sb1.ToString();
            
            String customer = txtedittxcustomer.Text;
            String card = txtedittxcard.Text;


            using (MySqlConnection con = new MySqlConnection(ConnectionString))
            {
                query = "select * from transaction where DATE(paid_date)BETWEEN '" + fromdate + "'AND'" + todate + "' AND customer_id='" + customer + "' ";
                con.Open();
               da = new MySqlDataAdapter(query, con);
                         
             da.Fill(ds);
             dataGridView1.DataSource = ds;
             dataGridView1.DataMember = ds.Tables[0].ToString();
             DataGridViewButtonColumn ButtonColumn = new
DataGridViewButtonColumn();
             ButtonColumn.Text = "Edit";
             ButtonColumn.Name = "Edit";
             ButtonColumn.DataPropertyName = "del";
             dataGridView1.Columns.Add(ButtonColumn);

            
            }
            groupBox2.Visible = true;

        }

        private void EditTransaction_Load(object sender, EventArgs e)
        {
            groupBox2.Visible = false;
        }

推荐答案

试试这些链接，



< a href =http://csharp.net-informations.com/datagridview/csharp-datagridview-button.htm> http://csharp.net-informations.com/datagridview/csharp-datagridview-button.htm [ ^ ]

http：//www.c -sharpcorner.com/UploadFile/9a3ae2/working-with-datagridview-checkboxcombobox-and-button-colum/ [ ^ ]

Try these links,

http://csharp.net-informations.com/datagridview/csharp-datagridview-button.htm[^]
http://www.c-sharpcorner.com/UploadFile/9a3ae2/working-with-datagridview-checkboxcombobox-and-button-colum/[^]

这篇关于编辑gridview数据并保存在Mysql数据库中，Winforms的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！