在datagridview的1列下面添加20行 [英] Add 20 Rows below The 1 column in datagridview

问题描述

使用vb.net在1列下方添加20行，然后将所有这些数据添加到Access数据库中都可以对此有所帮助.

add 20 rows below the 1 column using vb.net and then all these data add in access database can any help for this.

推荐答案

您好，

您的网格是否绑定到数据源?如果是这样，那么您应该在该数据源(而不是网格)中添加和删除行.如果网格是未绑定的，则可以调用网格的Rows集合的Add和Remove方法.

使用textBox列向datagridview添加行

Hi,

Is your grid bound to a data source? If so then you should be adding and deleting rows in that data source, not the grid. If the grid is unbound then you call the Add and Remove methods of the grid''s Rows collection.

Adding a row to datagridview with textBox columns

Dim dgvRow As New DataGridViewRow
Dim dgvCell As DataGridViewCell

dgvCell = New DataGridViewTextBoxCell()
dgvCell.Value = "anis"
dgvRow.Cells.Add(dgvCell)

dgvCell = New DataGridViewTextBoxCell()
dgvCell.Value = "khan"
dgvRow.Cells.Add(dgvCell)

DataGridView1.Rows.Add(dgvRow)

并在访问中添加多行，请尝试如下

and to add multiple rows in access try like following

Dim rsTemp     As DAO.Recordset
Dim i          As Integer

    'Create a copy of this forms Recordset

    Set rsTemp = Me.RecordsetClone

    rsTemp.MoveFirst

    'Loop through all records and Add new record..

    For i = 1 To rsTemp.RecordCount

        If Me.CurrentRecord = True Then
            CurrentDb.Execute INSERT INTO table (column-1, column-2, ... column-n) VALUES (value-1, value-2, ... value-n);
        End If

        rsTemp.MoveNext

    Next i

    'Release resources

    rsTemp.Close

    Set rsTemp = Nothing

祝你好运
快乐编码:)

Best Luck
Happy Coding:)

这篇关于在datagridview的1列下面添加20行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！