本文主要是介绍C#.NET向数据库添加数据时没有反映（留言板），希望对大家解决编程问题提供一定的参考价值，需要的开发者们随着小编来一起学习吧！
我在用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">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title>在线添加</title>
</head>
<body>
<div>
<cc1:ToolkitScriptManager ID="ToolkitScriptManager1" runat="server">
</cc1:ToolkitScriptManager>
<asp:UpdatePanel ID="UpdatePanel1" runat="server">
<ContentTemplate>
留言标题：<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");
}
}
这篇关于C#.NET向数据库添加数据时没有反映（留言板）的文章就介绍到这儿，希望我们推荐的文章对编程师们有所帮助！
