C1点击一列进行排序后,再选择一定范围的单元格如何按行列遍历
我点击了C1的一列,然后选择了一定范围的单元格行,要把它的内容清除掉,结果
发现清除掉的内容不是我要清的,清除到另的了,代码如下
If Me.C1FlexGrid4.RowSel > 0 And Me.C1FlexGrid4.ColSel > 0 Then
'If me.C1FlexGrid4.Selection.c2 - me.C1FlexGrid4.Selection.c1 + 1 > 1 Then
' MessageBox.Show("一次只能对一列中的选中区域进行删除,不能跨列,操作取消" & vbCrLf & "请重新操作。", "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation)
' Exit Sub
'End If
For mIntRow As Int32 = Me.C1FlexGrid4.Selection.r1 To Me.C1FlexGrid4.Selection.r2
If Me.C1FlexGrid4.Rows(mIntRow).AllowEditing = True Then
'For mIntCol As Int32 = Me.C1FlexGrid4.Selection.c1 To Me.C1FlexGrid4.Selection.c2
'If Me.C1FlexGrid4.Cols(mIntCol).AllowEditing = True Then
Dim mStock_no As String = Me.C1FlexGrid4(mIntRow, 1).ToString()
DBUtility.SQLite.SQLiteHelper.ExecuteNonQuery(MySqlLite_Con, "DELETE FROM classamtin WHERE class_code = 'C._BKDL' and stock_no = '" & mStock_no & "' ; ", Nothing)
Me.C1FlexGrid4.SetData(mIntRow, 1, "")
Me.C1FlexGrid4.SetData(mIntRow, 2, "")
Me.C1FlexGrid4.RemoveItem(Me.C1FlexGrid4.Rows(mIntRow).Index)
'End If
'Next
End If
Next
End If
请问一下老师,这个要怎样写是不是经过排序后我的Dim mStock_no As String = Me.C1FlexGrid4(mIntRow, 1).ToString()取到的值有问题,
但是我是排序后再选择的一定cellrange的,再遍历的。
|
|