樱之花

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();