1.连接ACCESS数据库
using System.Data;
using System.Data.OleDb;
...........................
OleDbConnection MyConnection = new OleDbConnection("Provider=Microsoft.Jet.OleDb.4.0;Data Source=" + MapPath("database\\#pcnet_data.mdb"));
OleDbCommand MyCommand = new OleDbCommand("select * from Info where ip like '" + StrIP + "%'", MyConnection);
...........................
MyConnection.Open();
MyConnection.Close();
2.连接SQL SERVER数据库
Web.Config中加
<appSettings>
<add key="DSN" value="Server=(local);DataBase=eProcessDB;user ></add>
</appSettings>
using System.Data.SqlClient;
...........................
string strCon = System.Configuration.ConfigurationSettings.AppSettings["DSN"];
SqlConnection con = new SqlConnection(strCon);
SqlDataAdapter da = new SqlDataAdapter("Select * from tbStudentinfo",con);
DataSet ds = new DataSet();
da.Fill(ds,"studentinfo");
dgShow.DataSource = ds.Tables["studentinfo"].DefaultView;
dgShow.DataBind();
...........................
string strconn = System.Configuration.ConfigurationSettings.AppSettings["DSN"];
SqlConnection conn =new SqlConnection(strconn);
SqlCommand com = new SqlCommand(strSql,conn);
conn.Open();
com.ExecuteNonQuery();
conn.Close();
...........................
string strConnection="user ;
strConnection+="initial catalog=InfoDb;Server=172.18.188.19;";
strConnection+="Connect Timeout=30";
SqlConnection con = new SqlConnection(strConnection);
SqlDataAdapter da = new SqlDataAdapter("Select * from t_meeting",con);
DataSet ds = new DataSet();
da.Fill(ds,"ds_info");
dgShow.DataSource = ds.Tables["ds_info"].DefaultView;
dgShow.DataBind();
评论