G
gwboolean
Guest
I have been having problems with getting an electronic signature into a column in a table. It took me awhile, but I finally goterdone. However, now that the signature is actually there, I am unable to get it to display in the DGV on the form.
I have checked to make sure that I haven't set the cell forecolor/backcolor properties such that the value is not visible, and am pretty sure I have managed not to do that yet again.
Anyway, here is the process and the code that is supposed to make it all happen.
So in this first screen a user has logged on and has opened a DGV to see if there are any records that require signature. The user would click the Review CRs button and a query is run to show all records that this user has not yet signed.
The User then will see all records that require their signature. The user then would select one of the records by double clicking in the row of the record of interest.
A Windows Explorer is opened (not shown since everyone has seen millions of them) to the directory that is associated with the selected record. Behind that is the DGV form below. At this point the DGV.Enabled = False.
The user would then Click the Sign CRs button and that will enable the DGV and the user can then input their electronic signature, which is accomplished by double clicking in the displayed row.
At the point where the user double clicks to insert their electronic Signature the following code is executed
Dim Signature As String = CType(_strEmployeeName & " " & CStr(Date.Now), String)
dgvListTable.Rows(0).Item(6) = Signature
lblRecords.Text = dgvListTable.Rows.Count.ToString 'Record count
dgvListManager = DirectCast(BindingContext(dgvListTable), CurrencyManager)
dgvListManager.EndCurrentEdit()
dgvListAdapter.Update(dgvListTable)
At this point the Signature is inserted into the record and it is saved, which does occur. However, the signature does not show up in the DGV on the screen. I have done everything I can think of, so far, and none of them work, including the most far fetched ideas I often try.
So how do I make the signature show up?
gwboolean
Continue reading...
I have checked to make sure that I haven't set the cell forecolor/backcolor properties such that the value is not visible, and am pretty sure I have managed not to do that yet again.
Anyway, here is the process and the code that is supposed to make it all happen.
So in this first screen a user has logged on and has opened a DGV to see if there are any records that require signature. The user would click the Review CRs button and a query is run to show all records that this user has not yet signed.
The User then will see all records that require their signature. The user then would select one of the records by double clicking in the row of the record of interest.
A Windows Explorer is opened (not shown since everyone has seen millions of them) to the directory that is associated with the selected record. Behind that is the DGV form below. At this point the DGV.Enabled = False.
The user would then Click the Sign CRs button and that will enable the DGV and the user can then input their electronic signature, which is accomplished by double clicking in the displayed row.
At the point where the user double clicks to insert their electronic Signature the following code is executed
Dim Signature As String = CType(_strEmployeeName & " " & CStr(Date.Now), String)
dgvListTable.Rows(0).Item(6) = Signature
lblRecords.Text = dgvListTable.Rows.Count.ToString 'Record count
dgvListManager = DirectCast(BindingContext(dgvListTable), CurrencyManager)
dgvListManager.EndCurrentEdit()
dgvListAdapter.Update(dgvListTable)
At this point the Signature is inserted into the record and it is saved, which does occur. However, the signature does not show up in the DGV on the screen. I have done everything I can think of, so far, and none of them work, including the most far fetched ideas I often try.
So how do I make the signature show up?
gwboolean
Continue reading...