.net链接数据库方法

//链接App_Data数据库方法

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

//密码连接方法

//string connstr = "Data Source=.;Initial Catalog=a;Persist Security Info=True;User ID=sa;Password=xy946858;Max Pool Size = 512;";
            SqlConnection conn = new SqlConnection(connstr);

if (conn.State.ToString().ToLower() == "open")
            {
                //连接打开时
                Response.Write(123423);
            }
            else
            {
                Response.Write("连接出错");
            }

posted @ 2012-11-06 23:07  星宇  阅读(62)  评论(0)    收藏  举报