how to show gridview with out data

[findtango]

I'm returning a dataset to a gridview control. When the gridview asp.net control is populated from the returning dataset, if dataset is empty. The cells that are empty, in the gridview control, I would like to have the value of 0 (zero) inserted. So if no data is returned to that cell a 0 (zero) is shown.

[N a v a n e e t h]

First check the dataset is empty. If it is then add rows manually for the datatables. and bind that to the grid view.

[manojch2]

Try This Protected Sub ItemDB(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.DataGridItemEventArgs) Dim dv As DataView = CType(DataGrid1.DataSource, DataView) Dim drv As DataRowView = CType(e.Item.DataItem, DataRowView) If dv.Table.Rows.Count = 0 Then 'By default the Datagrid Header is shown in case there is no Data Avaiable 'So in case of No Data found 'Check the ListItemType.Header If e.Item.ItemType = ListItemType.Header Then Dim i As Integer = e.Item.Cells.Count 'Assign "No Search result Found" in one of the cells of DataGrid e.Item.Cells(0).Text = "No Search Results Found" 'Remove Rest of the empty cells from Datagrid Dim j As Integer For j = i - 1 To 1 Step -1 e.Item.Cells.RemoveAt(j) Next End If End If End Sub '

manojchilhate