I'm creating a simple C# ASP.NET app in visual studios and I can’t seem to figure out how to pull values from a single cell when using a table adapter for a SQL database. For example, I have a table adapter named ProductsTableAdapterand I can easily use it to fill a grid view or return rows from the SQL database. However, what if I want to pull a single value from the returned table by a specific column/row?
Does anyone have an example for that syntax?
DataSet1TableAdapters.ProductsTableAdapter productAdapter = new DataSet1TableAdapters.ProductsTableAdapter(); DataSet1.ProductsDataTable products; products = productAdapter.GetProducts(); //Not sure where to go from here if I want to pull a value from a single column and row out of the table