ASP.NET插入问题

本文关键字:问题 插入 NET ASP | 更新日期: 2023-09-27 17:54:11

我正在尝试开始学习ASP。经过几年的PHP经验,我很难掌握基础知识。

我只是想插入一行到MS SQL Server紧凑型4.0数据库与ASP。净,c#。但是,我的页面只插入一个空白行。编辑&GridView的delete函数工作正常。我做错了什么?

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();
        }
    }
}

ASP.NET插入问题

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);
    }
}