How to handle null value during convert a column into a string array

Question

I have a problem when i try to convert a column to a string array.

here is my code:

string[] s = Array.ConvertAll<DataRow, string>(datatable.Select(), delegate(DataRow row) {return(string)row["columnname"];});

error is: in the datacolumn, there is null , empty and 'none' value.

i want to my s contains only the entity not including null, empty, 'none' value.

Any help will be appreciate!

Mamta M · Answer

you can try this: string[] s = Array.ConvertAll (this.northwindDataSet.Orders.Select() delegate(DataRow row) { if (row[columname].GetType().ToString() != System.DBNull) return (string)row[columname]; else return ; });

Michael Xie · Answer

Thank you very much. I did in another way: foreach (string s in arrs1) { if (s == null || s.Length == 0) { continue; } else if(!arrs2.Contains(s)) { arrs2.Add(s); } } thanks for your help so:)