When I try to remove the row that coming back empty or null it removes all the data for that segment and not just the row.

DataSet myDataSet = new DataSet();DataView myDataView = new DataView();

myDataSet = db.ExecuteDataSet(command);

myDataView = myDataSet.Tables[0].DefaultView;
foreach (DataRow dr in myDataView.Table.Rows)

{
if (dr.IsNull("certifications"))

dr.Delete();

}


return myDataView;

<asp:Repeater ID="Repeater1" runat="server" >

<ItemTemplate>

<table cellpadding="10">

<tr>

<td align="left" width="10%" valign="middle">
<asp:HyperLink ID="Image9" NavigateUrl='<%# DataBinder.Eval(Container.DataItem, "resume_link") %>' ImageUrl='<%# DataBinder.Eval(Container.DataItem, "image_link") %>' runat="server" /></td>

<td align="left" width="100%" valign="middle">

<asp:Label ID="lblformal_name" CssClass="KPMainTeam" runat="server" Text='<%# DataBinder.Eval(Container.DataItem, "formal_name") %>'></asp:Label><br />

<asp:Label ID="lblcertifications" CssClass="KPMainTeam" runat="server" Text='<%# DataBinder.Eval(Container.DataItem, "certifications") %>'></asp:Label><br />

<asp:Label ID="lbltiltle" CssClass="KPMainTeam" runat="server" Text='<%# DataBinder.Eval(Container.DataItem, "title") %>'></asp:Label></td>

</tr>

</table>

</ItemTemplate>

</asp:Repeater>

Hi Wily....

What do you mean it removes the segment? What segment are you referring to?

__________________
The OXYGEN
Delivers edgy, intelligent Technology to all...

DataSet myDataSet = new DataSet();
DataView myDataView;
myDataSet = db.ExecuteDataSet(command);

myDataView = myDataSet.Tables[0].DefaultView;

//apply a row filter
myDataView.RowFilter = "not (certifications is null)";