![]() |
#2
scindy2009-08-01 15:19
补充一下:
<asp:DataGrid id="DataGrid2" Width="100%" style="BORDER-RIGHT: #99ccff 1px solid; BORDER-TOP: #99ccff 1px solid; FONT-SIZE: 12px; BORDER-LEFT: #99ccff 1px solid; BORDER-BOTTOM: #99ccff 1px solid" HeaderStyle-BackColor="#99ccff" AllowPaging="True" OnEditCommand="mydatagrid_edit" OnCancelCommand="mydatagrid_cancel" OnUpdateCommand="mydatagrid_update" OnDeleteCommand="mydatagrid_delete" DataKeyField="id" AutoGenerateColumns="False" runat="server"> <Columns> <asp:EditCommandColumn HeaderText="操作" EditText="编辑" CancelText="取消" UpdateText="更新"> <ItemStyle Wrap="False" /> <HeaderStyle Width="90px" /> </asp:EditCommandColumn> <asp:TemplateColumn HeaderText="指定组"> <ItemTemplate> <asp:DropDownList ID = "ddlgroup" runat="server" DataTextField="groupname" DataValueField="gid" DataSourceID="SqlDataSource1"> </asp:DropDownList> <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString=" <%$ ConnectionStrings:TY3LConnectionString %>" SelectCommand="select u.id,g.id as gid,g.groupname,u.userno,u.username,u.userpwd,u.macaddress,u.keyvalue,u.memo from tblusers u left join tblgroup g on u.groupid=g.id" > </asp:SqlDataSource> </ItemTemplate> <HeaderStyle CssClass="inputs" Width="132px" /> </asp:TemplateColumn> <asp:BoundColumn DataField="memo" HeaderText="备注"> <HeaderStyle Width="132px" /> </asp:BoundColumn> <asp:TemplateColumn HeaderText="操作"> <ItemTemplate> <asp:Button ID="Delete" CommandName="delete" Text="删 除" Runat="server" CssClass="inputs"> </asp:Button> </ItemTemplate> <HeaderStyle CssClass="inputs" Width="132px" /> </asp:TemplateColumn> </Columns> <PagerStyle Visible="False"> </PagerStyle> <HeaderStyle BackColor="#99CCFF" /> </asp:DataGrid> |
我的DATAGRID模板绑定了DROPDOWNLIST,当加载DATAGRID时候,dropdownlist绑定从数据库中的数据,有一个问题
我的数据库结构为:
tblusers
id username groupid
1 aaa 2
2 bbb 2
tblgroup
id groupname
1 销售组
2 财务组
dropdownlist 用的是datasource selectcommand 语句为下面的SQL语句
SQL语句为:
select u.id,g.id as gid,g.groupname,u.userno,u.username,u.userpwd,u.macaddress,u.keyvalue,u.memo from tblusers u left join tblgroup g on u.groupid=g.id
这样的话下拉列表里面就是两个 财务组 ,我想实现的是下拉菜单里面是 销售组 和 财务组 ,请问是哪儿的问题呢?