C# check record set for null values
Posted on 2013-01-10
I have a form in ASP.Net (C# code behind, SQL Server 2005 database) that users use to enter data. Once done, they click a button to submit it to the next department. In this instance, when they click submit I would like to check and make sure that certain fields in a details forms are filled out. The details forms can have 1 or more records. Each of those records has required fields. When the submit button is clicked, I think I need to run a sql command to check the recordset fields for null values. If a field is null, the form does not get submitted and a message pops for the user notifying them. I also think it will take a for each loop to look through each record. Is there an example of this somewhere, or am I even on the right track? Thanks.