ASP.NET Insert Problem

Question

I am trying to start learning ASP.NET after a few years of PHP experience and I am having trouble getting the basics down.

I am just trying to insert a row into a MS SQL Server Compact 4.0 database with ASP.NET & C#. However, my page only inserts a blank row. The edit & delete functions of GridView work correctly. What am I doing wrong?

Default.aspx

<%@ Page Title="Home Page" Language="C#" MasterPageFile="~/Site.master" AutoEventWireup="true"
CodeBehind="Default.aspx.cs" Inherits="testSite._Default" %>

<asp:Content ID="HeaderContent" runat="server" ContentPlaceHolderID="HeadContent">
</asp:Content>
<asp:Content ID="BodyContent" runat="server" ContentPlaceHolderID="MainContent">
<h2>People</h2>
 <p>
    <asp:GridView ID="GridView1" runat="server" AllowSorting="True" 
        AutoGenerateColumns="False" DataKeyNames="ID" DataSourceID="SqlDataSource1">
        <Columns>
            <asp:CommandField ShowDeleteButton="True" ShowEditButton="True" 
                ShowSelectButton="True" />
            <asp:BoundField DataField="first" HeaderText="first" SortExpression="first" />
            <asp:BoundField DataField="last" HeaderText="last" SortExpression="last" />
        </Columns>
    </asp:GridView>
    <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
        ConnectionString="<%$ ConnectionStrings:sqltestConnectionString %>" 
        DeleteCommand="DELETE FROM [People] WHERE [ID] = @ID" 
        InsertCommand="INSERT INTO [People] ([first], [last]) VALUES (@first, @last)" 
        SelectCommand="SELECT * FROM [People]" 
        UpdateCommand="UPDATE [People] SET [first] = @first, [last] = @last WHERE [ID] = @ID" >
        <DeleteParameters>
            <asp:Parameter Name="ID" Type="Int32" />
        </DeleteParameters>
        <InsertParameters>
            <asp:FormParameter Name="first" FormField="txtFirst" />
            <asp:FormParameter Name="last" FormField="txtLast" />
        </InsertParameters>
        <UpdateParameters>
            <asp:Parameter Name="first" Type="String" />
            <asp:Parameter Name="last" Type="String" />
            <asp:Parameter Name="ID" Type="Int32" />
        </UpdateParameters>
    </asp:SqlDataSource>
</p>
<p>
    <asp:Label ID="Label1" runat="server" Text="First"></asp:Label>
    <asp:TextBox ID="txtFirst" runat="server"></asp:TextBox>
    <br />
    <asp:Label ID="Label2" runat="server" Text="Last"></asp:Label>
    <asp:TextBox ID="txtLast" runat="server"></asp:TextBox>
    <br />
    <asp:Button ID="btnAdd" runat="server" onclick="btnAdd_Click" Text="Add" />
</p>
</asp:Content>

Default.aspx.cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

namespace testSite
{
    public partial class _Default : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {

        }

        protected void btnAdd_Click(object sender, EventArgs e)
        {
            SqlDataSource1.Insert();
        }
    }
}

santosh singh · Accepted Answer · 2011-04-30 18:52:11Z

2

try this

    private List<SqlParameter> insertParameters = new List<SqlParameter>();

    protected void Page_Load(object sender, EventArgs e)
    {

    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        SqlParameter fName = new SqlParameter("@First", SqlDbType.VarChar, 30);
        fName.Direction = ParameterDirection.Input;

        fName.Value = txtFirst.Text;
        SqlParameter lName = new SqlParameter("@Last", SqlDbType.VarChar, 30);
        lName.Direction = ParameterDirection.Input;

        lName.Value = txtLast.Text;

        insertParameters.Add(fName);
        insertParameters.Add(lName);
        SqlDataSource1.Insert();
    }

    protected void SqlDataSource1_Inserting(object sender, SqlDataSourceCommandEventArgs e)
    {

        e.Command.Parameters.Clear();

        foreach (SqlParameter p in insertParameters)

            e.Command.Parameters.Add(p);
    }
}

answered Apr 30, 2011 at 18:52

santosh singh

28.8k27 gold badges88 silver badges134 bronze badges

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

1 Comment

David Mihal Over a year ago

this works, thank you! Still, seems like there must be an easier way

Collectives™ on Stack Overflow

ASP.NET Insert Problem

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related