C#.NET向数据库添加数据时没有反映（留言板）

最新推荐文章于 2022-05-24 14:20:05 发布

临武社工

最新推荐文章于 2022-05-24 14:20:05 发布

阅读量583

点赞数 1

文章标签：数据库 textbox server asp insert dataset

本文链接：https://blog.csdn.net/tangeg0123/article/details/6040427

版权

我在用C#.NET+SQL制作一个在线留言板时，出错了，点击添加按钮，没有任何反映，也找不出原因，还请大伙参考参考。

前台代码：

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="index.aspx.cs" Inherits="index" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

</head>

<body>

<div>

<cc1:ToolkitScriptManager ID="ToolkitScriptManager1" runat="server">

</cc1:ToolkitScriptManager>

<asp:UpdatePanel ID="UpdatePanel1" runat="server">

留言标题：<asp:TextBox ID="TextBox1" runat="server"></asp:TextBox><br />

您的称呼：<asp:TextBox ID="TextBox2" runat="server"></asp:TextBox><br />

联系方式：<asp:TextBox ID="TextBox3" runat="server"></asp:TextBox><br />

留言时间：<asp:TextBox ID="TextBox4" runat="server"></asp:TextBox><br />

留言内容：<asp:TextBox ID="TextBox5" runat="server" TextMode="MultiLine"

MaxLength="1000"></asp:TextBox>

<br />

<asp:Button ID="saveBtn" runat="server" Text="提交" οnclick="saveBtn_Click"/>

</ContentTemplate>

</asp:UpdatePanel>

</div>

</body>

后台代码为：

using System;

using System.Collections;

using System.Configuration;

using System.Data;

using System.Linq;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.HtmlControls;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Xml.Linq;

using System.Data.SqlClient;

public partial class News_leave_message : System.Web.UI.Page

{

protected void Page_Load(object sender, EventArgs e)

{

}

protected void saveBtn_Click(object sender, EventArgs e)

{

try

{

String ConnStr = "Data Source=(local);Initial Catalog=company.mdf;Integrated Security=True";

SqlConnection conn = new SqlConnection(ConnStr);

conn.Open();

string theName, theCall, theContact, theTime, theContent;

theName = TextBox1.Text.ToString();

theCall = TextBox2.Text.ToString();

theContact = TextBox3.Text.ToString();

theTime = TextBox4.Text.ToString();

theContent = TextBox5.Text.ToString();

SqlCommand cmd = new SqlCommand("INSERT INTO [Messages] ([MessagesName], [PeopleCall], [PeopleContact], [MessagesTime], [MessagesContent]) VALUES (@theName, @theCall, @theContact, @theTime, @theContent)", conn);

cmd.Parameters.Add("@theName");

cmd.Parameters.Add("@theCall");

cmd.Parameters.Add("@theContact");

cmd.Parameters.Add("@theTime");

cmd.Parameters.Add("@theContent");

cmd.ExecuteNonQuery();

//SqlDataAdapter sda = new SqlDataAdapter("INSERT INTO [Messages] ([MessagesName], [PeopleCall], [PeopleContact], [MessagesTime], [MessagesContent]) VALUES (@TextBox1, @TextBox2, @TextBox3, @TextBox4, @TextBox5)", conn);

//SqlDataAdapter sda = new SqlDataAdapter("INSERT INTO [Messages] ([MessagesName], [PeopleCall], [PeopleContact], [MessagesTime], [MessagesContent]) VALUES ('" + TextBox1.Text + "', '" + TextBox2.Text + "','" + TextBox3.Text + "', '" + TextBox4.Text + "', '" + TextBox5.Text + "')", conn);

//DataSet ds = new DataSet();

//sda.Fill(ds);

Response.Write("数据提交成功！<br/> 谢谢您的反馈！");

conn.Close();

}

catch

{

Response.Write("<script language=javascrip>alert('数据提交失败！<br/> 请您再次填定数据！';location='leave-messages.aspx')</script>");

}

Response.Redirect("leave-messages.aspx");

}

临武社工

关注

1
点赞
踩
2

收藏

觉得还不错? 一键收藏
0
评论
C#.NET向数据库添加数据时没有反映（留言板）

<br />我在用C#.NET+SQL制作一个在线留言板时，出错了，点击添加按钮，没有任何反映，也找不出原因，还请大伙参考参考。<br /> <br /> <br /> <br />前台代码：<br /><br /><%@ Page Language="C#" AutoEventWireup="true" CodeFile="index.aspx.cs" Inherits="index" %><br /> <br /><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0
复制链接

扫一扫