读书人

做一个例证时候数据库链接connectio

发布时间: 2012-07-30 16:19:05 作者: rapoo

做一个例子时候,数据库链接connectionstring 链接字符串写不好了...

C# code
    protected void Button1_Click(object sender, EventArgs e)    {        string dalei = dalei1.Text.Trim();        SqlConnection conn = new SqlConnection();               conn.ConnectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database.mdf;Integrated Security=True;User Instance=True";        conn.Open();        SqlCommand comm = new SqlCommand("insert into bigsort(bigsort) values('"+dalei+"')",conn);        comm.ExecuteNonQuery();        Label2.Text = "ok";    }


提示说conn.Connectionstring 处错误,请帮忙看看?哪里错了

我是做个字段,保存到数据库。数据库是设成本地的了。

[解决办法]
Data Source=myServerAddress;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword;
Server=.\SQLExpress;AttachDbFilename=|DataDirectory|mydbfile.mdf; Database=dbname;Trusted_Connection=Yes;
using(SqlConnection conn = new SqlConnection(""))
{}
[解决办法]
string dalei = dalei1.Text.Trim();
SqlConnection conn = new SqlConnection();

conn.ConnectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database.mdf;Integrated Security=True;User Instance=True";

conn.Open();
SqlCommand comm = new SqlCommand("insert into bigsort(bigsort) values('"+dalei+"')",conn);
comm.ExecuteNonQuery();
Label2.Text = "ok";




string connectionString="Data Source=127.0.0.1;Initial Catalog=kaka;Persist Security Info=True;User ID=sa;Password=123"

数据库链接符







[解决办法]
再不行加我QQ:728888165

读书人网 >asp.net

热点推荐