Manipulating an Access DB in Visual Studio.net 2003 in C#

[Heple]

I want to link to a Microsoft Access database in visual studio. i am coding in C# and have found how to do using the site below

 

http://www.geekpedia.com/prog_ttrls.php?id=158

 

i've got upto the section where you enter the page load event to fill in the data grid using the following VB Code

       
       private void Page_Load(object sender, System.EventArgs e)
       {
           Dim myReader As System.Data.OleDB.OleDBDataReader;
           OleDBConnection1.Open();
           myReader= OleDbCommand1.ExecuteReader();
           ISPDataGrid1.DataSource = myReader;
           ISPDataGrid1.DataBind();
       }

Can someone help me convert this to C# code as i am struggeling to perform this in C#.

 

Thanks

 

Craig

Edited February 20, 2006 by PlausiblyDamp

[PlausiblyDamp]

private void Page_Load(object sender, System.EventArgs e)
{
System.Data.OleDB.OleDBDataReader myReader;
OleDBConnection1.Open();
myReader= OleDbCommand1.ExecuteReader();
ISPDataGrid1.DataSource = myReader;
ISPDataGrid1.DataBind();
}

[Heple]

private void Page_Load(object sender, System.EventArgs e)
{
System.Data.OleDB.OleDBDataReader myReader;
OleDBConnection1.Open();
myReader= OleDbCommand1.ExecuteReader();
ISPDataGrid1.DataSource = myReader;
ISPDataGrid1.DataBind();
}

 

Cheers

 

That worked fine and all compiled ok.

 

But

 

When i run it i get this error

 

The Microsoft Jet database engine cannot open the file 'D:\Inetpub\wwwroot\bandwidthmonitor\ISPDatabase.mdb'. It is already opened exclusively by another user, or you need permission to view its data.

 

Its not been opened by another program. I am the administrator i thought i would have permission.

 

Do you know why it has thrown up this error.

 

Craig

[Nerseus]

Make sure the file is not readonly and that it's not open in Access itself. Otherwise, I can't think of why you'd get that error.

 

-ner