ASP.NET Cannot insert the value NULL into column ‘name’

Question

I have One Users table, columns: id, name, surname. I am trying to make simple insert functionality, but when I submit form I get Cannot insert the value NULL into column ‘name’, table ‘database_name.dbo.Users’; column does not allow nulls. INSERT fails.

I am following this tutorial.

<%@ Page Title="" Language="C#" MasterPageFile="~/Site.Master" 
AutoEventWireup="true" CodeBehind="test.aspx.cs" 
Inherits="Spravochnik.Users.test" %>

<asp:Content ContentPlaceHolderID="BodyPlaceHolder" runat="server">

<script runat="server">
    private void store(object source, EventArgs e) {
        SqlDataSource1.Insert();
    }
</script>

<asp:SqlDataSource 
    ID="SqlDataSource1" 
    runat="server" 
    DataSourceMode="DataReader" 
    ConnectionString="Data Source=DESKTOP-FJR7LSU;Initial Catalog=spravochnik;Integrated Security=True"
    SelectCommand="SELECT * FROM Users"
    InsertCommand="INSERT INTO Users (name, surname) VALUES (@Name, @Surname)">
        <InsertParameters>
            <asp:FormParameter Name="Name" FormField="NameBox" />
            <asp:FormParameter Name="Surname" FormField="SurnameBox" />
        </InsertParameters>
</asp:SqlDataSource>

<asp:TextBox ID="NameBox" runat="server" />
<asp:RequiredFieldValidator
    ID="RequiredFieldValidator1"
    runat="server"
    ControlToValidate="NameBox"
    Display="Static"
    ErrorMessage="Please Enter User's Name." /><br />

<asp:TextBox ID="SurnameBox" runat="server" />
<asp:RequiredFieldValidator
    ID="RequiredFieldValidator2"
    runat="server"
    ControlToValidate="SurnameBox"
    Display="Static"
    ErrorMessage="Please Enter User's Surname." /><br />

<asp:Button ID="Button" runat="server" Text="Add" OnClick="store" />


</asp:Content>

Site.Master

<%@ Master Language="C#" AutoEventWireup="true" 
CodeBehind="Site.master.cs" Inherits="Spravochnik.Site" %>

<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
<link href="~/Public/css/bootstrap.min.css" rel="stylesheet" type="text/css" />
<link href="~/Public/css/stylesheet.css" rel="stylesheet" type="text/css" />
<asp:ContentPlaceHolder ID="head" runat="server" />
</head>
<body>
<form runat="server">
    <div class="container">
        <div style="padding-top:50px">
            <asp:ScriptManager runat="server">
                <Scripts>
                    <asp:ScriptReference Path="~/Public/js/jquery.js" />
                    <asp:ScriptReference Path="~/Public/js/bootstrap.min.js" />
                </Scripts>
            </asp:ScriptManager>
            <asp:ContentPlaceHolder ID="BodyPlaceHolder" runat="server" />
        </div>
    </div>
</form>
</body>
</html>

Please help, Thanks in advance!

The value is what i have entered in name input (not empty) — AbdulAziz Nurov
– AbdulAziz Nurov, Commented Jul 12, 2017 at 9:05

Santhosh Raja · Accepted Answer · 2017-07-12 08:39:57Z

0

Hiii,

1.you can change the schema of your database , you can set Identity value and increase the identity seed to +1.

2.you can manually assign some values for the data column ID.

3.You can remove select allow nulls in your table.

answered Jul 12, 2017 at 8:39

Santhosh Raja

391 silver badge9 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Keith Over a year ago

This is one way, I guess it depends if the issues is that it won't allow an insert of NULL, or if it is trying to insert NULL

AbdulAziz Nurov Over a year ago

ID field is not an issue, it is auto-incrementing. The problem is name and surname fields when I call store method it is not getting those values and I don't know why.

AbdulAziz Nurov Over a year ago

I don't want name and surname to be null

Santhosh Raja Over a year ago

Check if the textbox names are correct. Or remove the textbox and put a new one, give a specific name and try again.

mjwills · Accepted Answer · 2017-07-12 09:09:52Z

0

Change:

<asp:TextBox ID="NameBox" runat="server" />

to:

<form id="form1" runat="server">
<asp:TextBox ID="NameBox" runat="server" />

and change:

<asp:Button ID="Button" runat="server" Text="Add" OnClick="store" />

to:

<asp:Button ID="Button" runat="server" Text="Add" OnClick="store" />
</form>

This is needed since asp:FormParameter needs a <form> and your HTML lacks one as is.

answered Jul 12, 2017 at 9:09

mjwills

24.1k6 gold badges45 silver badges74 bronze badges

Comments

AbdulAziz Nurov · Accepted Answer · 2017-07-12 11:18:36Z

0

Don't know why but when I merge Master and child pages to a single one, it works fine. Thanks for your help!

answered Jul 12, 2017 at 11:18

AbdulAziz Nurov

461 silver badge10 bronze badges

Collectives™ on Stack Overflow

ASP.NET Cannot insert the value NULL into column ‘name’

3 Answers 3

4 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

4 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related