Re: Show Empty GridView - ASP.NET Discussion Boards

Hi All,

I need to show empty GirdView, I mean when dataset is empty girdview should show only column with no rows.

Please help me...

Thanks in advance...

I am not sure of the right method.

But U can try this.

Using System.Collections;

if (grid.Rows.Count==0)
{
ArrayList arr=new ArrayList ();
arr.add("");
arr.add("");
arr.add("");
//and so on(now 3 empty rows will be displayed).

grid.DataSource=arr;
grdi.DataBind();
}

Hope this helps U.

Regards,
Arun Kumar.A

Thanks Arun,

But its not working. Its gives run time error saying

DataBinding: 'System.String' does not contain a property with the name 'LoanPayOffID'.

Where LoanPayOffID is primary Key.

Please help...

Try Using this..
if (ds.Tables[0].Rows.Count == 0)
{
ds.Tables[0].Rows.Add("", ""); //Add empty string that corresponds to the number of columns
grdOrders.DataSource = ds.Tables[0];
grdOrders.DataBind();
grdOrders.Rows[0].Visible = false;
}

Regards,
Arun Kumar.A

The gridview has an emptydatarowtext that you can use to display some text or you can use the emptydatarowtemplate to display some html.

Hope that helps.
Ben

Thanks Kubben,

I need to display empty Gridview, I dont want to display a text message saying to record present.I want if dataset has no rows then Girdview should display with only column names.

Please help...

Thanks again...

That is what you can use the emptygridviewtemplate for. I suggest running you app when you have data in the gridview. Go to the browser view - source, copy the html code. Paste it into a emptygridviewtemplate. Remove the data, just leave the header. You should be all set.

Ben

Where do I put emptygridviewtemplate, this is my gridview and when I fire my query it reurns dataset which has no rows.

Tell me how do I do this...

<asp:GridView ID="GridViewLoanPayOff" runat="server" AutoGenerateColumns="False" Width="1200px" HorizontalAlign="left">
<RowStyle CssClass="GridRowColor" />
<AlternatingRowStyle CssClass="GridAlternateRowColor" />
<Columns>
<asp:BoundField DataField="LoanPayOffID" Visible="False"/>
<asp:BoundField DataField="BankName" HeaderText="Bank Name" HeaderStyle-CssClass="heading">
<ItemStyle Width="150px" />
<HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Width="200px" />
</asp:BoundField>
<asp:BoundField DataField="BranchLocation" HeaderText="Branch Location" HeaderStyle-CssClass="heading">
<HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Width="160px" />
</asp:BoundField>
<asp:BoundField DataField="PhoneNo" HeaderText="Phone #" HeaderStyle-CssClass="heading">
<HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Width="220px" />
</asp:BoundField>
<asp:BoundField DataField="FaxNo" HeaderText="Fax #" HeaderStyle-CssClass="heading">
<HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Width="80px" />
</asp:BoundField>
<asp:BoundField DataField="ETA" HeaderText="ETA" HeaderStyle-CssClass="heading">
<HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Width="80px" />
</asp:BoundField>
<asp:BoundField DataField="BorrowerAutherization" HeaderText="BA" HeaderStyle-CssClass="heading">
<HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Width="80px" />
</asp:BoundField>
<asp:BoundField DataField="OfficeTime" HeaderText="Office Hours " HeaderStyle-CssClass="heading">
<HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Width="250px" />
</asp:BoundField>
<asp:BoundField DataField="WorkingDays" HeaderText="Working Days" HeaderStyle-CssClass="heading">
<HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Width="130px" />
</asp:BoundField>
<asp:BoundField DataField="IsAutomatedSystem" HeaderText="IVR/Automated" HeaderStyle-CssClass="heading">
<HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Width="120px" />
</asp:BoundField>
<asp:BoundField DataField="Remarks" HeaderText="Remarks" HeaderStyle-CssClass="heading">
<HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Width="90px" />
</asp:BoundField>
<asp:TemplateField HeaderText="Edit" HeaderStyle-CssClass="heading">
<ItemStyle HorizontalAlign="Center" VerticalAlign="Middle" />
<ItemTemplate>
<asp:ImageButton Runat="server" ID="Edit" ImageAlign=Middle CommandName="Edit" ToolTip="Edit" CssClass="cursor" ImageUrl="../images/edit.jpg"></asp:ImageButton>
</ItemTemplate>
<HeaderStyle HorizontalAlign="Center" Width="50px" />
</asp:TemplateField>
<asp:TemplateField HeaderText="Delete" HeaderStyle-CssClass="heading">
<ItemStyle HorizontalAlign="Center" VerticalAlign="Middle" />
<ItemTemplate>
<asp:ImageButton Runat="server" ID="Delete" CommandName="DeleteTrans" ToolTip="Delete" CssClass="cursor" ImageUrl="../Images/delete.gif">
</asp:ImageButton>
</ItemTemplate>
<HeaderStyle Width="60px" />
</asp:TemplateField>
</Columns>
</asp:GridView>

I guess I gave you the wrong name. It is emptydataTemplate. It goes in the gridview. Here is a link:
<a href="http://msdn2.microsoft.com/en-us/library/system.web.ui.webcontrols.gridview.emptydatatemplate.aspx">http://msdn2.microsoft.com/en-us/library/system.web.ui.webcontrols.gridview.emptydatatemplate.aspx</a>[<a href="http://msdn2.microsoft.com/en-us/library/system.web.ui.webcontrols.gridview.emptydatatemplate.aspx" target="_blank" title="New Window">^</a>]

The basics are:
right before the </asp:GridView> tag you need
<EmptyDataTemplate>
put your html here
</EmptyDataTemplate>
</asp:GridView>

Hope that helps.
Ben

He is asking what to write in the place where U have written

"put your html here".

Please run the application in such a way that the grid shows data.

Open the Page source from IE or FF.

Locate the tag
<Table>

and copy the first row with tr and th tags.

Paste them in that place.

Arun Kumar.A

Thanks Kubben, its working now I took help form the following link:

http://www.codeproject.com/useritems/Fix_empty_GridView_issue.asp

Thanks again...

hi,

Your query should be like that no data should be returned from the database.

-- modified at 4:25 Monday 23rd April, 2007

Thanks and Regards,
Chetan Ranpariya

 Dim Data As DropDownComboData = New DropDownComboData<br />
<br />
            ' use following codes to retrieve data when data request is invoked from client.<br />
            Dim TopRows As Int32 = e.StartRow + e.RowCount<br />
<br />
            Dim ds As DataSet = Data.Bank_Lookup(e.QueryText, TopRows)<br />
<br />
            e.DataSource = ds

I have the following code which creates a DataSet using the arguments passed to it from a control's event. The code works fine but as a requirement of the control it also requires a Count passed to it. Originally I created a new stored procedure to get this but it would make more sense to pass this back with the resultset. This would mean one stored procedure to do it all. I have created the SP and it returns a resultset and now a second resultset which just includes the scalar count value.

What is the syntax to get this single value? Something like

<br />
Count =  ds.Tables(1).Rows(0)

Is that correct??

i think this code might help you

<br />
object[] itemsInOneRow=ds.Tables[0].Rows[0].ItemArray;<br />

now again iterate through the itemsInOneRow it will give what you want Smile | :)

Thanks and Regards
Sandeep

If you want something you never had,
do something you have never done!

Thanks that works great.

I only really needed this though

Dim ThanksfortheHelp As Integer = ds.Tables[0].Rows[0].ItemArray(0)

hi,

I am running a complicated page which is looping through all of the folders beneath a specified folder, then looping through all of the files within each folder. Then for each file, I am doing a check on the name (Format, length etc.) then if it is correct moving it to a different drive on a different server, creating the relevant folders to house the files, and again with the incorrect files. This all works fine but after exactly 1 hour, the page seems to time out and displays the "This page could not be found" error page.

I am assuming it is a timeout as it is always after an hour.

I have changed the httpRequest executionTimeout to be over 3 hours (as that's what i expect it to be at least, due to the No. of gigs being shifted by the app!).
The session state timeout is 480 Mins so that isn't the problem and everythings being done with server-side script (c#) so it shouldn't be client-side script timeout.

does anyone have any suggestions?

thank you

You need to check Trace of the aaplication that will give where is the error or problem you are facing do one thing
1) make a change in the web.config by modifying Trace Enable=true.
2) type the URL of your application then type trace.axd at the last it will give detail of your application

Thanks and Regards
Sandeep

If you want something you never had,
do something you have never done!

i have 2 radio button,if i checked the one radio button means other radio button also automatically checked.how to clear this.

Give same Group name to both the radio buttons
radio button means only one can get selected among all same group buttons

Thanks and Regards
Sandeep

If you want something you never had,
do something you have never done!

In asp.net2,
AJAX is not working for dropdownlist_selecteditemIndex event in IE.
It is working fine in Mozilla firefox.

-- modified at 6:35 Friday 20th April, 2007

What do you mean by 'AJAX is not working' ??? There is no AJAX built into ASP.NET 2005, by default. Are you using ATLAS, or have you written your own AJAX code ? If your own code, have you written it so it can work with both ( the code is different )

Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

I m using following for dropdownlist:

<asp:UpdatePanel runat="server" ID="YourUpdatePanel">
<ContentTemplate>

Here is code for dropdownlist.....

</ContentTemplate>
</asp:UpdatePanel>

<asp:UpdatePanel runat="server" ID="YourUpdatePanel">
<ContentTemplate>

Here is code for dropdownlist.....

</ContentTemplate>
</asp:UpdatePanel>

You need to check 'ignore HTML tags' for this to be visible.

OK, so you're using ATLAS. What is happening in IE ? Is your page making it's AJAX call ? Is anything being rendered ?

I don't use ATLAS, so odds are, I can't offer much help.

Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

when i selects item in country dropdownlist.Its giving me javascript error as follows:
'event' is null or not an object.

Can we see the code for the whole thing. Dropdown list, update panel and dropdown event code?