这是我的代码:
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;
namespace WebApplication2
{
public partial class Tianjia : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected void Button1_Click(object sender, EventArgs e)
{
string theName = TextBox1.Text.ToString();
string theCall = TextBox2.Text.ToString();
string theContact = TextBox3.Text.ToString();
string theTime = TextBox4.Text.ToString();
string theContent = TextBox5.Text.ToString();
if (TextBox1.Text == "" || TextBox2.Text == "" || TextBox5.Text == "")
{
if (TextBox1.Text == "")
{
Label6.Text = "标题不能为空";
TextBox1.Focus();
return;
}
if (TextBox2.Text == "")
{
Label7.Text = "称呼不能为空";
TextBox2.Focus();
return;
}
if (TextBox5.Text == "")
{
Label8.Text = "留言不能为空";
TextBox5.Focus();
return;
}
}
else
{
String ConnStr = "Data Source=localhost;Initial Catalog=company;Integrated Security=True";
try
{
SqlConnection conn = new SqlConnection(ConnStr);
conn.Open();
string sqlinsert = "insert into Messages values('" + theName + "','" + theCall + "','" + theContact + "','" + theContent + "')";
SqlCommand cmd = new SqlCommand(sqlinsert, conn);
cmd.ExecuteNonQuery();
TextBox1.Text = "";
TextBox2.Text = "";
TextBox3.Text = "";
TextBox4.Text = "";
TextBox5.Text = "";
conn.Close();
Label9.Text = "数据添加成功,温馨提示!";
conn.Close();
}
catch
{
Response.Write("什么都没有");
}
}
}
}
}
您好!我得晚上才能搞这个能继续帮我解答吗?String ConnStr = "Data Source=localhost;Initial Catalog=company;Integrated Security=True";
这个是我的连接语句!是把这个改下吗?我现在用的这个语句做查询的时候好用。
这个语句 没有问题 String ConnStr = "Data Source=localhost;Initial Catalog=company;Integrated Security=True";
你检查下 你连接的服务器地址 跟数据库名对不对
您好!我吧try 和catch去掉就可以,但是加上数据库又添加不进去数据 这是怎么回事?
不好意思我是新手,我问下怎么设断点能看出,数据库连接成功没?
追答你把你连接字符串的localhost改成“ . ”试试。然后你的SQL语句有问题吧。 string sqlinsert = "insert into Messages(name,call,contact) values('" + theName + "','" + theCall + "','" + theContact + "','" + theContent + "')";
我加那三个字段是对应你要添加的那三个字段、
您一说,好像问题是这,我现在的电脑没有环境,我晚上回家试下!成功与否,我都会告诉你,谢谢你!
追答嗯嗯。好的、
追问您好,我把try和catch去掉就可以添加,但是加上后又是数据库没反应!
追答加Q452460213。我看看你项目呢。