using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{ }
protected void Button1_Click(object sender, EventArgs e)
{ }
protected void btn_SendMessage_Click(object sender, EventArgs e)
{
SqlConnection conn =new SqlConnection
(@"server=(local)\sqlexpress;database=GuestBook;Trusted_connection=True");
string sql="INsert into tbguestbook (username,posttime,message,IsReplide,reply)values
('"+tb_username.text+"','"+datetime.now+"','"+tb_message.text+"',0,'')";
SqlCommand cmd = new SqlCommand(sql,conn);
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
}
}
以上是代码。错误提示是:用户无法登录数据库,求解!
本机没安装IIS,这个有影响吗?
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{ }
protected void Button1_Click(object sender, EventArgs e)
{ }
protected void btn_SendMessage_Click(object sender, EventArgs e)
{
SqlConnection conn =new SqlConnection
(@"server=(local)\sqlexpress;database=GuestBook;Trusted_connection=True");
string sql="INsert into tbguestbook (username,posttime,message,IsReplide,reply)values
('"+tb_username.text+"','"+datetime.now+"','"+tb_message.text+"',0,'')";
SqlCommand cmd = new SqlCommand(sql,conn);
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
}
}
以上是代码。错误提示是:用户无法登录数据库,求解!
本机没安装IIS,这个有影响吗?
http://www.connectionstrings.com/
Data Source = 服务器名;Initial Catalog = 数据库名;User ID = 用户名;PWD = 密码
若使用Windows集成验证:
Data Source = 服务器名;Initial Catalog = 数据库名;Integrated Security = true;
写在web.config中后台获取的时候用configurationManager.connectionString["SYXTConnectionString"].ToString()Web.config中加入
<connectionStrings> <add name="SYXTConnectionString" connectionString="Data Source=LEIKE;Initial Catalog=SYXT;User ID=sa;Password=sa" providerName="System.Data.SqlClient" /> </connectionStrings>
在web.config文件中,定义一个开关标记<connectionStrings>
<add name = "connString" connectionString = "Data source =.;Initial Catalog = 数据库;User id =用户名;PWD = 密码"></add></connectionStrings>