Torna al Thread

string connectionString = @"Driver={Microsoft Access Driver (*.mdb)};DBQ=" + Server.MapPath("/mdb-database/DatabaseAccess.mdb"); string SQL = "SELECT * FROM AccessTable"; OdbcConnection conn = new OdbcConnection(connectionString); OdbcCommand cmd = new OdbcCommand(SQL); cmd.Connection = conn; conn.Open(); OdbcDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { Label2.Text += "ID:"+reader.GetInt32(0).ToString(); Label3.Text += "pageName:" + reader.GetString(1).ToString(); Label4.Text += "content:" + reader.GetString(2).ToString(); } reader.Close(); conn.Close();
Copyright © dotNetHell.it 2002-2024
Running on Windows Server 2008 R2 Standard, SQL Server 2012 & ASP.NET 3.5