C# 往SQL数据库插入listbox的值

各位大哥，求教一个问题：我现在在页面上通过绑定数据库，实现了两个不同listbox之间数据的交替，问题是怎样在C#中获取到“dxListU_R”的值，并且把它插入到数据库中，通过关联“dxCobRole”的值，更新我的另一张SQL表里面相关的“用户角色”的关联信息？
表达或许不是很清楚，望大家见谅个，在线等，诚心求教！HTML代码如下：
<%@PageLanguage="C#"AutoEventWireup="true"CodeBehind="UserRole.aspx.cs"Inherits="Webtest.UserRole.UserRole"%>

<%@Registerassembly="DevExpress.Web.v13.1,Version=13.1.7.0,Culture=neutral,PublicKeyToken=b88d1754d700e49a"namespace="DevExpress.Web.ASPxEditors"tagprefix="dx"%>

<%@Registerassembly="DevExpress.Web.v13.1,Version=13.1.7.0,Culture=neutral,PublicKeyToken=b88d1754d700e49a"namespace="DevExpress.Web.ASPxHeadline"tagprefix="dx"%>

<%@Registerassembly="DevExpress.Web.v13.1,Version=13.1.7.0,Culture=neutral,PublicKeyToken=b88d1754d700e49a"namespace="DevExpress.Web.ASPxPanel"tagprefix="dx"%>

<%@Registerassembly="DevExpress.Web.v13.1,Version=13.1.7.0,Culture=neutral,PublicKeyToken=b88d1754d700e49a"namespace="DevExpress.Web.ASPxRoundPanel"tagprefix="dx"%>

<%@Registerassembly="Microsoft.ReportViewer.WebForms,Version=11.0.0.0,Culture=neutral,PublicKeyToken=89845dcd8080cc91"namespace="Microsoft.Reporting.WebForms"tagprefix="rsweb"%>

<%@Registerassembly="DevExpress.Web.v13.1,Version=13.1.7.0,Culture=neutral,PublicKeyToken=b88d1754d700e49a"namespace="DevExpress.Web.ASPxDocking"tagprefix="dx"%>

<%@Registerassembly="DevExpress.Web.v13.1,Version=13.1.7.0,Culture=neutral,PublicKeyToken=b88d1754d700e49a"namespace="DevExpress.Web.ASPxPopupControl"tagprefix="dx"%>



<!DOCTYPEhtml>



<htmlxmlns="http://www.w3.org/1999/xhtml">

<headrunat="server">

<metahttp-equiv="Content-Type"content="text/html;charset=utf-8"/>

<title></title>

<styletype="text/css">

.auto-style1{

width:95%;

height:36px;

}

.auto-style2{

width:100px;

}

.auto-style3{

width:137px;

}

.auto-style5{

width:116px;

}

</style>

</head>

<bodystyle="height:851px;width:733px">

<formid="FrmUserRole"runat="server">



<%--编写JS验证方法--%>

<scripttype="text/javascript">

functionAddSelectedItems(){

MoveSelectedItems(dxListUser,dxListU_R);

UpdateButtonState();

}



functionAddAllItems(){

MoveAllItems(dxListUser,dxListU_R);

UpdateButtonState();

}



functionRemoveSelectedItems(){

MoveSelectedItems(dxListU_R,dxListUser);

UpdateButtonState();

}



functionRemoveAllItems(){

MoveAllItems(dxListU_R,dxListUser);

UpdateButtonState();

}



functionMoveSelectedItems(srcListBox,dstListBox){

srcListBox.BeginUpdate();

dstListBox.BeginUpdate();

varitems=srcListBox.GetSelectedItems();

for(vari=items.length-1;i>=0;i=i-1){

dstListBox.AddItem(items[i].text,items[i].value);

srcListBox.RemoveItem(items[i].index);

}

srcListBox.EndUpdate();

dstListBox.EndUpdate();

}



functionMoveAllItems(srcListBox,dstListBox){

srcListBox.BeginUpdate();

varcount=srcListBox.GetItemCount();

for(vari=0;i<count;i++){

varitem=srcListBox.GetItem(i);

dstListBox.AddItem(item.text,item.value);

}

srcListBox.EndUpdate();

srcListBox.ClearItems();

}



functionUpdateButtonState(){

dxBtnAddAllToRight.SetEnabled(dxListUser.GetItemCount()>0);

dxBtnDelAllToLeft.SetEnabled(dxListU_R.GetItemCount()>0);

dxBtnAddToRight.SetEnabled(dxListUser.GetSelectedItems().length>0);

dxBtnDelToLeft.SetEnabled(dxListU_R.GetSelectedItems().length>0);

}



</script>



<divstyle="height:831px;width:694px">



<tableclass="auto-style1">

<tr>

<tdclass="auto-style2">

<dx:ASPxButtonID="dxBtnSubmit"runat="server"Height="25px"Text="确定"Width="99px">

</dx:ASPxButton>

</td>

<td>

<dx:ASPxButtonID="dxBtnCancel"runat="server"Text="取消">

</dx:ASPxButton>

</td>

</tr>

</table>

<tableclass="auto-style1">

<tr>

<tdclass="auto-style5">

<dx:ASPxLabelID="dxlblRole"runat="server"Text="角色">

</dx:ASPxLabel>

</td>

<tdclass="auto-style3">

<dx:ASPxComboBoxID="dxCobRole"runat="server"DataSourceID="ListRole"SelectedIndex="0">

<Columns>

<dx:ListBoxColumnFieldName="RoleName"Caption="角色名称"/>

</Columns>

</dx:ASPxComboBox>

<asp:SqlDataSourceID="ListRole"runat="server"ConnectionString="<%$ConnectionStrings:E-ERP-TEST%>"SelectCommand="SELECT[RoleName],[Id]FROM[T_ERP_Role]"></asp:SqlDataSource>

</td>

<tdclass="auto-style3">



</td>

</tr>

<tr>

<tdclass="auto-style5"rowspan="4">



<dx:ASPxListBoxID="dxListUser"runat="server"DataSourceID="ListUser"Height="356px"Rows="10"SelectionMode="CheckColumn"TextField="UserName">

<Columns>

<dx:ListBoxColumnFieldName="UserName"Caption="用户信息"/>

</Columns>

<ClientSideEventsSelectedIndexChanged="function(s,e){UpdateButtonState();}">

</ClientSideEvents>

</dx:ASPxListBox>

<asp:SqlDataSourceID="ListUser"runat="server"ConnectionString="<%$ConnectionStrings:E-ERP-TEST%>"SelectCommand="SELECT[UserName],[UserID]FROM[T_ERP_User]">

</asp:SqlDataSource>

</td>

<tdclass="auto-style3">

<dx:ASPxButtonID="dxBtnAddToRight"runat="server"Text=">>"ClientEnabled="False"ToolTip="Addselecteditems"ClientInstanceName="dxBtnAddToRight">

<ClientSideEventsClick="function(s,e){AddSelectedItems();}"/>

</dx:ASPxButton>

</td>

<tdclass="auto-style3"rowspan="4">

<dx:ASPxListBoxID="dxListU_R"runat="server"DataSourceID="ListU_R"Height="361px"SelectionMode="CheckColumn"TextField="RoleName">

<Columns>

<dx:ListBoxColumnFieldName="UserName"Caption="已包含用户"/>

</Columns>

<ClientSideEventsSelectedIndexChanged="function(s,e){UpdateButtonState();}"></ClientSideEvents>

</dx:ASPxListBox>

<asp:SqlDataSourceID="ListU_R"runat="server"ConnectionString="<%$ConnectionStrings:E-ERP-TEST%>"SelectCommand="SELECTb.UserName,c.RoleNameFROMT_ERP_Users_RoleASaINNERJOINT_ERP_UserASbONa.User_Id=b.UserIDINNERJOINT_ERP_RoleAScONa.Role_Id=c.IdWHERE(c.[RoleName]=@RoleName)">

<SelectParameters>

<asp:FormParameterDefaultValue=""FormField="dxCobRole"Name="RoleName"Type="Object"Size="250"/>

</SelectParameters>

</asp:SqlDataSource>

</td>

</tr>

<tr>

<tdclass="auto-style3">

<dx:ASPxButtonID="dxBtnAddAllToRight"runat="server"Text="ALL>>"ToolTip="Addallitems"ClientInstanceName="dxBtnAddAllToRight">

<ClientSideEventsClick="function(s,e){AddAllItems();}"/>

</dx:ASPxButton>

</td>

</tr>

<tr>

<tdclass="auto-style3">

<dx:ASPxButtonID="dxBtnDelToLeft"runat="server"Text="<<"ToolTip="Removeselecteditems"ClientInstanceName="dxBtnDelToLeft">

<ClientSideEventsClick="function(s,e){RemoveSelectedItems();}"/>

</dx:ASPxButton>

</td>

</tr>

<tr>

<tdclass="auto-style3">

<dx:ASPxButtonID="dxBtnDelAllToLeft"runat="server"Text="<<ALL"ToolTip="Removeallitems"ClientInstanceName="dxBtnDelAllToLeft">

<ClientSideEventsClick="function(s,e){RemoveAllItems();}"/>

</dx:ASPxButton>

</td>

</tr>

</table>

<br/>

</div>

</form>

</body>

</html>
14 个解决方案

#1

问题补充：
C#代码属于空白中，没有添加任何方法
14 个解决方案

#1

更多相关文章

随机推荐
