//连接Access
//---------------------用OleDbConnection连接数据库
//string Oconstr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=="+ Server.MapPath("~/") + "\\test.mdb";
//OleDbConnection conn = new OleDbConnection();
//conn.ConnectionString = Oconstr;//"provider=sqloledb.1;Data Source=PC-20120604KNHD;Initial Catalog=MyTest;User ID=sa;Password=910809";
//conn.Open();
//this.Response.Write(conn .State .ToString ());
//conn.Close();
//this.Response.Write(conn.State.ToString());
//----------------用OleDbConnection连接Sql数据库
string Oconstr1 = "provider=sqloledb.1;Data Source=PC-20120604KNHD;Initial Catalog=MyTest;User ID=sa;Password=910809";
OleDbConnection conn1 = new OleDbConnection();
conn1.ConnectionString = Oconstr1;//"provider=sqloledb.1;Data Source=PC-20120604KNHD;Initial Catalog=MyTest;User ID=sa;Password=910809";
conn1.Open();
this.Response.Write(conn1.State.ToString());
conn1.Close();
this.Response.Write(conn1.State.ToString());
}
//---------------------------用SqlConnection连接数据库
protected void Button1_Click(object sender, EventArgs e)
{
string constr = "Data Source=.;Initial Catalog=MyTest;Persist Security Info=True;User ID=sa;Password=910809";
//string constr = "Data Source=PC-20120604KNHD;Initial Catalog=MyTest;Integrated Security=sspi";
SqlConnection conn = new SqlConnection();
conn.ConnectionString = constr;
conn.Open();
this.Response.Write("open ");
conn.Close();
this.Response.Write("close");
}