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