Validation Advice Please.....

Question

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?

Riddhi Valecha · Answer

Hi... I did not get you. What exactly your requirement is?? Please elaborate...

Javeed M Shaikh · Answer

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 B · Answer

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 Shaikh · Answer

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 B · Answer

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 Shaikh · Answer

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.