this code throws errors, but sort of communicates what I'm trying to do. In short, i want to bind a ASP.NET 2.0 GridView to an access database source upon a command button click event.
protected void Button1_Click(object sender, EventArgs e)
AccessDataSource db = new AccessDataSource();
db.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:TmpSteel.mdb;database password = 1n_t@e!r^m+ez-z0";
AccessDataSourceView ds = new AccessDataSourceView();
ds.SelectCommand = "SELECT * FROM Table1";
GridView1.DataSource = ds.SelectCommand;
any suggestions for how I bind to a password protected access database at runtime???