数据库连接字符串

 

1、conn = "Data Source=localhost;Initial Catalog=SuperMarket;Integrated Security=True"

2、conn = "data source=WIN7MS-N2FKC51K;database=SuperMarket;uid=sa;password=123456"

3、con="server=localhost;database=SuperMarket;user=sa;password=123456"

//连接Access数据库
4、conStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Application.StartupPath + "\\App_Data\\database.mdb";

5、conn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + HttpContext.Current.Server.MapPath(ConfigurationManager.AppSettings["dbpath"].ToString());

//连接Excel数据表
6、 MyConnectionstring = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + path + ";Extended Properties='Excel 8.0;HDR=NO;IMEX=1'";

 string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + txtWay.Text + ";Extended Properties=Excel 8.0";