Check for empty db column value and return results - c# asp.net

I got a great response the last time I posted here.

I have the following table structure in my database for a small Gallery page on my site.

id | title | img1 | img1sml | img2 | img2sml | img3 | img3sml

Now, id and title are manda开发者_如何学Ctory, however the rest are not.

I'd like to loop through all my sml columns that have values in them and create <img src="--column value here--" /> for each of them.

I'd also like to do the same with my img columns - loop through any non-empty columns and list them

Can someone show me how I can do this?

Many thanks for any help with this

You can check NULL as follows

if(!YourObject.Equals(System.DBNull.Value))

You can do it get Not Null Rows and then iterate those rows.

DataRow[] dr = dtbl.Select("img1 is Not Null");
 foreach (DataRow dr in dataRows)
 {

 }