ds.Tables[0] causes error

Question

Dear All

string connstr = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=School.accdb";
     OleDbConnection connection = new OleDbConnection(connstr );
     connection.Open();
     string sql = "select * from Student";
     OleDbDataAdapter adapter = new OleDbDataAdapter(sql, connection);
     DataSet set=new DataSet();  
     adapter.Fill(set);
     var table=set.Tables[0];
     var result = table.AsEnumerable().Select(x => x.Field<int>("Age")).Take(1);
     Console.WriteLine("First student Age is "+result.First());

In the above code, the line "ds.Tables[0]" causes error. Could anybody help me?

Answer 1

The error is because query is not returning any results. I would check that the database is making it to the bin folder of your app when debugging. I would also verify the table name.

Answer 2

Your latest code returns a single column "ID" but the LINQ query is looking for "Age".