Validation Advice Please.....

Katie B

I've written a SQL statement that will check the class capacity (as below):
myOleDbCommand.CommandText = "SELECT Capacity FROM Classes WHERE ModuleID = " + lstModCode.SelectedItem + " ";

But is there a way to use the data its pulled as capacity, to link it to an if statement.
E.g if (capacity > 25)
{

Messagebox.Show(Insert message here)

}

Or would the data its pulling back need to be stored somewhere?

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

Riddhi Valecha13y ago
Hi...

I did not get you.

What exactly your requirement is?? Please elaborate...
Javeed M Shaikh13y ago
this would give you data of classes only which are full (capacity > 25), if you want to process all the records and somewhere you want to draw in the UI full and empty classes then you would need to iterate through the datareader for the select in your initial question, not sure if this is what you need.
Katie B13y ago
Would I be able to run an if statement on that data as well to show which classes are > 25 and are therefore full?
Javeed M Shaikh13y ago
i meant in your select statement, since you already have capacity in your database table:

the following will give you data only where capacity is > 25 and then you can work on this dataset.
SELECT Capacity FROM Classes WHERE ModuleID = " + lstModCode.SelectedItem + " and Capcity > 25";
Katie B13y ago
So when you say restricting the data, you mean on input?? Could I put a count on when the user is accepted onto the course it adds 1 to the number of students in the table?
Javeed M Shaikh13y ago
You can either pull all the class capacity data for a module and compare in your code for the capacity limit of 25 or better way just restrict the data in your query to capacity > 25 and then when the reader comes back if will only have the data you want to play with. You can then loop through this data and write your insert statement accordingly.