C#与ACCESS和SQL SERVER连接的语句怎么写 ,我按照书上写的怎么不通那
这是与access连接的语句 总显示不对
private void button1_Click(object sender, EventArgs e)
{
string strConnection = "Provider=Microsoft.Jet.OleDb.4.0;";
strConnection += @"DataSource=d:data.mdb";
OleDbConnection objConnection = new OleDbConnection(strConnection);
objConnection.Open();
}
这是与access连接的语句 总显示不对
private void button1_Click(object sender, EventArgs e)
{
string strConnection = "Provider=Microsoft.Jet.OleDb.4.0;";
strConnection += @"DataSource=d:data.mdb";
OleDbConnection objConnection = new OleDbConnection(strConnection);
objConnection.Open();
}
{
string strConnection = "Provider=Microsoft.Jet.OleDb.4.0;";
strConnection += @"DataSource=d:\data.mdb";
OleDbConnection objConnection = new OleDbConnection(strConnection);
objConnection.Open();
}
<connectionStrings>
<add name="SQLConnString" connectionString="server=127.0.0.1;database=MyProject;uid=sa;pwd=tom"/>
</connectionStrings>
server=127.0.0.1;database=MyProject;uid=sa;pwd=tom
应该就可以了
SqlConnection conn = new SqlConnection(connectionString)
conn.Open();
我所采用的是相对路径.
protected System.Data.OleDb.OleDbConnection OleDbConnection1;
protected System.Data.OleDb.OleDbDataAdapter OleDbDataAdapter1;
protected System.Data.DataSet DataSet1;
this.OleDbConnection1 = new System.Data.OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + this.MapPath("data.mdb"));
this.OleDbDataAdapter1 = new System.Data.OleDb.OleDbDataAdapter("SELECT top 10 * FROM sales order by sales_id DESC", OleDbConnection1);
this.DataSet1 = new System.Data.DataSet(); this.OleDbConnection1.Open();
this.GridView1.DataSource = this.DataSet1;
this.OleDbDataAdapter1.Fill(DataSet1, "sales");
this.GridView1.DataBind();
this.OleDbConnection1.Close();
连接字符串如下:“Provider=Microsoft.Jet.OLEDB.4.0;Data source=\somepath\mydb.mdb;”
例如:OleDbConnection myOleDbConnection=new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data source=\somepath\mydb.mdb;”);
myOleDbConnection.Open();//打开连接
myOleDbConnection.Close();关闭连接
不过记住 输入路径的时候要双反斜扛;
OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + this.MapPath("data.mdb"));