You searched for the word(s): userid:878863

More Search Options

RSS Available

• <EmptyDataTemplate> Not Displaying When No Records

  Hi All, Throughout our web site, we use GridViews with the EmptyDataTemplate and it works fine, however, we have one stubborn page where it does not work. Here is the code: ASPX Page: <asp:GridView ID="GridViewNewMembers" runat="server" HorizontalAlign="Center" Width="1100px" AutoGenerateColumns="False" Style="margin-bottom: 20px;"> <EmptyDataTemplate> No Data! </EmptyDataTemplate> <Columns> VB Code Behind: Protected

  Posted to Data Presentation Controls (Forum) by mwheeler on 12/2/2009

• Re: <EmptyDataTemplate> Not Displaying When No Records

  Actually, I had all ready done that, but as it wasn't working, I simply reduced it the code to display but it still doesn't work. Here is the actual code for the template: <EmptyDataTemplate> <asp:Table runat="server" ID="TableNoSubscriptions" Width="1100px" CssClass="Table"> <asp:TableRow runat="server" CssClass="GreyRow"> <asp:TableCell runat="server" Text="Pilot ID" Font-Bold="True"

  Posted to Data Presentation Controls (Forum) by mwheeler on 12/2/2009

• Re: <EmptyDataTemplate> Not Displaying When No Records

  This is very strange as I have the same code as you do, but nothing appears. I don't get it. This should work.

  Posted to Data Presentation Controls (Forum) by mwheeler on 12/2/2009

• Re: <EmptyDataTemplate> Not Displaying When No Records

  I finally found the problem and it has nothing to do with the EmptyDataTemplate. I had a GridView_RowDataBound Sub where I was hiding to columns that was preventing the EmptyDataTemplate from working: Protected Sub GridViewNewMembers_RowDataBound(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewRowEventArgs) Handles GridViewNewMembers.RowDataBound If e.Row.RowType = DataControlRowType.DataRow Then 'Combine first name and last name into stringFIRSTNAME column. If e.Row.RowType

  Posted to Data Presentation Controls (Forum) by mwheeler on 12/2/2009

• Re: Case on a Join Help required

  Thanks for your feedback. The issue with the above suggestions is that the script filters out all records where there is no activity yet in the REPORTS table. What the script nees to do is to update a datagrid for each integerPILOTID with integerTOTALFLIGHTS, integerTOTALHOURS, TOTALDISTANCE, etc. I need all records to be displayed regardless if there is activity in the REPORTS table for that integerPILOTID, but I need to filter out records where integerPILOTID IS NULL, so that those values will

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by mwheeler on 10/30/2009

• TOP 1 On Distinct Count

  Hi All, I have the following SQL statement that returns a list of Origins as well as the number times they were used. How would I format my script t only return the TOP 1 record. SELECT DISTINCT COUNT (stringORIGINID) AS stringFLIGHTS, stringORIGINID FROM REPORTS GROUP BY stringORIGINID ORDER BY stringFLIGHTS DESC I have googled this on to death and have not found anything that seems to work.

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by mwheeler on 10/30/2009
  Filed under: SQL 2008, distinct, TOP 1

• Re: TOP 1 On Distinct Count

  Hi Limno, I seem to recall that you have helped me before and once again you have helped me out. Kind regards,

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by mwheeler on 10/30/2009

• Re: Case on a Join Help required

  SELECT REPORTS.integerPILOTID,COUNT(*) AS integerFLIGHTS, PILOTS.autoPILOTID, PILOTS.stringPILOTID, PILOTS.stringFIRSTNAME, PILOTS.stringLASTNAME, PILOTS.stringCITY, PILOTS.stringCOUNTRY, PILOTS.stringSTATUS, (integerFLIGHTHOURS + integerCHALLENGEHOURS + integerCONTESTHOURS) as 'integerTOTALHOURS', SUM(REPORTS.integerDISTANCE) AS integerDISTANCE, SUM(REPORTS.integerPAX) AS integerPAX FROM PILOTS FULL JOIN REPORTS ON (autoPILOTID = integerPilotID) WHERE booleanSUSPENDED = 'False' and

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by mwheeler on 10/29/2009

• Case on a Join Help required

  Hi all, I have the following SQL script that returns all the values I require, except that I need to omit R EPORTS . integerPILOTID , COUNT (*) AS integerFLIGHTS when REPORTS.integerPILOTID IS NULL. SELECT REPORTS.integerPILOTID,COUNT(*) AS integerFLIGHTS, PILOTS.autoPILOTID, PILOTS.stringPILOTID, PILOTS.stringFIRSTNAME, PILOTS.stringLASTNAME, PILOTS.stringCITY, PILOTS.stringCOUNTRY, PILOTS.stringSTATUS, (integerFLIGHTHOURS + integerCHALLENGEHOURS + integerCONTESTHOURS) as 'integerTOTALHOURS'

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by mwheeler on 10/28/2009

• Re: ASP.NET 2.0 & SQL 2008 Connections

  Yeah I did look into that, but as I have never really played with those, and I know that just creating an instance on each page will work, I am going to go with the safe bet on this one. I have made all the changes and all seems to be working fine. Thanks for your help.

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by mwheeler on 10/25/2009