Remove duplicate items from Gridview - ASP.NET

westdh
westdh used Ask the Experts™
on
I need a way to remove duplicate row in more than one column like columns 2 & 3
48  1/28/2010  Breakfast of Champions - Franciscos Restaurant near Oakland Airport  CALTROP Corporation  landerson@CALTROP.com  25.00  agw  1/18/2010  
56  1/28/2010  Breakfast of Champions - Franciscos Restaurant near Oakland Airport  Russell A Moore  jmramoore@yahoo.com  25.00  agw  1/20/2010  
59  1/28/2010  Breakfast of Champions - Franciscos Restaurant near Oakland Airport  S&C Engineers  andy_kleiber@scengineers.com  25.00  agw  1/21/2010  
62  1/28/2010  Breakfast of Champions - Franciscos Restaurant near Oakland Airport  KELLCO  mailbox3137@kellcomacs.com  25.00  cmp  1/21/2010  
83  1/28/2010  Breakfast of Champions - Franciscos Restaurant near Oakland Airport  Susan Farrell  Dina.Potter@jacobs.com  25.00  agw  1/22/2010  
84  1/28/2010  Breakfast of Champions - Franciscos Restaurant near Oakland Airport  Mabel Cater  mcater@mcguireandhester.com  25.00  agw  1/22/2010  
85  1/28/2010  Breakfast of Champions - Franciscos Restaurant near Oakland Airport  Arrow Acoustics Inc  dave@arrowacoustics.com  25.00  agw  1/22/2010  
87  1/28/2010  Breakfast of Champions - Franciscos Restaurant near Oakland Airport  Mabel Cater  mcater@mcguireandhester.com  25.00  cmp  1/22/2010  
88  1/28/2010  Breakfast of Champions - Franciscos Restaurant near Oakland Airport  Eli Naor  denise@vbnarch.com  25.00  agw  1/25/2010  
89  1/28/2010  Breakfast of Champions - Franciscos Restaurant near Oakland Airport  Summit Associates  ken.rice@summticm.com  25.00  agw  1/25/2010


My code
========================  


<%@ Page Language="VB" Debug="false" AutoEventWireup="false" CodeFile="EventSummaryRpt.aspx.vb" Inherits="wwwroot_EventSummaryRpt" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html id="HTML1" runat="Server">
<head id="Head1" runat="Server">

<script runat="server">
    Dim TotalUnitPrice As Decimal = 0.0
    Function GetUnitPrice(ByVal fltOrderAmount As Decimal) As Decimal
        TotalUnitPrice += fltOrderAmount
        Return fltOrderAmount
    End Function
    Function GetTotal() As Decimal
        Return TotalUnitPrice
    End Function
</script>
    </head>
<div align="center">  
<body id="Body1" runat="server">
<table align="center">
<tr><td align="center"><strong><font size="4">BOC Breakfast of Champions Registration PayPal Summary Report</font></strong></td></tr>
<tr><td align="center"><font size="1">Print Instructions: Print in preview mode - Set to Landscape - Set Shrink Page to 85% - Click on Print preview.</font>
</td></tr>

<tr><td>
<form id="form1" runat="server">
<br />
Select Event Name:
<asp:DropDownList ID="DroplistData" runat="server" Width="440px"  AutoPostBack="True" OnSelectedIndexChanged="DroplistData_SelectedIndexChanged">
<asp:ListItem> </asp:ListItem>
</asp:DropDownList>
<br /><br />
&nbsp;&nbsp;Select Month:
<asp:DropDownList ID="ddlMth" runat="server" AutoPostBack="true" OnSelectedIndexChanged="ddlMth_SelectedIndexChanged">
<asp:ListItem></asp:ListItem>
<asp:ListItem Value="1">Jan</asp:ListItem>
<asp:ListItem Value="2">Feb</asp:ListItem>
<asp:ListItem Value="3">Mar</asp:ListItem>
<asp:ListItem Value="4">Apr</asp:ListItem>
<asp:ListItem Value="5">May</asp:ListItem>
<asp:ListItem Value="6">Jun</asp:ListItem>
<asp:ListItem Value="7">Jul</asp:ListItem>
<asp:ListItem Value="8">Aug</asp:ListItem>
<asp:ListItem Value="9">Sep</asp:ListItem>
<asp:ListItem Value="10">Oct</asp:ListItem>
<asp:ListItem Value="11">Nov</asp:ListItem>
<asp:ListItem Value="12">Dec</asp:ListItem>
</asp:DropDownList>

Select Year:
<asp:DropDownList ID="ddlYear" runat="server" AutoPostBack="true" OnSelectedIndexChanged="ddlYear_SelectedIndexChanged">
<asp:ListItem></asp:ListItem>
<asp:ListItem Value="2010">2010</asp:ListItem>
<asp:ListItem Value="2011">2011</asp:ListItem>
<asp:ListItem Value="2012">2012</asp:ListItem>
<asp:ListItem Value="2013">2013</asp:ListItem>
<asp:ListItem Value="2014">2014</asp:ListItem>
<asp:ListItem Value="2015">2015</asp:ListItem>
<asp:ListItem Value="2016">2016</asp:ListItem>
<asp:ListItem Value="2017">2017</asp:ListItem>
<asp:ListItem Value="2018">2018</asp:ListItem>
<asp:ListItem Value="2019">2019</asp:ListItem>
<asp:ListItem Value="2020">2020</asp:ListItem>
<asp:ListItem Value="2021">2021</asp:ListItem>
<asp:ListItem Value="2022">2022</asp:ListItem>
<asp:ListItem Value="2023">2023</asp:ListItem>
<asp:ListItem Value="2024">2024</asp:ListItem>
<asp:ListItem Value="2025">2025</asp:ListItem>
</asp:DropDownList>
&nbsp;If you select a new event; reset the year.
<br />
<br />
  <asp:GridView ID="uxItemDetailGrid" runat="server" ShowFooter="true" AutoGenerateColumns="false"  HorizontalAlign="center" HeaderStyle-Height="40" CellPadding="2"  BorderColor="#A1C1D9"  GridLines="Both" RowStyle-Font-Size="8" width="900"
uxItemDetailGrid_RowDataBound>
        <HeaderStyle backcolor="#5D7B9D" font-bold="True" forecolor="White" /><FooterStyle backcolor="#5D7B9D" font-bold="True" forecolor="White" />
        <Columns>
             <asp:TemplateField  ItemStyle-BackColor = "#F4F4F4" HeaderStyle-BackColor="#A1C1D9"   HeaderStyle-Font-Size="9"  ItemStyle-HorizontalAlign="Center" HeaderText="Registration<br>ID">
                <ItemTemplate>
                    <asp:Label ID="lblintRegistrationID" runat="server"  BackColor = "#F4F4F4"
                            Text='<%# Eval("intRegistrationID") %>'>
                    </asp:Label>
                </ItemTemplate>
            </asp:TemplateField>
            <asp:TemplateField  ItemStyle-BackColor = "#F4F4F4" HeaderStyle-BackColor="#A1C1D9"   HeaderStyle-Font-Size="9"  ItemStyle-HorizontalAlign="Center" HeaderText="Event<br>Date">
                <ItemTemplate>
                    <asp:Label ID="lblEventDate" runat="server"  BackColor = "#F4F4F4"
                            Text='<%# Eval("dtmEvent","{0:d}") %>'>
                    </asp:Label>
                </ItemTemplate>
            </asp:TemplateField>
            <asp:TemplateField ItemStyle-BackColor = "#F4F4F4" ItemStyle-HorizontalAlign="Left" HeaderStyle-BackColor="#A1C1D9" HeaderStyle-Font-Size="9" HeaderText="Event<br>Title">
                <ItemTemplate>
                    <asp:Label ID="lblTitle" runat="server" BackColor = "#F4F4F4"
                            Text='<%# Eval("strTitle") %>'>
                    </asp:Label>
                </ItemTemplate>
            </asp:TemplateField>
            <asp:TemplateField ItemStyle-BackColor = "#F4F4F4" ItemStyle-HorizontalAlign="Left" HeaderStyle-BackColor="#A1C1D9" HeaderStyle-Font-Size="9" HeaderText="Company<br>Name">
                <ItemTemplate>
                    <asp:Label ID="lblstrName" runat="server" BackColor = "#F4F4F4"
                            Text='<%# Eval("strName") %>'>
                    </asp:Label>
                </ItemTemplate>
            </asp:TemplateField>
            <asp:TemplateField ItemStyle-BackColor = "#F4F4F4"  ItemStyle-HorizontalAlign="Left" HeaderStyle-BackColor="#A1C1D9" HeaderStyle-Font-Size="9" HeaderText="Company<br>Email">
                <ItemTemplate>
                    <asp:Label ID="lblstrEmail" runat="server" BackColor = "#F4F4F4"
                            Text='<%# Eval("strEmail") %>'>
                    </asp:Label>
                </ItemTemplate>
            </asp:TemplateField>

                  <asp:TemplateField ItemStyle-BackColor = "#F4F4F4" ItemStyle-HorizontalAlign="Center" HeaderStyle-BackColor="#A1C1D9" HeaderStyle-Font-Size="9" HeaderText="Fee<br>Amount">
                <ItemTemplate>
                    <asp:Label ID="lblfltOrderAmount" runat="server" BackColor = "#F4F4F4"
                            Text='<% #Eval("fltOrderAmount","{0:c}")  %>'>
                    </asp:Label>
                </ItemTemplate>
                <ItemTemplate>
                        <%#GetUnitPrice(Decimal.Parse(Eval("fltOrderAmount").ToString())).ToString("N2")%>
                    </ItemTemplate>
                    <FooterTemplate>
                        <%# GetTotal().ToString("N2") %>
                    </FooterTemplate>
            </asp:TemplateField>
           
            <asp:TemplateField ItemStyle-BackColor = "#F4F4F4" ItemStyle-HorizontalAlign="Center" HeaderStyle-BackColor="#A1C1D9" HeaderStyle-Font-Size="9" HeaderText="Payment<br>Status">
                <ItemTemplate>
                    <asp:Label ID="lblblnEmailSent" runat="server" BackColor = "#F4F4F4"
                            Text='<% #Eval("strRegistrationStatusID") %>'>
                    </asp:Label>
                </ItemTemplate>
            </asp:TemplateField>
           
             <asp:TemplateField ItemStyle-BackColor = "#F4F4F4" ItemStyle-HorizontalAlign="Center" HeaderStyle-BackColor="#A1C1D9" HeaderStyle-Font-Size="9" HeaderText="Date<br>Registered">
                <ItemTemplate>
                    <asp:Label ID="lbldtmCreated" runat="server" BackColor = "#F4F4F4"
                            Text='<% #Eval("dtmCreated","{0:d}") %>'>
                    </asp:Label>
                </ItemTemplate>
            </asp:TemplateField>
 
        </Columns>
    </asp:GridView>
    <br />

</div>
<table>
 <tr><td align="center">
   <asp:Button ID="btnExportExcel" runat="server" Text="ExportToExcel" onclick="btnexportExcel_click" />
 </td></tr>
 <tr><td align="center">  
 <asp:Button id="Button2" runat="server" text="Return to Event Registration" onclick="btnreturn_click" /></p>
 </td></tr>
</table>
</form>
</td></tr>
</table>

</body>
</HTML>

=========================================

Imports System
Imports System.Data
Imports System.Data.SqlClient
Imports System.Configuration
Imports System.Collections
Imports System.IO
Imports System.Text
Imports System.Xml
Imports System.Web
Imports System.Web.Security
Imports System.Web.UI
Imports System.Web.UI.WebControls
Imports System.Web.UI.WebControls.WebParts
Imports System.Web.UI.HtmlControls

Partial Public Class wwwroot_EventSummaryRpt
    Inherits System.Web.UI.Page
    Private iRowsCount As Integer = 0

    Protected Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs) Handles Me.Load

        If Not IsPostBack Then

            'Dim dtVolumeOrder As New DataTable()
            'Dim strSelectCommand As String = "SELECT e.dtmEvent,e.strTitle,r.strName,r.strEmail,r.fltOrderAmount,r.strRegistrationStatusID,r.dtmCreated FROM i2Integration_EventRegv45_Event e,i2Integration_EventRegv45_Registration r where e.intEventID = r.intEventID and r.strPaymentMethodID = 'pp' and ((r. strRegistrationStatusID = 'cmp') or (r.strRegistrationStatusID = 'agw')) Order by e.dtmEvent"
            'Using sqlConn As New SqlConnection(ConfigurationManager.ConnectionStrings("SiteSqlServer").ConnectionString)
                'Using adapPatientBills As New SqlDataAdapter(strSelectCommand, sqlConn)
                    'adapPatientBills.Fill(dtVolumeOrder)
                'End Using
            'End Using

            'uxItemDetailGrid.DataSource = dtVolumeOrder
            'uxItemDetailGrid.DataBind()

            Dim dtVolumeOrder2 As New DataTable()
            Dim strSelectCommand2 As String = "SELECT distinct(strTitle),intEventID FROM i2Integration_EventRegv45_Event order by intEventID"
            Using sqlConn As New SqlConnection(ConfigurationManager.ConnectionStrings("SiteSqlServer").ConnectionString)
                Using adapPatientBills As New SqlDataAdapter(strSelectCommand2, sqlConn)
                    adapPatientBills.Fill(dtVolumeOrder2)
                End Using
            End Using

            DroplistData.DataSource = dtVolumeOrder2
            DroplistData.DataTextField = "strTitle"
            DroplistData.DataBind()


        End If
    End Sub

Protected Sub uxItemDetailGrid_RowDataBound(ByVal sender As Object, ByVal e As GridViewRowEventArgs)
    If e.Row.RowType = DataControlRowType.DataRow Then
        'switch for first row
        If e.Row.RowIndex = 1 Then
            Dim Gprev As GridViewRow = uxItemDetailGrid.Rows(e.Row.RowIndex - 1)
            If Gprev.Cells(1).Text.Equals(e.Row.Cells(1).Text) Then
                e.Row.Cells(1).Text = ""
            End If
        End If
       
        'now continue with the rest of the rows
       
        If e.Row.RowIndex > 1 Then
            'set reference to the row index and the current value
            Dim intC As Integer = e.Row.RowIndex
            Dim lookfor As String = e.Row.Cells(1).Text
           
            'now loop back through checking previous entries for matches
            Do
                Dim Gprev As GridViewRow = uxItemDetailGrid.Rows(intC - 1)
               
                If Gprev.Cells(1).Text.Equals(e.Row.Cells(1).Text) Then
                    e.Row.Cells(1).Text = ""
                End If
                intC = intC - 1
            Loop While intC > 0
        End If
    End If
End Sub

    Protected Sub DroplistData_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs)

        'Dim dtVolumeOrder As New DataTable()

        'Where strTitle = '" + DroplistData.SelectedValue + "'"
        'Dim strSelectCommand As String = "SELECT strTitle FROM i2Integration_EventRegv45_Event"
        'Using sqlConn As New SqlConnection(ConfigurationManager.ConnectionStrings("SiteSqlServer").ConnectionString)
        'Using adapPatientBills As New SqlDataAdapter(strSelectCommand, sqlConn)
        'adapPatientBills.Fill(dtVolumeOrder)
        'End Using
        'End Using


        'DroplistData.DataSource = dtVolumeOrder
        'DroplistData.DataTextField = "strTitle"
        'DroplistData.DataBind()

        ddlYear.SelectedIndex = 0
    End Sub

    Protected Sub ddlMth_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs)

        Dim dtVolumeOrder As New DataTable()
        'Dim strSelectCommand As String = "SELECT e.dtmEvent,e.strTitle,r.strName,r.strEmail, r.fltOrderAmount,r.strRegistrationStatusID,r.dtmCreated FROM i2Integration_EventRegv45_Event e,i2Integration_EventRegv45_Registration r  where e.intEventID = r.intEventID and r.strPaymentMethodID = 'pp' and ((r.strRegistrationStatusID = 'cmp') or (r.strRegistrationStatusID = 'agw')) and r.blnEmailSent=1 and (YEAR(e.dtmEvent) = '" + ddlYear.SelectedValue + "' AND MONTH(e.dtmEvent) = '" + ddlMth.SelectedValue + "' AND e.strTitle = '" + DroplistData.SelectedValue.Tostring.replace("'","''") + "') Order by e.dtmEvent"
         Dim strSelectCommand As String = "SELECT r.intRegistrationID, e.dtmEvent,e.strTitle,r.strName,r.strEmail, r.fltOrderAmount,r.strRegistrationStatusID,r.dtmCreated FROM i2Integration_EventRegv45_Event e,i2Integration_EventRegv45_Registration r, i2Integration_EventRegv45_RegistrationUser u where e.intEventID = r.intEventID and r.strPaymentMethodID = 'pp' and r.intRegistrationID = u.intRegistrationID and(YEAR(e.dtmEvent) = '" + ddlYear.SelectedValue + "' AND MONTH(e.dtmEvent) = '" + ddlMth.SelectedValue + "' AND e.strTitle = '" + DroplistData.SelectedValue + "') Order by e.dtmEvent"
         Using sqlConn As New SqlConnection(ConfigurationManager.ConnectionStrings("SiteSqlServer").ConnectionString)
            Using adapPatientBills As New SqlDataAdapter(strSelectCommand, sqlConn)
                adapPatientBills.Fill(dtVolumeOrder)
            End Using
        End Using
        'iRowsCount = dtVolumeOrder.Rows.Count - 1
        uxItemDetailGrid.DataSource = dtVolumeOrder
        uxItemDetailGrid.DataBind()

    End Sub

    Protected Sub ddlYear_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs)

        Dim dtVolumeOrder As New DataTable()
        'Dim strSelectCommand As String = "SELECT e.dtmEvent,e.strTitle,r.strName,r.strEmail, r.fltOrderAmount,r.strRegistrationStatusID,r.dtmCreated FROM i2Integration_EventRegv45_Event e,i2Integration_EventRegv45_Registration r  where e.intEventID = r.intEventID and r.strPaymentMethodID = 'pp' and ((r.strRegistrationStatusID = 'cmp') or (r.strRegistrationStatusID = 'agw')) and r.blnEmailSent=1 and (YEAR(e.dtmEvent) = '" + ddlYear.SelectedValue + "' AND MONTH(e.dtmEvent) = '" + ddlMth.SelectedValue + "' AND e.strTitle = '" + DroplistData.SelectedValue.Tostring.replace("'","''") + "') Order by e.dtmEvent"
         Dim strSelectCommand As String = "SELECT r.intRegistrationID, e.dtmEvent,e.strTitle,r.strName,r.strEmail, r.fltOrderAmount,r.strRegistrationStatusID,r.dtmCreated FROM i2Integration_EventRegv45_Event e,i2Integration_EventRegv45_Registration r, i2Integration_EventRegv45_RegistrationUser u where e.intEventID = r.intEventID and r.strPaymentMethodID = 'pp' and r.intRegistrationID = u.intRegistrationID and(YEAR(e.dtmEvent) = '" + ddlYear.SelectedValue + "' AND MONTH(e.dtmEvent) = '" + ddlMth.SelectedValue + "' AND e.strTitle = '" + DroplistData.SelectedValue + "') Order by e.dtmEvent"
         Using sqlConn As New SqlConnection(ConfigurationManager.ConnectionStrings("SiteSqlServer").ConnectionString)
            Using adapPatientBills As New SqlDataAdapter(strSelectCommand, sqlConn)
                adapPatientBills.Fill(dtVolumeOrder)
            End Using
        End Using
        'iRowsCount = dtVolumeOrder.Rows.Count - 1
        uxItemDetailGrid.DataSource = dtVolumeOrder
        uxItemDetailGrid.DataBind()
    End Sub

    Public Overloads Overrides Sub VerifyRenderingInServerForm(ByVal control As Control)
        ' Verifies that the control is rendered
    End Sub
    Protected Sub OnPaging(ByVal sender As Object, ByVal e As GridViewPageEventArgs)
        uxItemDetailGrid.PageIndex = e.NewPageIndex
        uxItemDetailGrid.DataBind()
    End Sub

    Protected Sub btnExportWord_Click(ByVal sender As Object, ByVal e As EventArgs)

        Response.Clear()
        Response.Buffer = True
        'For Word:
        Response.AddHeader("content-disposition", "attachment;filename=datafile.doc")
        Response.ContentType = "application/vnd.ms-word"
        'For Excel Response.AddHeader("content-disposition", "attachment;filename=data.xls"); Response.ContentType = "application/vnd.ms-excel";
        Response.Charset = ""
        Me.EnableViewState = False
        Dim oStringWriter As New System.IO.StringWriter()
        Dim oHtmlTextWriter As New System.Web.UI.HtmlTextWriter(oStringWriter)
        uxItemDetailGrid.RenderControl(oHtmlTextWriter)
        Response.Write(oStringWriter.ToString())
        Response.[End]()

    End Sub

    Protected Sub btnexportexcel_click(ByVal sender As Object, ByVal e As System.EventArgs)
        Response.Clear()
        Response.Buffer = True
        'For Word:
        'Response.AddHeader("content-disposition", "attachment;filename=data.doc")
        'Response.ContentType = "application/vnd.ms-word"
        'For Excel
        Response.AddHeader("content-disposition", "attachment;filename=Eventdata.xls")
        Response.ContentType = "application/vnd.ms-excel"
        Response.Charset = ""
        Me.EnableViewState = False
        Dim oStringWriter As New System.IO.StringWriter()
        Dim oHtmlTextWriter As New System.Web.UI.HtmlTextWriter(oStringWriter)
        uxItemDetailGrid.RenderControl(oHtmlTextWriter)
        Response.Write(oStringWriter.ToString())
        Response.[End]()
    End Sub
 
    Protected Sub btnreturn_click(ByVal sender As Object, ByVal e As System.EventArgs)
        'Dim URL = "http://www.cmaanorcalevents.com/"
        Response.Redirect("http://oaklandboc.com/dotnetnuke/") ' return to clients website
    End Sub

End Class



48  1/28/2010  Breakfast of Champions - Franciscos Restaurant near Oakland Airport  CALTROP Corporation  landerson@CALTROP.com  25.00  agw  1/18/2010  
56  1/28/2010  Breakfast of Champions - Franciscos Restaurant near Oakland Airport  Russell A Moore  jmramoore@yahoo.com  25.00  agw  1/20/2010  
59  1/28/2010  Breakfast of Champions - Franciscos Restaurant near Oakland Airport  S&C Engineers  andy_kleiber@scengineers.com  25.00  agw  1/21/2010  
62  1/28/2010  Breakfast of Champions - Franciscos Restaurant near Oakland Airport  KELLCO  mailbox3137@kellcomacs.com  25.00  cmp  1/21/2010  
83  1/28/2010  Breakfast of Champions - Franciscos Restaurant near Oakland Airport  Susan Farrell  Dina.Potter@jacobs.com  25.00  agw  1/22/2010  
84  1/28/2010  Breakfast of Champions - Franciscos Restaurant near Oakland Airport  Mabel Cater  mcater@mcguireandhester.com  25.00  agw  1/22/2010  
85  1/28/2010  Breakfast of Champions - Franciscos Restaurant near Oakland Airport  Arrow Acoustics Inc  dave@arrowacoustics.com  25.00  agw  1/22/2010  
87  1/28/2010  Breakfast of Champions - Franciscos Restaurant near Oakland Airport  Mabel Cater  mcater@mcguireandhester.com  25.00  cmp  1/22/2010  
88  1/28/2010  Breakfast of Champions - Franciscos Restaurant near Oakland Airport  Eli Naor  denise@vbnarch.com  25.00  agw  1/25/2010  
89  1/28/2010  Breakfast of Champions - Franciscos Restaurant near Oakland Airport  Summit Associates  ken.rice@summticm.com  25.00  agw  1/25/2010  
90  1/28/2010  Breakfast of Champions - Franciscos Restaurant near Oakland Airport  Julie K. Morgan  j.morgan@fehrandpeers.com  25.00  agw  1/25/2010  
93  1/28/2010  Breakfast of Champions - Franciscos Restaurant near Oakland Airport  Anthony Thompson  thompsona@bankofalameda.com  25.00  agw  1/25/2010  
94  1/28/2010  Breakfast of Champions - Franciscos Restaurant near Oakland Airport  Paul J Krupka  paul.krupka@kimley-horn.com  25.00  agw  1/25/2010

Open in new window

Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
this would take time
Top Expert 2005

Commented:
The problem is obviously Oakland Airport. Either use SFO or Sacramento.

Sorry, couldn't resist.  I have a lot of family out there, and being a KC Chiefs fan anything Oakland is bad.

Hopefully you get a chuckle. I don't mean to make light of your code problem.

Author

Commented:
I need to know why my routine is not removing either the date or the event
I have  uxItemDetailGrid_RowDataBound in the grid and the proc in the codebehind

'1/28/2010' or 'Breakfast of Champions - Franciscos Restaurant near Oakland Airport'

48  1/28/2010  Breakfast of Champions - Franciscos Restaurant near Oakland Airport  CALTROP Corporation  landerson@CALTROP.com  25.00  agw  1/18/2010  
56  1/28/2010  Breakfast of Champions - Franciscos Restaurant near Oakland Airport  Russell A Moore  jmramoore@yahoo.com  25.00  agw  1/20/2010  
59  1/28/2010  Breakfast of Champions - Franciscos Restaurant near Oakland Airport  S&C Engineers  andy_kleiber@scengineers.com  25.00  agw  1/21/2010  
62  1/28/2010  Breakfast of Champions - Franciscos Restaurant near Oakland Airport
i don't think any body has time to read whole code to comment on it. would you mind giving a short description of problem and a short code snippet.
Try to append the following to your SELECT statement code:
GROUP BY r.intRegistrationID, e.dtmEvent,e.strTitle,r.strName, r.strEmail, r.fltOrderAmount,r.strRegistrationStatusID,r.dtmCreated"

Dim strSelectCommand As String = "SELECT r.intRegistrationID, e.dtmEvent,e.strTitle,r.strName,r.strEmail, r.fltOrderAmount,r.strRegistrationStatusID,r.dtmCreated FROM i2Integration_EventRegv45_Event e,i2Integration_EventRegv45_Registration r, i2Integration_EventRegv45_RegistrationUser u where e.intEventID = r.intEventID and r.strPaymentMethodID = 'pp' and r.intRegistrationID = u.intRegistrationID and(YEAR(e.dtmEvent) = '" + ddlYear.SelectedValue + "' AND MONTH(e.dtmEvent) = '" + ddlMth.SelectedValue + "' AND e.strTitle = '" + DroplistData.SelectedValue + "') Order by e.dtmEvent GROUP BY r.intRegistrationID, e.dtmEvent,e.strTitle,r.strName, r.strEmail, r.fltOrderAmount,r.strRegistrationStatusID,r.dtmCreated"

Open in new window

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial