先创建ACCESS数据库
再配置好ODBC数据源
C#连接数据库的代码:
using System.Data.Odbc;
public partial class NewsList : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
string ACCESS_CONN_STRING = "DSN=My_DB; User Id=Admin; Password=aaa;";
OdbcConnection aConnection = new OdbcConnection(ACCESS_CONN_STRING);
try{
OdbcDataAdapter myCommand = new OdbcDataAdapter("select * from news", aConnection);
DataSet ds = new DataSet();
myCommand.Fill(ds, "标题");
MyDataGrid.DataSource = ds.Tables["标题"].DefaultView;
MyDataGrid.DataBind();
aConnection.Close();
}
catch(OdbcException err) {
Response.Write("Error occured in read DataBase!");
}
}