[RESOLVED] [2008] Datagridview & comboboxcell

[onlyGirl]

I have a datagridview that has a comboboxcell in a column and I'm having trouble retrieving the value from it. The comboboxcell has a different datasource from the other data on the datagridview. Can anybody tell me what I'm doing wrong? I only retrieve blank info from it using the code below:

 Private Sub DataGridView1_DefaultValuesNeeded(ByVal sender As Object, ByVal e As System.Windows.Forms.DataGridViewRowEventArgs) Handles DataGridView1.DefaultValuesNeeded
        Me.GetAPI()
        cmbAPI.DataSource = dsAPI.Tables("Well_Header")
        cmbAPI.ValueMember = "API"
        e.Row.Cells(0) = cmbAPI
        
    End Sub

Public Sub GetDefaultVal()
        If FutWellType = "Production" Then

            prodStartDt = DataGridView1.Rows(lasRow).Cells(1).Value.ToString() 'StartDate
            prodEndDt = DataGridView1.Rows(lasRow).Cells(2).Value.ToString() 'EndDate
            prodIniRt = DataGridView1.Rows(lasRow).Cells(3).Value.ToString() 'InitialRate
            prodFinRt = DataGridView1.Rows(lasRow).Cells(4).Value.ToString() 'FinalRate
            prodDecRt = DataGridView1.Rows(lasRow).Cells(5).Value.ToString() 'DeclineRate
            prodDecTy = DataGridView1.Rows(lasRow).Cells(6).Value.ToString() 'DeclineType
            prodHypFac = DataGridView1.Rows(lasRow).Cells(7).Value.ToString() 'HypFactor
            prodGasOilRt = DataGridView1.Rows(lasRow).Cells(8).Value.ToString() 'GasOilRatio
            prodExtDt = DataGridView1.Rows(lasRow).Cells(9).Value.ToString() 'ExtendDate
            prodGasOil = DataGridView1.Rows(lasRow).Cells(10).Value.ToString() 'GasOil
            prodConFlVl = DataGridView1.Rows(lasRow).Cells(11).Value.ToString() 'ConstFlVol
            prodInitWtr = DataGridView1.Rows(lasRow).Cells(12).Value.ToString() 'InitialWater
        ElseIf FutWellType = "Injection" Then
            'injAPI = DataGridView1.Rows(newRow).Cells(0).Value.ToString()
            injStartDt = DataGridView1.Rows(lasRow).Cells(1).Value.ToString()
            injEndDt = DataGridView1.Rows(lasRow).Cells(2).Value.ToString()
            injInitRt = DataGridView1.Rows(lasRow).Cells(3).Value.ToString()
            injFinRt = DataGridView1.Rows(lasRow).Cells(4).Value.ToString()
            injDeclineRt = DataGridView1.Rows(lasRow).Cells(5).Value.ToString()
            injDeclTyp = DataGridView1.Rows(lasRow).Cells(6).Value.ToString()
            injHypFactor = DataGridView1.Rows(lasRow).Cells(7).Value.ToString()
            injExtendDt = DataGridView1.Rows(lasRow).Cells(8).Value.ToString()
        End If

 Public Sub AutoFillRow()
        Dim cmdAutoFillRow, cmdAutoFillRowInj As New OleDbCommand
        cmdAutoFillRow.Connection = gConn
        cmdAutoFillRow.Transaction = rlBack
        cmdAutoFillRowInj.Transaction = rlBack

        If FutWellType = "Production" Then
            cmdAutoFillRow.CommandText = "INSERT INTO Param_Prod " _
            & "(API, StartDate, EndDate, Reservoir, " _
            & "InitialRate, FinalRate, DeclineRate, DeclineType, " _
            & "HypFactor, ExtendDate, GasOilRatio, GasOil, " _
            & "ConstFlVol, TemplateName, LastUpdated, InitialWater)" _
            & "VALUES (@prAPI, @prStartDt, @prEndDt, '" & Resvr & "', " _
            & "@prInitialRt, @prFinalRt, @prDeclineRt, @prDeclineTy, " _
            & "@prHypFactor, @prExtendDate, @prGasOilRat, @prGasOil, " _
            & "@prConstFlVol, '" & PrmName & "', 'Y', @prInitialWater)"

            cmdAutoFillRow.Parameters.AddWithValue("@prAPI", cmbAPI.Value.ToString())
            cmdAutoFillRow.Parameters.AddWithValue("@prStartDt", prodStartDt)
            cmdAutoFillRow.Parameters.AddWithValue("@prEndDt", prodEndDt)
            cmdAutoFillRow.Parameters.AddWithValue("@prInitialRt", prodIniRt)
            cmdAutoFillRow.Parameters.AddWithValue("@prFinalRt", prodFinRt)
            cmdAutoFillRow.Parameters.AddWithValue("@prDeclineRt", prodDecRt)
            cmdAutoFillRow.Parameters.AddWithValue("@prDeclineTy", prodDecTy)
            cmdAutoFillRow.Parameters.AddWithValue("@prHypFactor", prodHypFac)
            cmdAutoFillRow.Parameters.AddWithValue("@prExtendDate", prodExtDt)
            cmdAutoFillRow.Parameters.AddWithValue("@prGasOilRt", prodGasOilRt)
            cmdAutoFillRow.Parameters.AddWithValue("@prGasOil", prodGasOil)
            cmdAutoFillRow.Parameters.AddWithValue("@prConstFlVol", prodConFlVl)
            cmdAutoFillRow.Parameters.AddWithValue("@prInitialWater", prodInitWtr)
            cmdAutoFillRow.ExecuteNonQuery()
EndIf

[jmcilhinney]

Just like any cell in a DataGridView, you get the value in a DataGridViewComboBoxCell from its Value property.

Here's how a DataGridViewComboBoxCell works. Just like all other cells in a DataGridView it doesn't contain a control by default. It simply renders its Value. Now, when you start editing a cell a control is created, if one does not already exist, and it is embedded in the cell. In the case of a combo box cell, the control's DataSource, DisplayMember, ValueMember and Items properties are set from cell's properties, which are set from the column's properties, which you set yourself. The cell's Value property is then assigned to the control's SelectedValue property. You then merrily edit the combo box itself without affecting the cell hosting it. When you press Enter or leave the cell the editing sessions ends. At that point the control is removed from the cell and its SelectedValue property is assigned to the cell's Value property.

In principle, this is how ALL data cells in a DataGridView work. The only difference is what property values get passed from the cell to the editing control and then back to the cell. Regardless of the type of cell, you get its value from its rather aptly named Value property.

[onlyGirl]

Just like any cell in a DataGridView, you get the value in a DataGridViewComboBoxCell from its Value property.

Here's how a DataGridViewComboBoxCell works. Just like all other cells in a DataGridView it doesn't contain a control by default. It simply renders its Value. Now, when you start editing a cell a control is created, if one does not already exist, and it is embedded in the cell. In the case of a combo box cell, the control's DataSource, DisplayMember, ValueMember and Items properties are set from cell's properties, which are set from the column's properties, which you set yourself. The cell's Value property is then assigned to the control's SelectedValue property. You then merrily edit the combo box itself without affecting the cell hosting it. When you press Enter or leave the cell the editing sessions ends. At that point the control is removed from the cell and its SelectedValue property is assigned to the cell's Value property.

In principle, this is how ALL data cells in a DataGridView work. The only difference is what property values get passed from the cell to the editing control and then back to the cell. Regardless of the type of cell, you get its value from its rather aptly named Value property.

I have also tried the code that specifies the row of where the combobox is located and it still shows up blank. It is retrieving the value but the value is coming back blank. Intellisence also doesn't show me SelectedValue as an option for the combobox.

[jmcilhinney]

You seem to have completely missed the point. In the very first sentence of my reply I have you the solution. You get a cell's value from its Value property, end of story. The rest was just some background to try to enlighten you about how the cell interacts with the control. You don't actually need any of that to get or set a cell's Value.

[onlyGirl]

You seem to have completely missed the point. In the very first sentence of my reply I have you the solution. You get a cell's value from its Value property, end of story. The rest was just some background to try to enlighten you about how the cell interacts with the control. You don't actually need any of that to get or set a cell's Value.

No I didn't miss the point. I know what exactly you were saying. Although that didn't work for me. I don't know why but it didn't. I had to add a handler in order to retrieve the value.

[jmcilhinney]

No I didn't miss the point. I know what exactly you were saying. Although that didn't work for me. I don't know why but it didn't. I had to add a handler in order to retrieve the value.

Huh? You get a cell's value from its Value property, end of story. Where or when you do it is another matter because it depends where and when you need it. There is absolutely no reason that should have been trying to get a SelectedValue, which you said you were. As I explained earlier, it is the SelectedValue of the ComboBox control embedded in the cell that gets pushed down to the cell's Value property, but ONLY once the user has ended the edit session. The edit session will end when the user leaves the cell and the ComboBox control is removed. I think you'll find that pressing Enter will do so also.

So, the fact that you had to add an event handler is irrelevant. You would still be getting the cell's value from its Value property within that event handler. I didn't say anything about where or when you get the value, just that it is gotten from the Value property.

[angelica]

I dont know whether this is referring to the same problem I had about a week ago. JMC had indicated to me to use the

comboname.text --------- to get the actual data.

See if this works for you too. I have a limited knowledge of VB.Net so pardon me if I misunderstood your point.