网格中的重复分组 [英] Duplicate Grouping in grid
问题描述
在对recrod项目类型进行分组时，我反复得到相同的值(重复分组).
请参见代码以及随附文档中的屏幕截图.
ASPX代码
<％@页面语言="VB" AutoEventWireup ="false" CodeFile ="Test_GridViewGroupby.aspx.vb" Inherits ="Test_GridViewGroupby"％>
<％@注册Assembly ="AjaxControlToolkit"命名空间="AjaxControlToolkit" TagPrefix ="AjxTool"％>
<！DOCTYPE html PUBLIC-//W3C//DTD XHTML 1.0 Transitional//EN""http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
< html xmlns ="http://www.w3.org/1999/xhtml">
< head id ="Head1" runat ="server">
< title>无标题页面</title>
< link type ="text/css" rel ="Stylesheet" href ="Includes/css/dialog.css"/>
< link type ="text/css" rel ="Stylesheet" href ="Includes/css/pager.css"/>
< link type ="text/css" rel ="Stylesheet" href ="Includes/css/grid.css"/>
</head>
< body>
< form id ="form1" runat ="server">
< AjxTool:ToolkitScriptManager ID ="ScriptManager1" runat ="server"/>
<％-< asp:SqlDataSource ID ="sqlDsCustomers" runat ="server" ConnectionString =<％$ ConnectionStrings:Northwind％>""
SelectCommand ="SELECT [客户].[客户ID]，[客户].[公司名称]，COUNT([订单ID])TotalOrdersFROM [客户]内联接[订单]上的[客户].[客户ID] = [订单].[客户ID] ]按[客户].[客户ID]，[客户].[公司名称]>
分组
-％>
< asp:SqlDataSource ID ="sqlDsCustomers" runat ="server" ConnectionString =<％$ ConnectionStrings:MPP％>"
SelectCommand =选择ProjectTypeDescription作为ProjectTypeDescription，projectno作为ProjectNoID，projectname作为ProjectName，projectcode作为ProjectNumber，duration作为Duration，
StartDate作为StartWeek，EndDate作为EndWeek，ProjectTypeCode作为ProjectType，
emp_name +''''+ emp_initial +''-``+ emp_number as from csproject中的ProjectLead左外连接
idpeapp.dbo.view_employee.Emp_number = csproject.prjlead
上的idpeapp.dbo.view_employee
csproject.PrjType = mppProjectType.ProjectTypeCode和csproject.PRJTYPE上的INNER JOIN mppProjectType不在(9,11)
按csproject.PrjListOrder，csproject.projectname排序">
Hi,
I am repeatedly getting the same values (Duplicate grouping) when i grouping the recrod project type.
pls.see the code and also Screenshot in the enclosed document.
ASPX Code
<%@ Page Language="VB" AutoEventWireup="false" CodeFile="Test_GridViewGroupby.aspx.vb" Inherits="Test_GridViewGroupby" %>
<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="AjxTool" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head id="Head1" runat="server">
<title>Untitled Page</title>
<link type="text/css" rel="Stylesheet" href="Includes/css/dialog.css" />
<link type="text/css" rel="Stylesheet" href="Includes/css/pager.css" />
<link type="text/css" rel="Stylesheet" href="Includes/css/grid.css" />
</head>
<body>
<form id="form1" runat="server">
<AjxTool:ToolkitScriptManager ID="ScriptManager1" runat="server" />
<%-- <asp:SqlDataSource ID="sqlDsCustomers" runat="server" ConnectionString="<%$ ConnectionStrings:Northwind %>"
SelectCommand="SELECT [Customers].[CustomerID], [Customers].[CompanyName], COUNT([OrderID]) TotalOrdersFROM [Customers] INNER JOIN [Orders] ON [Customers].[CustomerID]=[Orders].[CustomerID]Group By [Customers].[CustomerID], [Customers].[CompanyName]">
--%>
<asp:SqlDataSource ID="sqlDsCustomers" runat="server" ConnectionString="<%$ ConnectionStrings:MPP %>"
SelectCommand="Select ProjectTypeDescription as ProjectTypeDescription,projectno as ProjectNoID,projectname as ProjectName,projectcode as ProjectNumber,duration as Duration,
StartDate as StartWeek,EndDate as EndWeek,ProjectTypeCode as ProjectType,
emp_name+'' ''+ emp_initial+'' - ''+emp_number as ProjectLead from csproject LEFT OUTER JOIN
idpeapp.dbo.view_employee on idpeapp.dbo.view_employee.Emp_number=csproject.prjlead
INNER JOIN mppProjectType on csproject.PrjType=mppProjectType.ProjectTypeCode and csproject.PRJTYPE not in(9,11)
order by csproject.PrjListOrder,csproject.projectname">
MPP:按项目名称订购
MPP : Orders By projectname
< asp:Panel CssClass ="grid" ID ="pnlCust" runat ="server">
< asp:UpdatePanel ID ="pnlUpdate" runat ="server">
< contenttemplate>
< asp:GridView Width ="100％" AllowPaging ="True" ID ="gvCustomers" AutoGenerateColumns ="False"
DataSourceID ="sqlDsCustomers" runat ="server" ShowHeader ="False" OnRowCreated ="gvCustomers_RowCreated">
<列> < asp:TemplateField>
< itemtemplate>
< asp:Panel CssClass ="group" ID ="pnlCustomer" runat ="server">
< asp:图片ID ="imgCollapsible" CssClass ="first" ImageUrl =〜/GridImg/plus.png"
Style ="margin-right:5px;" runat ="server"/>
<％#Eval("ProjectTypeDescription")％>
< asp:SqlDataSource ID ="sqlDsOrders" runat ="server" ConnectionString =<％$ ConnectionStrings:MPP％>"
SelectCommand =选择projectno作为ProjectNoID，选择项目名称作为ProjectName，项目代码作为ProjectNumber，持续时间作为Duration，
StartDate作为StartWeek，EndDate作为EndWeek，ProjectTypeCode作为ProjectType，
emp_name +''''+ emp_initial +''-``+ emp_number as from csproject中的ProjectLead左外连接
idpeapp.dbo.view_employee.Emp_number = csproject.prjlead
上的idpeapp.dbo.view_employee
csproject.PrjType = mppProjectType.ProjectTypeCode和csproject.PRJTYPE上的内部连接mppProjectType不在(9,11)中，其中csproject.PRJTYPE = @ProjectType
按csproject.PrjListOrder，csproject.projectname排序">
< SelectParameters>
< asp:参数名称="ProjectType"类型="String" DefaultValue ="/>
</SelectParameters>
< asp:Panel Style ="margin-left:20px; margin-right:20px" ID ="pnlOrders" runat ="server">
< asp:GridView AutoGenerateColumns ="false" CssClass ="grid" ID ="gvOrders" DataSourceID ="sqlDsOrders"
runat ="server" ShowHeader ="true" EnableViewState ="false">
< rowstyle cssclass ="row">
< alternatingrowstyle cssclass ="altrow">
<列> < asp:TemplateField ItemStyle-CssClass ="rownum">
< itemtemplate>
<％#Container.DataItemIndex + 1％>
< asp:BoundField HeaderText =提案/项目名称" DataField ="ProjectName" ItemStyle-Width ="80px"/>
< asp:BoundField HeaderText ="Project Number" DataField ="ProjectNumber"
ItemStyle-Width ="100px"/>
< asp:BoundField HeaderText =持续时间(以周为单位)" DataField =持续时间"
ItemStyle-Width ="110px"/>
< asp:BoundField HeaderText =开始周" DataField =开始周"
ItemStyle-Width ="50px" ItemStyle-HorizontalAlign ="Right"/>
< asp:BoundField HeaderText ="End Week" DataField ="EndWeek"
ItemStyle-Width ="100px"/>
< asp:BoundField HeaderText =项目负责人" DataField ="ProjectLead"
ItemStyle-Width ="100px"/>
< asp:TemplateField HeaderText ="Asst.Proj Lead" ItemStyle-HorizontalAlign ="Center">
< itemtemplate>
< asp:Button ID ="btnAssPrjLead" text ="Add" width ="50％" runat ="server" CommandName ="AsstPrjLead" Height ="20"
CommandArgument =''<％#Eval("ProjectNoID")％>''
/>
< itemstyle horizontalalign ="Center" width ="2％">
< asp:TemplateField HeaderText ="Edit" ItemStyle-HorizontalAlign ="Center">
< itemtemplate>
< asp:HyperLink ID ="hyperlink1" runat ="server" Height ="20"
ImageUrl =〜/images/Access.gif"
宽度="20"/>
< itemstyle horizontalalign ="Center" width ="2％">
< asp:TemplateField HeaderText =删除" ItemStyle-HorizontalAlign ="Center">
< itemtemplate>
< asp:ImageButton ID ="btnDelete" runat ="server" CommandName ="Delete" Height ="20"
ImageUrl =〜/images/btn_Delete.gif"
CommandArgument =''<％#Eval("ProjectNoID")％>''
宽度="20"/>
< itemstyle horizontalalign ="Center" width ="2％">
< AjxTool:collapsiblepanelextender ID ="cpe" runat ="server" targetcontrolid ="pnlOrders"
collapsedsize ="0"，collapsed ="True"，expandcontrolid ="pnlCustomer"，崩溃控制id ="pnlCustomer"，
autocollapse ="False" autoexpand ="False" scrollcontents ="false" imagecontrolid ="imgCollapsible"
expandimage =〜/GridImg/minus.png"合拢的图像=〜/GridImg/plus.png"
expanddirection =垂直"/>
<asp:Panel CssClass="grid" ID="pnlCust" runat="server">
<asp:UpdatePanel ID="pnlUpdate" runat="server">
<contenttemplate>
<asp:GridView Width="100%" AllowPaging="True" ID="gvCustomers" AutoGenerateColumns="False"
DataSourceID="sqlDsCustomers" runat="server" ShowHeader="False" OnRowCreated="gvCustomers_RowCreated">
<columns> <asp:TemplateField>
<itemtemplate>
<asp:Panel CssClass="group" ID="pnlCustomer" runat="server">
<asp:Image ID="imgCollapsible" CssClass="first" ImageUrl="~/GridImg/plus.png"
Style="margin-right: 5px;" runat="server" />
<%# Eval("ProjectTypeDescription")%>
<asp:SqlDataSource ID="sqlDsOrders" runat="server" ConnectionString="<%$ ConnectionStrings:MPP %>"
SelectCommand="Select projectno as ProjectNoID,projectname as ProjectName,projectcode as ProjectNumber,duration as Duration,
StartDate as StartWeek,EndDate as EndWeek,ProjectTypeCode as ProjectType,
emp_name+'' ''+ emp_initial+'' - ''+emp_number as ProjectLead from csproject LEFT OUTER JOIN
idpeapp.dbo.view_employee on idpeapp.dbo.view_employee.Emp_number=csproject.prjlead
INNER JOIN mppProjectType on csproject.PrjType=mppProjectType.ProjectTypeCode and csproject.PRJTYPE not in(9,11) where csproject.PRJTYPE = @ProjectType
order by csproject.PrjListOrder,csproject.projectname">
<SelectParameters>
<asp:Parameter Name="ProjectType" Type="String" DefaultValue="" />
</SelectParameters>
<asp:Panel Style="margin-left: 20px; margin-right: 20px" ID="pnlOrders" runat="server">
<asp:GridView AutoGenerateColumns="false" CssClass="grid" ID="gvOrders" DataSourceID="sqlDsOrders"
runat="server" ShowHeader="true" EnableViewState="false">
<rowstyle cssclass="row">
<alternatingrowstyle cssclass="altrow">
<columns> <asp:TemplateField ItemStyle-CssClass="rownum">
<itemtemplate>
<%# Container.DataItemIndex + 1%>
<asp:BoundField HeaderText="Proposal / Project Name" DataField="ProjectName" ItemStyle-Width="80px" />
<asp:BoundField HeaderText="Project Number" DataField="ProjectNumber"
ItemStyle-Width="100px" />
<asp:BoundField HeaderText="Duration (In Weeks) " DataField="Duration"
ItemStyle-Width="110px" />
<asp:BoundField HeaderText="Start Week" DataField="StartWeek"
ItemStyle-Width="50px" ItemStyle-HorizontalAlign="Right" />
<asp:BoundField HeaderText="End Week" DataField="EndWeek"
ItemStyle-Width="100px" />
<asp:BoundField HeaderText="Proj Lead" DataField="ProjectLead"
ItemStyle-Width="100px" />
<asp:TemplateField HeaderText="Asst.Proj Lead" ItemStyle-HorizontalAlign="Center">
<itemtemplate>
<asp:Button ID="btnAssPrjLead" text="Add" width="50%" runat="server" CommandName="AsstPrjLead" Height="20"
CommandArgument=''<%# Eval("ProjectNoID") %>''
/>
<itemstyle horizontalalign="Center" width="2%">
<asp:TemplateField HeaderText="Edit" ItemStyle-HorizontalAlign="Center">
<itemtemplate>
<asp:HyperLink ID="hyperlink1" runat="server" Height="20"
ImageUrl="~/images/Access.gif"
Width="20" />
<itemstyle horizontalalign="Center" width="2%">
<asp:TemplateField HeaderText="Delete" ItemStyle-HorizontalAlign="Center">
<itemtemplate>
<asp:ImageButton ID="btnDelete" runat="server" CommandName="Delete" Height="20"
ImageUrl="~/images/btn_Delete.gif"
CommandArgument=''<%# Eval("ProjectNoID") %>''
Width="20" />
<itemstyle horizontalalign="Center" width="2%">
<AjxTool:collapsiblepanelextender ID="cpe" runat="server" targetcontrolid="pnlOrders"
collapsedsize="0" collapsed="True" expandcontrolid="pnlCustomer" collapsecontrolid="pnlCustomer"
autocollapse="False" autoexpand="False" scrollcontents="false" imagecontrolid="imgCollapsible"
expandedimage="~/GridImg/minus.png" collapsedimage="~/GridImg/plus.png"
expanddirection="Vertical" />
</form>
</body>
</html>
Aspx.vb代码
************
导入System.Data
导入System.Configuration
导入System.Web
导入System.Web.Security
导入System.Web.UI
导入System.Web.UI.WebControls
导入System.Web.UI.WebControls.WebParts
导入System.Web.UI.HtmlControls
局部类Test_GridViewGroupby
继承System.Web.UI.Page
受保护的Sub gvCustomers_RowCreated(ByVal发送者为对象，ByVal为GridViewRowEventArgs)
如果e.Row.RowType = DataControlRowType.DataRow然后
作为SqlDataSource = Dim ctrl = TryCast(e.Row.FindControl("sqlDsOrders")，SqlDataSource)
如果ctrl不算什么，而且e.Row.DataItem也算不算什么
ctrl.SelectParameters("ProjectType").DefaultValue = DirectCast(e.Row.DataItem，DataRowView)("ProjectType").ToString()
如果结束
如果结束
结束子
结束类
请为我做错了的地方提供正确的解决方案.
问候，
Ganesh.S
</form>
</body>
</html>
Aspx.vb Code
************
Imports System.Data
Imports System.Configuration
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 Class Test_GridViewGroupby
Inherits System.Web.UI.Page
Protected Sub gvCustomers_RowCreated(ByVal sender As Object, ByVal e As GridViewRowEventArgs)
If e.Row.RowType = DataControlRowType.DataRow Then
Dim ctrl As SqlDataSource = TryCast(e.Row.FindControl("sqlDsOrders"), SqlDataSource)
If ctrl IsNot Nothing AndAlso e.Row.DataItem IsNot Nothing Then
ctrl.SelectParameters("ProjectType").DefaultValue = DirectCast(e.Row.DataItem, DataRowView)("ProjectType").ToString()
End If
End If
End Sub
End Class
pls. provide me the correct solution where i did the mistake.
Regards,
Ganesh.S
推荐答案
ConnectionStrings:Northwind％>"
SelectCommand ="SELECT [客户].[客户ID]，[客户].[公司名称]，COUNT([订单ID])TotalOrdersFROM [客户]内联接[订单]上的[客户].[客户ID] = [订单].[客户ID] ]按[客户].[客户ID]，[客户].[公司名称]>
分组 -％>
< asp:SqlDataSource ID ="sqlDsCustomers" runat ="server" ConnectionString =<％
ConnectionStrings:Northwind %>"
SelectCommand="SELECT [Customers].[CustomerID], [Customers].[CompanyName], COUNT([OrderID]) TotalOrdersFROM [Customers] INNER JOIN [Orders] ON [Customers].[CustomerID]=[Orders].[CustomerID]Group By [Customers].[CustomerID], [Customers].[CompanyName]">
--%>
<asp:SqlDataSource ID="sqlDsCustomers" runat="server" ConnectionString="<%
ConnectionStrings:MPP％>"
SelectCommand =选择ProjectTypeDescription作为ProjectTypeDescription，projectno作为ProjectNoID，projectname作为ProjectName，projectcode作为ProjectNumber，duration作为Duration，
StartDate作为StartWeek，EndDate作为EndWeek，ProjectTypeCode作为ProjectType，
emp_name +''''+ emp_initial +''-``+ emp_number as from csproject中的ProjectLead左外连接
idpeapp.dbo.view_employee.Emp_number = csproject.prjlead
上的idpeapp.dbo.view_employee
csproject.PrjType = mppProjectType.ProjectTypeCode和csproject.PRJTYPE上的INNER JOIN mppProjectType不在(9,11)
按csproject.PrjListOrder，csproject.projectname排序">
ConnectionStrings:MPP %>"
SelectCommand="Select ProjectTypeDescription as ProjectTypeDescription,projectno as ProjectNoID,projectname as ProjectName,projectcode as ProjectNumber,duration as Duration,
StartDate as StartWeek,EndDate as EndWeek,ProjectTypeCode as ProjectType,
emp_name+'' ''+ emp_initial+'' - ''+emp_number as ProjectLead from csproject LEFT OUTER JOIN
idpeapp.dbo.view_employee on idpeapp.dbo.view_employee.Emp_number=csproject.prjlead
INNER JOIN mppProjectType on csproject.PrjType=mppProjectType.ProjectTypeCode and csproject.PRJTYPE not in(9,11)
order by csproject.PrjListOrder,csproject.projectname">
MPP:按项目名称订购
MPP : Orders By projectname
< asp:Panel CssClass ="grid" ID ="pnlCust" runat ="server">
< asp:UpdatePanel ID ="pnlUpdate" runat ="server">
< contenttemplate>
< asp:GridView Width ="100％" AllowPaging ="True" ID ="gvCustomers" AutoGenerateColumns ="False"
DataSourceID ="sqlDsCustomers" runat ="server" ShowHeader ="False" OnRowCreated ="gvCustomers_RowCreated">
<列> < asp:TemplateField>
< itemtemplate>
< asp:Panel CssClass ="group" ID ="pnlCustomer" runat ="server">
< asp:图片ID ="imgCollapsible" CssClass ="first" ImageUrl =〜/GridImg/plus.png"
Style ="margin-right:5px;" runat ="server"/>
<％#Eval("ProjectTypeDescription")％>
< asp:SqlDataSource ID ="sqlDsOrders" runat ="server" ConnectionString =<％
<asp:Panel CssClass="grid" ID="pnlCust" runat="server">
<asp:UpdatePanel ID="pnlUpdate" runat="server">
<contenttemplate>
<asp:GridView Width="100%" AllowPaging="True" ID="gvCustomers" AutoGenerateColumns="False"
DataSourceID="sqlDsCustomers" runat="server" ShowHeader="False" OnRowCreated="gvCustomers_RowCreated">
<columns> <asp:TemplateField>
<itemtemplate>
<asp:Panel CssClass="group" ID="pnlCustomer" runat="server">
<asp:Image ID="imgCollapsible" CssClass="first" ImageUrl="~/GridImg/plus.png"
Style="margin-right: 5px;" runat="server" />
<%# Eval("ProjectTypeDescription")%>
<asp:SqlDataSource ID="sqlDsOrders" runat="server" ConnectionString="<%
ConnectionStrings:MPP％>"
SelectCommand =选择projectno作为ProjectNoID，选择项目名称作为ProjectName，项目代码作为ProjectNumber，持续时间作为Duration，
StartDate作为StartWeek，EndDate作为EndWeek，ProjectTypeCode作为ProjectType，
emp_name +''''+ emp_initial +''-``+ emp_number as from csproject中的ProjectLead左外连接
idpeapp.dbo.view_employee.Emp_number = csproject.prjlead
上的idpeapp.dbo.view_employee
csproject.PrjType = mppProjectType.ProjectTypeCode和csproject.PRJTYPE上的内部连接mppProjectType不在(9,11)中，其中csproject.PRJTYPE = @ProjectType
按csproject.PrjListOrder，csproject.projectname排序">
< SelectParameters>
< asp:参数名称="ProjectType"类型="String" DefaultValue ="/>
</SelectParameters>
< asp:Panel Style ="margin-left:20px; margin-right:20px" ID ="pnlOrders" runat ="server">
< asp:GridView AutoGenerateColumns ="false" CssClass ="grid" ID ="gvOrders" DataSourceID ="sqlDsOrders"
runat ="server" ShowHeader ="true" EnableViewState ="false">
< rowstyle cssclass ="row">
< alternatingrowstyle cssclass ="altrow">
<列> < asp:TemplateField ItemStyle-CssClass ="rownum">
< itemtemplate>
<％#Container.DataItemIndex + 1％>
< asp:BoundField HeaderText =提案/项目名称" DataField ="ProjectName" ItemStyle-Width ="80px"/>
< asp:BoundField HeaderText ="Project Number" DataField ="ProjectNumber"
ItemStyle-Width ="100px"/>
< asp:BoundField HeaderText =持续时间(以周为单位)" DataField =持续时间"
ItemStyle-Width ="110px"/>
< asp:BoundField HeaderText =开始周" DataField =开始周"
ItemStyle-Width ="50px" ItemStyle-HorizontalAlign ="Right"/>
< asp:BoundField HeaderText ="End Week" DataField ="EndWeek"
ItemStyle-Width ="100px"/>
< asp:BoundField HeaderText =项目负责人" DataField ="ProjectLead"
ItemStyle-Width ="100px"/>
< asp:TemplateField HeaderText ="Asst.Proj Lead" ItemStyle-HorizontalAlign ="Center">
< itemtemplate>
< asp:Button ID ="btnAssPrjLead" text ="Add" width ="50％" runat ="server" CommandName ="AsstPrjLead" Height ="20"
CommandArgument =''<％#Eval("ProjectNoID")％>''
/>
< itemstyle horizontalalign ="Center" width ="2％">
< asp:TemplateField HeaderText ="Edit" ItemStyle-HorizontalAlign ="Center">
< itemtemplate>
< asp:HyperLink ID ="hyperlink1" runat ="server" Height ="20"
ImageUrl =〜/images/Access.gif"
宽度="20"/>
< itemstyle horizontalalign ="Center" width ="2％">
< asp:TemplateField HeaderText =删除" ItemStyle-HorizontalAlign ="Center">
< itemtemplate>
< asp:ImageButton ID ="btnDelete" runat ="server" CommandName ="Delete" Height ="20"
ImageUrl =〜/images/btn_Delete.gif"
CommandArgument =''<％#Eval("ProjectNoID")％>''
宽度="20"/>
< itemstyle horizontalalign ="Center" width ="2％">
< AjxTool:collapsiblepanelextender ID ="cpe" runat ="server" targetcontrolid ="pnlOrders"
collapsedsize ="0"，collapsed ="True"，expandcontrolid ="pnlCustomer"，崩溃控制id ="pnlCustomer"，
autocollapse ="False" autoexpand ="False" scrollcontents ="false" imagecontrolid ="imgCollapsible"
expandimage =〜/GridImg/minus.png"合拢的图像=〜/GridImg/plus.png"
expanddirection =垂直"/>
ConnectionStrings:MPP %>"
SelectCommand="Select projectno as ProjectNoID,projectname as ProjectName,projectcode as ProjectNumber,duration as Duration,
StartDate as StartWeek,EndDate as EndWeek,ProjectTypeCode as ProjectType,
emp_name+'' ''+ emp_initial+'' - ''+emp_number as ProjectLead from csproject LEFT OUTER JOIN
idpeapp.dbo.view_employee on idpeapp.dbo.view_employee.Emp_number=csproject.prjlead
INNER JOIN mppProjectType on csproject.PrjType=mppProjectType.ProjectTypeCode and csproject.PRJTYPE not in(9,11) where csproject.PRJTYPE = @ProjectType
order by csproject.PrjListOrder,csproject.projectname">
<SelectParameters>
<asp:Parameter Name="ProjectType" Type="String" DefaultValue="" />
</SelectParameters>
<asp:Panel Style="margin-left: 20px; margin-right: 20px" ID="pnlOrders" runat="server">
<asp:GridView AutoGenerateColumns="false" CssClass="grid" ID="gvOrders" DataSourceID="sqlDsOrders"
runat="server" ShowHeader="true" EnableViewState="false">
<rowstyle cssclass="row">
<alternatingrowstyle cssclass="altrow">
<columns> <asp:TemplateField ItemStyle-CssClass="rownum">
<itemtemplate>
<%# Container.DataItemIndex + 1%>
<asp:BoundField HeaderText="Proposal / Project Name" DataField="ProjectName" ItemStyle-Width="80px" />
<asp:BoundField HeaderText="Project Number" DataField="ProjectNumber"
ItemStyle-Width="100px" />
<asp:BoundField HeaderText="Duration (In Weeks) " DataField="Duration"
ItemStyle-Width="110px" />
<asp:BoundField HeaderText="Start Week" DataField="StartWeek"
ItemStyle-Width="50px" ItemStyle-HorizontalAlign="Right" />
<asp:BoundField HeaderText="End Week" DataField="EndWeek"
ItemStyle-Width="100px" />
<asp:BoundField HeaderText="Proj Lead" DataField="ProjectLead"
ItemStyle-Width="100px" />
<asp:TemplateField HeaderText="Asst.Proj Lead" ItemStyle-HorizontalAlign="Center">
<itemtemplate>
<asp:Button ID="btnAssPrjLead" text="Add" width="50%" runat="server" CommandName="AsstPrjLead" Height="20"
CommandArgument=''<%# Eval("ProjectNoID") %>''
/>
<itemstyle horizontalalign="Center" width="2%">
<asp:TemplateField HeaderText="Edit" ItemStyle-HorizontalAlign="Center">
<itemtemplate>
<asp:HyperLink ID="hyperlink1" runat="server" Height="20"
ImageUrl="~/images/Access.gif"
Width="20" />
<itemstyle horizontalalign="Center" width="2%">
<asp:TemplateField HeaderText="Delete" ItemStyle-HorizontalAlign="Center">
<itemtemplate>
<asp:ImageButton ID="btnDelete" runat="server" CommandName="Delete" Height="20"
ImageUrl="~/images/btn_Delete.gif"
CommandArgument=''<%# Eval("ProjectNoID") %>''
Width="20" />
<itemstyle horizontalalign="Center" width="2%">
<AjxTool:collapsiblepanelextender ID="cpe" runat="server" targetcontrolid="pnlOrders"
collapsedsize="0" collapsed="True" expandcontrolid="pnlCustomer" collapsecontrolid="pnlCustomer"
autocollapse="False" autoexpand="False" scrollcontents="false" imagecontrolid="imgCollapsible"
expandedimage="~/GridImg/minus.png" collapsedimage="~/GridImg/plus.png"
expanddirection="Vertical" />
</form>
</body>
</html>
Aspx.vb代码
************
导入System.Data
导入System.Configuration
导入System.Web
导入System.Web.Security
导入System.Web.UI
导入System.Web.UI.WebControls
导入System.Web.UI.WebControls.WebParts
导入System.Web.UI.HtmlControls
局部类Test_GridViewGroupby
继承System.Web.UI.Page
受保护的Sub gvCustomers_RowCreated(ByVal发送者为对象，ByVal为GridViewRowEventArgs)
如果e.Row.RowType = DataControlRowType.DataRow然后
作为SqlDataSource = Dim ctrl = TryCast(e.Row.FindControl("sqlDsOrders")，SqlDataSource)
如果ctrl不算什么，而且e.Row.DataItem也算不算什么
ctrl.SelectParameters("ProjectType").DefaultValue = DirectCast(e.Row.DataItem，DataRowView)("ProjectType").ToString()
如果结束
如果结束
结束子
结束类
请为我做错了的地方提供正确的解决方案.
问候，
Ganesh.S
</form>
</body>
</html>
Aspx.vb Code
************
Imports System.Data
Imports System.Configuration
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 Class Test_GridViewGroupby
Inherits System.Web.UI.Page
Protected Sub gvCustomers_RowCreated(ByVal sender As Object, ByVal e As GridViewRowEventArgs)
If e.Row.RowType = DataControlRowType.DataRow Then
Dim ctrl As SqlDataSource = TryCast(e.Row.FindControl("sqlDsOrders"), SqlDataSource)
If ctrl IsNot Nothing AndAlso e.Row.DataItem IsNot Nothing Then
ctrl.SelectParameters("ProjectType").DefaultValue = DirectCast(e.Row.DataItem, DataRowView)("ProjectType").ToString()
End If
End If
End Sub
End Class
pls. provide me the correct solution where i did the mistake.
Regards,
Ganesh.S
这篇关于网格中的重复分组的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
