Urgent! VB.NET -- Need to execute a TableAdapter query using a DataGridView column value!
Posted on 2013-01-11
I have a TableAdapter which is filled with multiple queries.
I want to use a DataGridViewCell value as a parameter in a TableAdapter query
My current code throws an exception because the DataGridViewCell value is returning as dbNull even though it has a value.
Here is the current code which is taken from a Form KeyUp event:
Select Case e.KeyCode
Dim columnValue As String = DataGridView1.Currentcell.Value.ToString()
' Me.Table1TableAdapter.FillByQuery1(Me.Dataset1.Table1, columnvalue)
Catch ex As Exception
Thanks for your help!