Member Avatar for jclast

Hi, I'm new here, but I'm hoping that you guys can help me out.

I'm using ASP.NET 2.0 (C#), and I'm having a problem binding a DataReader to a DataGrid. If it makes any difference my IDE is MS Visual Web Developer 2005 Express Edition.

System.Data.OleDb.OleDbConnection dbConnection = null;
string strSQL = "SELECT certID, firstName, lastName, OACert, OCCert, initialCertDate, recertDate1, recertDate2, recertDate3, recertDate4, recertDate5, recertDate5, recertDate6, decertDate, decertReason FROM cert INNER JOIN users ON cert.userID = users.userID ORDER BY lastName ASC, firstName ASC";
System.Data.OleDb.OleDbDataReader dr = null;
System.Data.OleDb.OleDbCommand dbCmd = null;
try
{
   dbConnection = new System.Data.OleDb.OleDbConnection(MyCommon.GetDatabaseString("pts"));
   dbConnection.Open();
   dbCmd = new System.Data.OleDb.OleDbCommand(strSQL, dbConnection);
   dr = dbCmd.ExecuteReader();
   dgCertsAdmin.DataSource = dr;
   dgCertsAdmin.DataBind()
}
finally
{
   if (!dbConnection.Equals(null))
      if (dbConnection.State.Equals(System.Data.ConnectionState.Open))
         dbConnection.Close();
}

And when I try to run it I get the following error: "Invalid attempt to FieldCount when reader is closed."

Any ideas what I'm doing wrong? Thanks for the help.

  • 1 Contributor
  • 1 Reply
  • 208 Views
  • 15 Hours Discussion Span
  • Latest Post Latest Post by jclast
Member Avatar for jclast

I gave up and rewrote the page.

The code works as I posted above.

Weird, but I'll take it.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.