Change the Empty cell in gridview to something else

Question

Hi Guys I have a Gridview which has some empty cells I want to change the text of those cells to something else like 'no data found' or anything. How do i do it

vishal sahani · Answer

Thnx suthish I've tried row databound event but as you know the page renders the empty cells in gridview as &nbsp if the grid has auto generated columns, ive tried to check the cell's value to null,string.empty,&nbsp etc.but not working.can paste the code for the rowdatabound event that you are tryn to suggest

Suthish Nair · Answer

using RowDataBound event of GridView

Prabhu Raja · Answer

You may include following EmptyDataTemplate> tag in your Source. No Data Found. Add Above to your GridView as No Data Found. -------------------------------------------------------------- If this helps you, then mark as "Correct Answer" Thank You

vishal sahani · Answer

Thnx for the reply, I know how to change it if i have a control but i want to know if it is possible to change it with out usng a template field ie with the autogenerated columns

Hemant Kumar · Answer

First you need to wrap your code in a Label or Literal control so that you can reference it properly. What's happening is that there's no way for the system to keep track of it, because there's no control associated with the text. It's the control's responsibility to add its contents to viewstate. You need to use gridView.FindControl("controlName"); to get the control in the row. From there you can get at its properties including Text . You can also get at the DataItem property of the Row in question and cast it to the appropriate type and extract the information directly. if(lblCellText.Text==String.Empty) { //Do Something } else { //Do Something }

Change the Empty cell in gridview to something else

Answers (5)