如何获取datagridview的行值,并使用同一行中的按钮将其传递给另一种形式
发布于 2021-04-15 10:23:53
Public Sub LoadDataAS()
grdApplicantsAS.DataSource = Nothing
grdApplicantsAS.Columns.Clear()
txtSearchBar1.Clear()
mycom.Connection = cn
mycom.CommandText = "SELECT concat_ws(',', LastName, FirstName, MiddleName) as 'Applicant Name',EDate as 'Date of Examination', EScore as 'Examination Score', IStatus as 'Interview Status',IComment as 'Interview Comment' FROM tbl_applicant"
Dim myadap As New MySqlDataAdapter(mycom)
Dim mydt As New DataTable
myadap.Fill(mydt)
grdApplicantsAS.DataSource = mydt
Dim buttonColumn As New DataGridViewButtonColumn()
buttonColumn.HeaderText = ""
buttonColumn.Name = "Status Request"
buttonColumn.Text = "Hire"
buttonColumn.UseColumnTextForButtonValue = True
grdApplicantsAS.Columns.Add(buttonColumn)
Dim buttonColumn1 As New DataGridViewButtonColumn()
buttonColumn1.HeaderText = ""
buttonColumn1.Name = "Status Request"
buttonColumn1.Text = "Regrets"
buttonColumn1.UseColumnTextForButtonValue = True
grdApplicantsAS.Columns.Add(buttonColumn1)
myadap.Dispose()
mydt.Dispose()
End Sub
我的数据表的每一行分别具有两个按钮租用和遗憾,我的数据表的一列包含电话号码,我无法弄清楚,如何获得单击按钮租用并将其传递给另一行的同一行的编号表格..非常感谢您的帮助
关注者
0
被浏览
81
1 个回答
-
为此,您可以使用您的
CellClick
事件DataGridView
,请参阅下文。Private Sub grdApplicantsAS_CellClick(sender As Object, e As DataGridViewCellEventArgs) Handles grdApplicantsAS.CellClick Dim frm2 As Form2 Try 'First column button If e.ColumnIndex = 0 Then frm2 = New Form2(grdApplicantsAS.CurrentRow.Cells(YOUR NUMBER COLUMN).Value.ToString()) frm2.ShowDialog() ElseIf e.ColumnIndex = 1 'Do what you need here for the other button... End If Catch ex As Exception End Try End If End Sub
表格2范例
Public Class Form2 Public Property EmployeeName As String 'Pass your name in as the argument. Now Form 2 will have your name... Public Sub New(ByVal strEmployeeName As String) 'Set your property of your employee name EmployeeName = strEmployeeName End Sub End Class
推荐阅读
-
将值从一种形式传递到另一种形式
2021-02-02 关注 0 浏览533 1答案
-
如何根据另一行中的优先级值选择一行?
2021-05-20 关注 0 浏览60 1答案
-
将一种测试方法的输出传递给另一种方法testng
2021-01-30 关注 0 浏览94 1答案
-
使用同一表中另一行的数据更新行
2021-02-02 关注 0 浏览105 1答案
-
SQL:如何从一个表中为另一行中的每一行获取随机的行数
2021-06-04 关注 0 浏览97 1答案
-
sql查询从同一列中获取一行的多个值
2021-05-10 关注 0 浏览129 1答案
-
如何在python中获取一行一行的MySQL ResultSet
2021-02-02 关注 0 浏览93 1答案
-
方法返回值以调用OpenERP中的另一种形式
2021-01-29 关注 0 浏览186 1答案
-
如果另一个数据框中存在同一行,如何删除Pandas数据框中的行?
2021-01-29 关注 0 浏览95 1答案
-
如何在MySQL中使用自动递增字段复制一行并将其插入到同一表中?
2021-02-02 关注 0 浏览94 1答案