当我单击按钮时单击插入到数据库表值为null，为什么TextBox1的值不插入数据库表？ [英] When i click button click the insertion to database table value as null ,why the value of TextBox1 is not inserting into database table ?

问题描述

实际问题是来自文本字段的值不通过插入查询传输..你解决了这个问题，我试了好几次

actual problem is value from text field is not transferring via insert query..can you solve this problem,i tried several times

<%@ Page Title="" Language="C#" MasterPageFile="~/AdminMasterPage.master" AutoEventWireup="true" CodeFile="Add_Department_Admin.aspx.cs" Inherits="Add_Department_Admin" %>

<asp:Content ID="Content1" ContentPlaceHolderID="head" Runat="Server">
    <style type="text/css">
        .auto-style1 {
            width: 50%;
        }
    </style>
    <script  runat="server">
        private void InsertDEPARTMENT(object source, EventArgs e)
        {
            
             
  SqlDataSource2.Insert();
}
</script>

<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">

   <h1>Add Department</h1>
    <table class="auto-style1">
        <tr>
            <td>Department</td>
            <td>
                <asp:DropDownList ID="DropDownList1" runat="server" DataSourceID="SqlDataSource1" DataTextField="DEPARTMENT_NAME" DataValueField="DEPARTMENT_NAME">
                
                <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:cresignsysConnectionString %>" SelectCommand="SELECT [DEPARTMENT_NAME] FROM [MCET_Department_Lookup]">
            </td>
        </tr>
        <tr>
            <td>Add Department:</td>
            <td>
                <asp:TextBox ID="TextBox1" runat="server" >

               
            </td>
        </tr>
        <tr>
            <td> </td>
            <td>
                
                <asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:cresignsysConnectionString %>" DeleteCommand="DELETE FROM [MCET_Department_Lookup] WHERE [DEPARTMENT_ID] = @DEPARTMENT_ID" InsertCommand="INSERT INTO [MCET_Department_Lookup] ([DEPARTMENT_NAME]) VALUES (@DEPARTMENT_NAME)" SelectCommand="SELECT * FROM [MCET_Department_Lookup]" UpdateCommand="UPDATE [MCET_Department_Lookup] SET [DEPARTMENT_NAME] = @DEPARTMENT_NAME WHERE [DEPARTMENT_ID] = @DEPARTMENT_ID">
                    <deleteparameters>
                        <asp:Parameter Name="DEPARTMENT_ID" Type="Int64" />
                    </deleteparameters>
                    <insertparameters>
                       
                        <asp:FormParameter Name="DEPARTMENT_NAME" FormField="TextBox1" />
                    </insertparameters>
                    <updateparameters>
                        <asp:Parameter Name="DEPARTMENT_NAME" Type="String" />
                        <asp:Parameter Name="DEPARTMENT_ID" Type="Int64" />
                    </updateparameters>
                
                <asp:Button ID="Button1" runat="server" OnClick="InsertDEPARTMENT" Text="Button"  />
            </td>
        </tr>
    </table>

推荐答案

ConnectionStrings：cresignsysConnectionString ％> SelectCommand = SELECT [DEPARTMENT_NAME] FROM [MCET_Department_Lookup] >
< / td > ;
< / tr >
< tr >
< td > 添加部门： < / td >
< td >
< asp：TextBox ID = TextBox1 runat = 服务器 >


< / td >
< / tr >
< tr >
< td > < / td >
< td >

< asp：SqlDataSource ID = SqlDataSource2 runat = server ConnectionString = <％

ConnectionStrings:cresignsysConnectionString %>" SelectCommand="SELECT [DEPARTMENT_NAME] FROM [MCET_Department_Lookup]"> </td> </tr> <tr> <td>Add Department:</td> <td> <asp:TextBox ID="TextBox1" runat="server" > </td> </tr> <tr> <td> </td> <td> <asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%

ConnectionStrings：cresignsysConnectionString < span class =code-pagedirective>％> DeleteCommand = DELETE FROM [MCET_Department_Lookup] WHERE [DEPARTMENT_ID] = @DEPARTMENT_ID InsertCommand = INSERT INTO [MCET_Department_Lookup]（[DEPARTMENT_NAME]）VALUES（@DEPARTMENT_NAME） SelectCommand = SELECT * FROM [MCET_Department_Lookup] UpdateCommand = UPDATE [MCET_Department_Lookup] SET [DEPARTMENT_NAME] = @DEPARTMENT_NAME WHERE [DEPARTMENT_ID] = @DEPARTMENT_ID >
< deleteparameters >
< span class =code-keyword>< asp：参数 名称 = DEPARTMENT_ID 类型 = Int64 / >
< / deleteparameters >
< insertparameters >

< asp：FormParameter 名称 = DEPARTMENT_NAME FormField = TextBox1 / >
< < span class =code-leadattribute> / insertparameters >
< updateparameters >
< asp：参数 名称 = DEPARTMENT_NAME 类型 = 字符串 / >
< asp：参数 名称 = DEPARTMENT_ID 类型 = Int64 / >
< / updateparameters >

< asp：按钮 ID = Button1 runat = server OnClick = InsertDEPARTMENT 文字 = 按钮 / >
< / td >
< / tr >
< / table >

ConnectionStrings:cresignsysConnectionString %>" DeleteCommand="DELETE FROM [MCET_Department_Lookup] WHERE [DEPARTMENT_ID] = @DEPARTMENT_ID" InsertCommand="INSERT INTO [MCET_Department_Lookup] ([DEPARTMENT_NAME]) VALUES (@DEPARTMENT_NAME)" SelectCommand="SELECT * FROM [MCET_Department_Lookup]" UpdateCommand="UPDATE [MCET_Department_Lookup] SET [DEPARTMENT_NAME] = @DEPARTMENT_NAME WHERE [DEPARTMENT_ID] = @DEPARTMENT_ID"> <deleteparameters> <asp:Parameter Name="DEPARTMENT_ID" Type="Int64" /> </deleteparameters> <insertparameters> <asp:FormParameter Name="DEPARTMENT_NAME" FormField="TextBox1" /> </insertparameters> <updateparameters> <asp:Parameter Name="DEPARTMENT_NAME" Type="String" /> <asp:Parameter Name="DEPARTMENT_ID" Type="Int64" /> </updateparameters> <asp:Button ID="Button1" runat="server" OnClick="InsertDEPARTMENT" Text="Button" /> </td> </tr> </table>

你调试过了吗？ e InsertDepartment函数中的实际值是什么？



我猜，提交按钮会触发回发，而你没有选定的部门。

Did you debug and see what is the actually value within InsertDepartment function?

I guess, submit button triggers the postback and you don't have the selected department anymore.

这篇关于当我单击按钮时单击插入到数据库表值为null，为什么TextBox1的值不插入数据库表？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！