asp.net database connection error

[gaurabmani]

I have problen connecting to the access database through asp.net, this is the page load code i have already set the connection strings through the design views... private void Page_Load(object sender, System.EventArgs e) { oleDbConnection1.Open(); oleDbDataAdapter1.SelectCommand.CommandText="select country from players"; dataReader=oleDbDataAdapter1.SelectCommand.Execute Reader(); while(dataReader.Read()) { nameList.Items.Add(dataReader.GetString(0)); oleDbConnection1.Close(); } } i got an error c:\inetpub\wwwroot\dropdown_database\WebForm1.aspx .cs(32): The name 'dataReader' does not exist in the class or namespace 'dropdown_database.WebForm1' c:\inetpub\wwwroot\dropdown_database\WebForm1.aspx .cs(33): The type or namespace name 'dataReader' could not be found (are you missing a using directive or an assembly reference?) what it means and how i can overcome this problem ??

[Anshuman Singh]

have you careted new object of datareader class ? if not then please first try it.

Anshuman Singh [anshumas@rediffmail.com](mailto:Anshuman Singhanshumas@rediffmail.com)

[arung_73]

Hi, The problem may be with var declaration. Use the following Declaration statement. OleDbDataReader DataReader=new OleDbDataReader ();