I'm using Visual Studio 2010 and I'm working on a windows application form. I'm struggling with our database. I can connect and retrieve Data in the Grid View.
But I don't want to display the records – I want to put a specific row column in a variable (in short I want to work with it).
My DataSet
is called ProductionDataSet
. The Table
is called Employee
and has four columns called Employee
, First_Name
, Last_Name
and Status
.
How do I now store lets say the entry in column 4 and row 5 in the variable x?
Best Answer
After you connect to the databse you need to put the data into a DataTable and then manipulate the Row Items