Set query parameter from a cell in a data grid view

29 Views Asked by At

I have a DataGrid view, if I select a certain cell I want to pass the value of a different cell (same row different column) to be used as a parameter in a query function.

GridView

GridView

So in the image sample if I select the highlighted cell then I want to pass the value in the "ITEMNUM" column of the same row. I have a separate Sub that is being called and within that sub I want to set a Parameter equal to the ITEMNUM cell.

I tied something like this in my Private sub but could not figure it out

SQl.AddParam("@Loggb", CrabDetails.dgvCurrentInv.Rows[crabdetails.dvgcurrentinv.CurrentRow.Index].cells[2].Value.ToString())
0

There are 0 best solutions below