Contact Me

Nirav Prabtani

Mobile : +91 738 308 2188

Email : niravjprabtani@gmail.com

Nirav Prabtani

Wednesday 16 July 2014

Remove empty rows from Dataset


Remove empty rows from Dataset


try this.. Smile | :) 


DataSet ds = new DataSet();
 
                for (int i = 0; i < ds.Tables.Count; i++)
                { 
                      for (int j = 0; j < ds.Tables[i].Rows.Count; j++)
                    {
                        if (Convert.ToString(ds.Tables[i].Rows[j]["ColumnName"]) == string.Empty)
                        {
                            ds.Tables[i].Rows[j].Delete();
                        
                        }
                    }
                
                }

i have created this snippet without testing of it, so modify it according to your need.

No comments :

Post a Comment