I am using nested repeater and i have null values in my database.I want to filter those values, while i display the result.

In my code always it displays null values, and i tries to hide it but there is a space is visible,

So please help me in filtering those null values,

Thanks in advance.

Here is my code:

Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
If Not Page.IsPostBack Then

Dim cmd As New SqlDataAdapter("SELECT * FROM table1;SELECT * FROM table2;", New SqlConnection(ConfigurationManager.AppSettings("ConnectionString")))
Dim ds As New DataSet()
cmd.Fill(ds)
ds.Relations.Add(New DataRelation("nestThem", ds.Tables(0).Columns("esppartno"), ds.Tables(1).Columns("partno")))

espedit.DataSource = ds
espedit.DataBind()
End If
End Sub


Protected Sub espedit_ItemDataBound(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.RepeaterItemEventArgs) Handles espedit.ItemDataBound
Dim dv As DataRowView = TryCast(e.Item.DataItem, DataRowView)
If dv IsNot Nothing Then

Dim isir As Repeater = TryCast(e.Item.FindControl("isir"), Repeater)
If isir IsNot Nothing Then
isir.DataSource = dv.CreateChildView("nestThem")
isir.DataBind()
End If
Dim ppap As Repeater = TryCast(e.Item.FindControl("ppap"), Repeater)
If ppap IsNot Nothing Then
ppap.DataSource = dv.CreateChildView("nestThem")
ppap.DataBind()
End If
End If
End Sub