ASP.NET

20-Apr-07 2:44

Thanks and Regards
Sandeep

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

Show Empty GridView

varshavmane20-Apr-07 1:36

20-Apr-07 1:36

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...

Arun.Immanuel20-Apr-07 2:13

Arun.Immanuel

20-Apr-07 2:13

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

varshavmane20-Apr-07 2:48

20-Apr-07 2:48

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...

Arun.Immanuel20-Apr-07 3:12

Arun.Immanuel

20-Apr-07 3:12

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

kubben20-Apr-07 2:49

kubben

20-Apr-07 2:49

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

varshavmane20-Apr-07 2:55

20-Apr-07 2:55

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...

kubben20-Apr-07 2:58

kubben

20-Apr-07 2:58

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

varshavmane20-Apr-07 3:04

20-Apr-07 3:04

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>

kubben20-Apr-07 3:12

kubben

20-Apr-07 3:12

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

Arun.Immanuel20-Apr-07 3:19

Arun.Immanuel

20-Apr-07 3:19

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

varshavmane20-Apr-07 3:27

Re: Show Empty GridView [modified]

20-Apr-07 3:27

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

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

Thanks again...

Chetan Ranpariya22-Apr-07 21:29

Chetan Ranpariya

22-Apr-07 21:29

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

Dataset's

Sam Heller20-Apr-07 1:24

Sam Heller

20-Apr-07 1:24

 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??

Re: Dataset's

Sandeep Akhare20-Apr-07 1:56

20-Apr-07 1:56

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!

Re: Dataset's

Sam Heller20-Apr-07 2:10

Sam Heller

20-Apr-07 2:10

Thanks that works great.

I only really needed this though

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

Page timing out?

markymark8220-Apr-07 0:51

markymark82

20-Apr-07 0:51

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

Re: Page timing out?

Sandeep Akhare20-Apr-07 1:14

how to unchecked the radio button by checked the other radio button?

20-Apr-07 1:14

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!

sathyan_829420-Apr-07 0:51

sathyan_8294

20-Apr-07 0:51

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

Re: how to unchecked the radio button by checked the other radio button?

Sandeep Akhare20-Apr-07 1:06