[Solved] hide RadImageGallery if Datasource is empty

[moegal]

How do I hide the control if the SqlDataSource does not have any records?

I tried to get the items.count but it does not seem to work in PreRender or DataBound.

Marty

[Princy]

Hi moegal,

Please try the following C# code snippet which works fine at my end.

C#:

protected void RadImageGallery1_DataBound(object sender, EventArgs e)
{
    SqlConnection connection= new SqlConnection(ConfigurationManager.ConnectionStrings["NorthwindConnectionString"].ConnectionString);
    connection.Open();
    SqlCommand cmd = new SqlCommand("SELECT COUNT(*) FROM Images", cn);
    Int32 count = (Int32)cmd.ExecuteScalar();
    if (count == 0)
        RadImageGallery1.Visible = false;
    connection.close();
}

Thanks,
Princy.

[moegal]

Princy,

Thanks.  I was hoping I could get the count directly from the control so I did not have to make a second call to the database.

Marty

[Marin Bratanov]

Hi Marty,

You can databind the control manually - perform a Select() to see what the result is: http://msdn.microsoft.com/en-us/library/system.web.ui.webcontrols.sqldatasource.select(v=vs.110).aspx. If there is data - set the collection you have to the DataSource property and call the DataBind() method. Otherwise, set the Visible property to false.

You can also use the Selecting SqlDataSource event to see this information, as discussed in numerous placed in the net, e.g.: http://stackoverflow.com/questions/2231273/how-do-i-check-that-a-sqldatasource-returned-data.


Regards,

Marin Bratanov
Telerik