??????????????SQL Server???????????????????????????????????????????????????????.??????SQL Server?????Windows????????????????????"user id"??"password"???????????????????????"Trusted_Connection=SSPI"?????е??.

????"initial catalog=Northwind":??????????"Northwind"????????.????????"Database"?????????д??"Database=Northwind".

????"Server=YourSQLServer":??????"YourSQLServer"???????.????????"Data Source"??"Address"??"Addr".????????????????????????????????????д?"Server=(local)?????";?????????????????"(local)"?滻????????????????IP???.

????"Connect Timeout=30":??????????30??.

??????????????????????????????:SqlConnection.

??????????Access???????????!

/////////////////////////////////????SQL
using System;
using System.Data; //???????????
using System.Data.SqlClient;
namespace sp.DataBase
{
///
/// Data ???????????
///    ??? daodaoliangbi
///   public class Data
{
///
/// ????????????????
///       public static SqlConnection GetConn(){
SqlConnection cn=new SqlConnection(" server =.; uid = sa ; pwd =;database=sp;");
return cn;
}
///
/// ??2???????????????????? GetDaaa ???? dataset?????
///       public static DataSet GetDaaa(string sqlStr??string tableName)
{
SqlConnection cn = GetConn();
cn.Open();
SqlDataAdapter ada = new SqlDataAdapter(sqlStr?? cn);
DataSet ds = new DataSet();
ada.Fill(ds??tableName);
cn.Close();
return ds;
}
///
/// ????????????????????????? ???? true ??false;
///
public static bool GetDs(string sqlStr)
{
SqlConnection cn = GetConn();
cn.Open();
SqlCommand cmd=new SqlCommand(sqlStr??cn);
DataSet ds = new DataSet();
SqlDataReader r = cmd.ExecuteReader();
if(r.HasRows)
{
cn.Close();
return true;
}
else
{
cn.Close();
return false;
}
}
}
}

////////////////////////////
??access????????
string aa=Server.MapPath("~\");
string strConnection = "Provider=Microsoft.Jet.OleDb.4.0;Data Source='"+aa+"DataBase\design.mdb'";
OleDbConnection cn = new OleDbConnection(strConnection);
cn.Open();
string _sql ="select * from pro_table   order by pro_id desc";
OleDbDataAdapter da  = new   OleDbDataAdapter(_sql??cn);
DataSet ds  = new DataSet();
//???DataSet
da.Fill(ds??"nb");
DataTable _dt = ds.Tables[0];
if(_dt.Rows.Count>0)
{
....
}

??????? ?????????access????? ???? ???? ???????   ?????????????. ?????????