How to remove null data from the List of objects in C#

Asked Sep 20 '18 at 12:38

Active Sep 20 '18 at 12:38

Viewed 96 times

I have a SQL stored procedure which returns below data:

Id  data
1   {test12,sahjfh}
2   {test3,asfdssd}
3   null
4   null
5   {test454,aslkdfs}

i am trying to remove all the null value data , by using below code however its not working

public void TestMethod(){
// get the data from DB in list
            var InputList = new List<object>();
            using (SqlConnection con = new SqlConnection(conString))
            {
                using (SqlCommand cmd = new SqlCommand())
                {

                    cmd.CommandType = System.Data.CommandType.StoredProcedure;
                    cmd.CommandText = "dbo.ReadAll_Input";

                    con.Open();

                    using (SqlDataReader dr = cmd.ExecuteReader())
                    {
                        while (dr.Read())
                        {
                            InputList.Add(dr["data"]);
                        }
                    }
                }
            }
            InputList.RemoveAll(data => data == null);


}

Any hints on this?

Thanks!

asked Sep 20 '18 at 12:38

TechnoSavvy

You need to check for `DBNull`, not `null`. – juharr Sep 20 '18 at 12:40
4

Can you not add "is not null" to the stored procedures where-clause? Best to do this kind of filtering in the database. – Esko Sep 20 '18 at 12:41
@Esko , unfortunatly thats not the option we have as its external data. – TechnoSavvy Sep 20 '18 at 12:43
Check the Value .length() >0 before adding it in the List. – SH7 Sep 20 '18 at 12:44
its working with comparing the value with DBNULL.value as `InputList.RemoveAll(data => data == DBNull.value); ` – TechnoSavvy Sep 20 '18 at 15:27

How to remove null data from the List of objects in C#

0 Answers0