如何在Datagridview中的每一行中插入唯一编号 [英] How Do I Insert Unique Number In Each Row In Datagridview

问题描述

我正在使用vb表单和SQL Server 2014我的问题是我将数据加载到datagridview

当我循环datagridview从数据库插入最大收据编号

所以datagridiew中的每一行都有唯一的收据编号

i am using vb form and SQL server 2014 my problem is i load data to datagridview
the when i loop the datagridview to insert max receipt number from database
so that each row in datagridiew have unique receipt number

For Each Row As DataGridViewRow In DataGridView1.SelectedRows
Dim i As Integer
Dim mixReciptNumber As Integer = ReceiptEntryTableAdapter1.ScalarQuery1(BILL")
For i = 0 To mixReciptNumber + 1
ReciptNumber = mixReciptNumber + 1

next
'Me.ReceiptEntryTableAdapter1.InsertQuery(ReciptNumber, 0, DateTimePicker1.Text, DateTimePicker1.Text, Row.Cells(1).Value, Row.Cells(2).Value, Row.Cells(3).Value, "0", "Group", Row.Cells(6).Value, Row.Cells(7).Value, Row.Cells(8).Value, Row.Cells(9).Value, "0", "0", "0")
next

推荐答案

如果我理解正确你想为每个选中增加 ReciptNumber DataFridView中的行。所以，你只需要一个循环：

If i understand you correctly you want to increase ReciptNumber for each selected row in DataFridView. So, you need only one loop:

Dim ReciptNumber As Integer = 0
Dim mixReciptNumber As Integer = ReceiptEntryTableAdapter1.ScalarQuery1("BILL")
ReciptNumber = mixReciptNumber 
For Each Row As DataGridViewRow In DataGridView1.SelectedRows
    ReciptNumber = mixReciptNumber + 1
    'insert part
Next

这篇关于如何在Datagridview中的每一行中插入唯一编号的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！