access 数据库连接

Question

    我要用VS2005，access数据库，简单的增删改查，急啊，谁能给我个例子。

Answer 1

下载:www.51aspx.com

Answer 2

http://www.connectionStrings.com

Answer 3

http://blog.csdn.net/imliujie/archive/2007/05/21/1619603.aspx在google里面一搜索例子一大堆,不想在google里面找,MSDN也行,要学会找帮助

Answer 4

<connectionStrings>
       <add name="ConStr" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|\MyDatabase.mdb" providerName="System.Data.OleDb"/>
  </connectionStrings>
  private static OleDbConnection GetConnection() {
        string strcon= System.Web.Configuration.WebConfigurationManager.ConnectionStrings["ConStr"].ConnectionString;
        return new OleDbConnection(strcon);
    }   public static DataSet GetDataSetBySql(string sql) {
        OleDbConnection con = GetConnection();
        DataSet ds = new DataSet();
        OleDbDataAdapter da=new OleDbDataAdapter(sql,con);
        try
        {
            da.Fill(ds);
        }
        catch (Exception){}
        finally
        {
            if (con.State == ConnectionState.Open)
            {
                con.Close();
            }
        }
        return ds;
    }