从Ora_aspnet_users到另一个表如何插入USERID（16类型：原材料，大小） [英] How To Insert USERID (Type: Raw, Size: 16) from Ora_aspnet_users to Another Table

问题描述

对不起，我不能截图上传，由于我的名誉的数量有限，因为我在这里是一个新手。

Sorry I cannot upload the screenshot due to the limited number of my reputation since I am a newbie here.

ora_aspnet_user table with column name userid with datatype of Raw(16)
link to
Instruct Table with userid with datatype of Raw (16) - Other columns is ID (Auto Trigger No), Command (Varchar2 = 256)

MY INLINE ASPX code：

MY INLINE ASPX CODE:

<form id="form1" runat="server">
    <div>
        <asp:DetailsView ID="DetailsView1" runat="server" AutoGenerateRows="False" DataSourceID="SqlDataSource1"
            DefaultMode="Insert" Height="50px" Width="125px">
            <Fields>
                <asp:BoundField DataField="ID" HeaderText="ID" SortExpression="ID" Visible="False" />
                <asp:BoundField DataField="COMMAND" HeaderText="COMMAND" SortExpression="COMMAND" />
                <asp:TemplateField HeaderText="USERID">
                    <InsertItemTemplate>
                        <asp:DropDownList ID="DropDownList1" runat="server" DataSourceID="SqlDataSource2"
                            DataTextField="USERNAME" DataValueField="USERID">
                        </asp:DropDownList>
                   </InsertItemTemplate>
                </asp:TemplateField>
                <asp:CommandField ShowInsertButton="True" />
            </Fields>
        </asp:DetailsView>
        <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
            ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
            ProviderName="<%$ ConnectionStrings:ConnectionString.ProviderName %>" 
            InsertCommand="INSERT INTO INSTRUCT (COMMAND, USERID) VALUES (:COMMAND, :USERID)">
            <InsertParameters>
                <asp:Parameter Name="COMMAND" Type="String" />
                <asp:Parameter Name="USERID" DbType="Binary" Size="16" />
            </InsertParameters>
        </asp:SqlDataSource>
        <asp:SqlDataSource ID="SqlDataSource2" runat="server" 
            ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
            ProviderName="<%$ ConnectionStrings:ConnectionString.ProviderName %>" 
            SelectCommand="SELECT USERID, USERNAME FROM ORA_ASPNET_USERS">
        </asp:SqlDataSource>
    </div>
    </form>
</body>
</html>

以上code只会插入命令文本框，但不会插入来自USERID下拉列表中的用户ID。

The above code will only insert the command textbox and but will not insert the USERID from the USERID dropdown.

我真的AP preciate你的帮助。

I would really appreciate your help.

非常感谢你。

推荐答案

替换您的数据源＆LT; InsertParameter＆GT; 这一个，它可能会帮助你，因为我不吨有源$ C ​​$ C我不能在本地测试，可能出现问题的地方elese虽然

Replace your datasource <InsertParameter> with this one, it might help you, because I don't have your source code I cannot test it locally, the problem could occur somewhere elese though:

<InsertParameters>
   <asp:ControlParameter ControlID="DropDownList1" PropertyName="SelectedValue" Name="USERID" Type="Byte"></asp:ControlParameter>
   <asp:ControlParameter ControlID="DropDownList1" PropertyName="SelectedItem.Text" Name="COMMAND" Type="String"></asp:ControlParameter>
</InsertParameters>

这篇关于从Ora_aspnet_users到另一个表如何插入USERID（16类型：原材料，大小）的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！