I've got a gridview (that I converted over from a datagrid, which had
been working properly), that is doubling up the number of rows returned.
When it was running as a datagrid, the same code sent back the
proper number of rows. The only thing different I am doing is to
display the number of rows returned in the footer of the gridview.
The Bindgrid is as follows:
Sub BindGrid()
Session("report level") = Session("availa bilityrptlevel" )
Session("sporti nggoods") = Session("sg_sku ")
Session("le_wid gets") = Session("le_sku ")
Session("ISP_wi dgets") = Session("ISP_sk u")
Dim ConnectionStrin g As String = Session("Connec tString")
Dim myConnection As New SqlConnection(C onnectionString )
Dim cmdFAAvailabili ty As New
SqlCommand("sp_ ASP_fa_availabi lity_new3", myConnection)
cmdFAAvailabili ty.CommandType = CommandType.Sto redProcedure
Dim prmfaavailabili ty As New SqlParameter
prmfaavailabili ty.ParameterNam e = "@availabilityr ptlevel"
prmfaavailabili ty.SqlDbType = SqlDbType.VarCh ar
prmfaavailabili ty.Value = Session("availa bilityrptlevel" )
cmdFAAvailabili ty.Parameters.A dd(prmfaavailab ility)
Dim prmsg_sku As New SqlParameter
prmsg_sku.Param eterName = "@sg_sku"
prmsg_sku.SqlDb Type = SqlDbType.Int
prmsg_sku.Value = Session("sg_sku ")
cmdFAAvailabili ty.Parameters.A dd(prmsg_sku)
Dim prmle_sku As New SqlParameter
prmle_sku.Param eterName = "@le_sku"
prmle_sku.SqlDb Type = SqlDbType.Int
prmle_sku.Value = Session("le_sku ")
cmdFAAvailabili ty.Parameters.A dd(prmle_sku)
Dim prmISP_AFW As New SqlParameter
prmISP_AFW.Para meterName = "@isp"
prmISP_AFW.SqlD bType = SqlDbType.VarCh ar
prmISP_AFW.Valu e = Session("ISP_wi dgets")
cmdFAAvailabili ty.Parameters.A dd(prmISP_AFW)
Dim prmSG_sts As New SqlParameter
prmSG_sts.Param eterName = "@sg_sts"
prmSG_sts.SqlDb Type = SqlDbType.VarCh ar
prmSG_sts.Value = Session("SG_sts ")
cmdFAAvailabili ty.Parameters.A dd(prmSG_sts)
Dim prmLE_sts As New SqlParameter
prmLE_sts.Param eterName = "@le_sts"
prmLE_sts.SqlDb Type = SqlDbType.VarCh ar
prmLE_sts.Value = Session("LE_sts ")
cmdFAAvailabili ty.Parameters.A dd(prmLE_sts)
Try
Dim daGetAvailabili ty As New
SqlDataAdapter( cmdFAAvailabili ty)
Dim dsAvailability As New DataSet
daGetAvailabili ty.Fill(dsAvail ability, "zproduct")
If daGetAvailabili ty.Fill(dsAvail ability, "zproduct") >
0 Then
Label4.ForeColo r = Color.Black
Label4.Text = ""
Me.GridView1.Vi sible = True
Me.GridView1.Da taSource =
dsAvailability. Tables("zproduc t")
Me.GridView1.Da taBind()
Else
Select Case Session("btnSel ect")
Case "SG" 'Sporting
Label4.Text = "No Sporting widgets on
Availability List as of " & Year(Now()) & "-" & Month(Now()) & "-" &
Day(Now())
Case "LE" 'Entertainment
Label4.Text = "No Entertainment widgets on
Availability List as of " & Year(Now()) & "-" & Month(Now()) & "-" &
Day(Now())
Case "ISP" 'ISP
Label4.Text = "No ISP widgets on
Availability List as of " & Year(Now()) & "-" & Month(Now()) & "-" &
Day(Now())
Case "SG_STS" 'Sporting Subject-To-Stock
Label4.Text = "No Sporting widgets on
Subject-to-Stock List as of " & Year(Now()) & "-" & Month(Now()) & "-" &
Day(Now())
Case "LE_STS" 'LE Subject-to-Stock
Label4.Text = "No Entertainment widgets on
Subject-to-Stock List as of " & Year(Now()) & "-" & Month(Now()) & "-" &
Day(Now())
End Select
Me.GridView1.Vi sible = False
Me.Label4.ForeC olor = Color.Red
End If
Catch SQLexc As SqlException
Dim mail As New MailMessage()
Dim stemp As String = "me@mydomain.co m"
Dim ErrorMessage = "The error description is as
follows: " & SQLexc.ToString ()
mail.From = New MailAddress(ste mp)
mail.To.Add("ad ***********@myd omain.com")
mail.Subject = "Error in widget.com application"
mail.Priority = MailPriority.Hi gh
String.Format(" HTML")
mail.Body = ErrorMessage
Dim SmtpMail As New SmtpClient(Sess ion("MyExchange Server"))
SmtpMail.Send(m ail)
Label3.Text = ""
Label4.Text = ""
Label4.ForeColo r = Color.Red
Label4.Text = Label4.Text + SQLexc.Message. ToString()
Catch ex As Exception
Label3.Text = ""
Label4.ForeColo r = Color.Red
Label4.Text = "There was a problem retrieving data for
this report. "
Finally
Me.SqlConnectio n1.Close()
End Try
End Sub
I also included the code that does different things if I have a SQL
exception, etc.
The Rowdatabound code is:
Sub CustomersGridVi ew_RowDataBound (ByVal sender As Object, ByVal e As
GridViewRowEven tArgs)
If e.Row.RowType = DataControlRowT ype.Footer Then
Dim rows As Integer
rows = Me.GridView1.Ro ws.Count
e.Row.Cells(1). Text = "Total Records: (" & rows & ")"
End If
End Sub
The HTML is:
<asp:GridView ID="GridView1" runat="server"
Font-Size="X-Small" ShowFooter="Tru e"
OnRowDataBound= "CustomersGridV iew_RowDataBoun d" AutoGenerateCol umns="False">
<FooterStyle BackColor="Gain sboro" />
<Columns>
<asp:BoundFie ld DataField="Prod Cd"
HeaderText="Pro d Cd" />
<asp:BoundFie ld DataField="Desc ription"
HeaderText="Des cription" />
<asp:BoundFie ld DataField="Pric e"
DataFormatStrin g="{0:C}" HeaderText="Pri ce" HtmlEncode="Fal se" >
<ItemStyle HorizontalAlign ="Right" />
</asp:BoundField>
<asp:BoundFie ld DataField="free stock"
HeaderText="Fre e Stock" >
<ItemStyle HorizontalAlign ="Right" />
</asp:BoundField>
<asp:BoundFie ld DataField="Note "
HeaderText="Not e" />
</Columns>
<RowStyle BackColor="Mocc asin" />
<HeaderStyle BackColor="Gain sboro" />
<AlternatingRow Style BackColor="Papa yaWhip" />
</asp:GridView>
In debugging, I have a break point on:
If daGetAvailabili ty.Fill(dsAvail ability, "zproduct") 0 Then
and this, and the query run in Query analyzer returns 202 rows. However
a stop point on:
e.Row.Cells(1). Text = "Total Records: (" & rows & ")"
shows the rows variable to be 404, 606, 808, or 1010, and the gridview
has the same number of records in it.
I think the onrowdatabound is the problem, but not sure how to fix it,
since this same code worked just fine in dealing with datagrids. When I
brought in the gridview, I ran them side by side and know that up until
I took out the datagrid (and added the on row databound) the datagrid &
gridview returned the same number of records. When I re-did the code for
the gridview (I had it commented out for the datagrid), I more-or-less
just changed the datagrid to gridview, correcting any errors as I went.
Any ideas why this is getting doubled up? I have a stop point on the
fill, and I believe it's only getting called 1 time, and when I run the
sql code with the parameters in Query Analyzer:
sp_ASP_fa_avail ability_new3 '10','1','0','0 ','0','0'
it returns only 202 rows. However, the app is doubling (and more) these
same records.
Any ideas as to what is going on here?
Thanks,
BC
