none
how to get the selected value from DataGridViewComboBoxColumn to save in MySQL DB? RRS feed

  • Question

  • I have a DataGridViewComboBoxColumn loaded with data from MySQ on DataGridView

    DROP TABLE IF EXISTS `pin10`;
    CREATE TABLE IF NOT EXISTS `pin10` (
      `id` int(11) NOT NULL,
      `f1` varchar(30) NOT NULL,
      PRIMARY KEY (`id`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    
    
    Imports MySql.Data.MySqlClient
    
    Dim combo As New DataGridViewComboBoxColumn
    
        Sub LoadComboBox()
            Dim strSQL As String
    
            OpenDB()
            strSQL = "Select * From Pin10"
    
            ds1 = New DataSet
            tables1 = ds1.Tables
            da1 = New MySqlDataAdapter(strSQL, myConnection2) 
            da1.Fill(ds1, "Pin10") 
            Dim view1 As New DataView(tables1(0))
    
            combo.DataSource = view1
            CloseDB()
        End Sub
        
        Public Sub ReadDB()
            Dim strSQL As String
    
            LoadComboBox()
    
            OpenDB()
    
            strSQL = "Select p11.id, p11.f1, p11.f2, "
            strSQL = strSQL + "p11.f3, "
            strSQL = strSQL + "p10.f1, "
            strSQL = strSQL & " From Pin11 as p11 "
            strSQL = strSQL & " LEFT JOIN pin10 AS p10 ON p11.f7=p10.id "
            strSQL = strSQL & " order by p11.ID "
    
            ds = New DataSet
            tables = ds.Tables
            da = New MySqlDataAdapter(strSQL, myConnection2) 
            da.Fill(ds, "Pin11") 
            Dim view As New DataView(tables(0))
            source1.DataSource = view
    
            DataGridView1.AutoGenerateColumns = False  
            DataGridView1.DataSource = view
    
            Dim colId As New DataGridViewTextBoxColumn()
            colId.DataPropertyName = "Id"
            colId.HeaderText = "A/A"
            DataGridView1.Columns.Add(colId)
    
            Dim colf1 As New DataGridViewTextBoxColumn()
            colf1.DataPropertyName = "f1"
            colf1.HeaderText = "Name"
            colf1.Width = 200
            DataGridView1.Columns.Add(colf1)
    
            Dim colf2 As New DataGridViewTextBoxColumn()
            colf2.DataPropertyName = "f2"
            colf2.HeaderText = "Type"
            colf2.Width = 100
            DataGridView1.Columns.Add(colf2)
    
            Dim colf3 As New DataGridViewCheckBoxColumn
            colf3.DataPropertyName = "f3"
            colf3.HeaderText = "Value 1"
            colf3.Width = 100
            DataGridView1.Columns.Add(colf3)
    
            combo.ValueMember = "id"
            combo.DisplayMember = "f1"
            combo.DataPropertyName = "f110"
            combo.HeaderText = "Type Account"
            DataGridView1.Columns.Add(combo)
        
            DataGridView1.Refresh()
    
            CloseDB()
        End Sub

    When I changed the value in the DataGridViewComobBoxColumn, how can I get the new values (id and f1) and store them back the base with commands INSERT and UPDATE?


    Sunday, June 30, 2019 9:47 AM

Answers

All replies