Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

I have a webpart with SPGridView. I created column dynamic.

This works fine when I have data, but when no rows are returned then I just get a blank spot where the grid should be.

enter image description here

share|improve this question
add comment

2 Answers 2

These 3 members are used to handle EmptyData in the SPGridView.

  1. EmptyDataRowStyle
  2. EmptyDataTemplate
  3. EmptyDataText

Also check out this link for more info

Update 1: If you just want to show the headers even though there are no data, use the ShowHeaderWhenEmpty property.

Update 2: Check the list of properties and members for the SPGridView here.

share|improve this answer
    
Thanks, but i want show header (Example listwebpart). –  ar.gorgin May 3 '12 at 8:07
    
@ar.gorgin Please see my update. –  Daniel Ziga May 3 '12 at 8:16
    
Thanks, i use this property but don't show header –  ar.gorgin May 3 '12 at 8:24
add comment
up vote 0 down vote accepted

It is work for me.

public void BuildNoRecords(GridView gridView, DataSet ds)
{
  try {
   if (ds.Tables(0).Rows.Count == 0) {
   ds.Tables(0).Rows.Add(ds.Tables(0).NewRow());
   gridView.DataSource = ds;
   gridView.DataBind();
   int columnCount = gridView.Rows(0).Cells.Count;
   gridView.Rows(0).Cells.Clear();
   gridView.Rows(0).Cells.Add(new TableCell());
   gridView.Rows(0).Cells(0).ColumnSpan = columnCount;
   gridView.Rows(0).Cells(0).Text = "No Records Found.";
 }
} catch (Exception ex) {
}
share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.