Remove empty rows from Dataset
try this..
![Smile | :)](http://www.codeproject.com/script/Forums/Images/smiley_smile.gif)
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.