新手难混啊，高手来帮忙

Question

谁能给我一个完整的ASP.NET连接的ACCESS数据库的代码并能DataGrid1得到数据
谢谢～～～
还有一个SQL的也一样
高手帮帮忙

Answer 1

string strDetails="select * from tblXXX";
using(OleDbConnection connDetails = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + HttpContext.Current.Server.MapPath("bin") + "\\ACCESS.mdb"))
{
                OleDbCommand cmdDetails = new OleDbCommand(strDetails, connDetails);
                connDetails.Open();
                try
                {
                    OleDbDataReader rdrDetails = cmdDetails.ExecuteReader();                    gvDetails.DataSource = rdrDetails;//gvDetails可以为GridView,也可为DataGrid
                    gvDetails.DataBind();
                }
                catch (Exception E)
                {
                    HttpContext.Current.Response.Redirect("Error.aspx?ErrorInfo=" + HttpContext.Current.Server.UrlEncode(E.Message), false);
                }
                finally 
                {
                    connDetails.Close();
                    cmdDetails.Dispose();
                    connDetails.Dispose();
                }
}

Answer 2

string s = String.Format("Provider=Microsoft.Jet.OleDb.4.0;Data Source={0}", Server.MapPath(@"App_Data\sample.mdb"));
OleDbConnection conn = new OleDbConnection(s);
string cmdText = "SELECT * FROM Article";
OleDbDataAdapter adapter = new OleDbDataAdapter(cmdText, conn);DataSet ds = new DataSet();
adapter.Fill(ds, "Aritcle");GridView1.DataSource = ds;
GridView1.DataBind();

Answer 3

string s = String.Format("Provider=Microsoft.Jet.OleDb.4.0;Data Source={0}", Server.MapPath(@"App_Data\sample.mdb"));
OleDbConnection conn = new OleDbConnection(s);
string cmdText = "SELECT * FROM Article";
OleDbDataAdapter adapter = new OleDbDataAdapter(cmdText, conn);DataSet ds = new DataSet();
adapter.Fill(ds, "Aritcle");GridView1.DataSource = ds;
GridView1.DataBind();