I have a dataset that contains several datatables. What I wish to do is search each row in one of the tables and read/copy the value of a column into a variable. I will then manipulate the variable as needed. Specifically, the dataTable is "MembershipDetails" and the column is "MembershipNumber". The dataset is called "myclubDataSet".
The purpose of all this is to determine the next sequential membership number.
If someone could be so good enough to write the code for me I would very much appreciate it because I can't find a simple straightforward example anywhere on the net to learn from.
I know how to do a sql command to do this but I don't want to do it on the database. I wish to achieve it using the dataset.
Thanks in advance.