当前位置: 代码迷 >> ASP.NET >> 做一个例证时候,数据库链接connectionstring 链接字符串写不好了.
  详细解决方案

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

热度:9680   发布时间:2013-02-25 00:00:00.0
做一个例子时候,数据库链接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