我在winform的时候,在新建项目里添加了“本地数据库”MyDataBase.sdf,然后它也自动生成了一个MyDataBaseDataSet.xsd,和一个app.config。以下是app.config内的代码:<?xml version="1.0" encoding="utf-8" ?>
<configuration>
<configSections>
</configSections>
<connectionStrings>
<add name="用户登录.Properties.Settings.Database1ConnectionString"
connectionString="Data Source=|DataDirectory|\MyDataBase.sdf"
providerName="Microsoft.SqlServerCe.Client.3.5" />
</connectionStrings>
</configuration>
请问我该如何连接MyDataBase.sdf数据库?
<configuration>
<configSections>
</configSections>
<connectionStrings>
<add name="用户登录.Properties.Settings.Database1ConnectionString"
connectionString="Data Source=|DataDirectory|\MyDataBase.sdf"
providerName="Microsoft.SqlServerCe.Client.3.5" />
</connectionStrings>
</configuration>
请问我该如何连接MyDataBase.sdf数据库?
http://www.connectionstrings.com/sql-server-2005-ce
//把app.config里的name改短一点,比如<add name="UserLogin" connectionString="..." providerName="..." />
//其它调用方法看一下ADO.NET就全明白了string connectionString = ConfigurationManager.ConnectionStrings["用户登录.Properties.Settings.Database1ConnectionString"].ConnectionString;//把表名改成你自己的
string sql = "select * from products"; SqlConnection conn = new SqlConnection(connectionString);
conn.Open();SqlCommand cmd = new SqlCommand(sql, conn);
SqlDataReader reader = cmd.ExecuteReader();dataGridView1.DataSource = reader;conn.Close();
string connectionString = ConfigurationManager.ConnectionStrings["用户登录.Properties.Settings.Database1ConnectionString"].ConnectionString;