Rows cannot be programmatically added to the DataGridView's rows collection

[mails4vijayakumar]

how to add Rows programmatically to the DataGridView's rows collection when the control is data-bound?


here is my code but i got error as "Rows cannot be programmatically added to the DataGridView's rows collection when the control is data-bound? "


dtagrdScaleoffinance.Rows.Add(New Object() {Me.txtAccountNumber.Text, Me.txtAccountnumberScaleOfFinance.Text, Me.cmbxCropCode.SelectedIndex, (Me.mskdeffectivedate.Text)

[.paul.]

add a row to your datasource + it'll appear in your dgv

[mails4vijayakumar]

sorry to ask u again how to add in datasource....


please give me some sample code

[.paul.]

can you post the code you use to bind your DataGridView?

[mails4vijayakumar]

Private Sub scaleoffinanceview()

Dim dt As New DataTable

dtagrdScaleoffinance.Visible = True

PacsKccDetailsdatagridView.Visible = True

Dim da As OdbcDataAdapter = New OdbcDataAdapter("select * from scaleoffinancedetails_mig where oldaccountnumber = '" & txtAccountNumber.Text & "' ", con)

Dim ds As DataSet = New DataSet

Try

da.Fill(ds, "scaleoffinancedetails_mig")

dt = ds.Tables(0)

dtagrdScaleoffinance.DataSource = dt

Catch ex As Exception

MessageBox.Show(ex.Message)

End Try

End Sub


thi is my code for databinding

[.paul.]

ok. declare dt at form level:

Dim dt As New DataTable

to add a new row:

dim dr as datarow = dt.newrow
dr.itemarray = New Object() {Me.txtAccountNumber.Text, Me.txtAccountnumberScaleOfFinance.Text, Me.cmbxCropCode.SelectedIndex, Me.mskdeffectivedate.Text}
dt.rows.add(dr)

[mails4vijayakumar]

thank you for ur reply.


i tried your code but i am getting error as input array is longer than number of column in this table

[.paul.]

how many columns does your datatable have?
this is the line you need to change:

dr.itemarray = New Object() {Me.txtAccountNumber.Text, Me.txtAccountnumberScaleOfFinance.Text, Me.cmbxCropCode.SelectedIndex, Me.mskdeffectivedate.Text}