Post
Ask Question
Able Alias

Able Alias

  • NA
  • 3
  • 10.9k

"No data exists for the row/column." exception message throwing

Jun 25 2011 4:34 AM

While executing the following code in Asp.net with C#,getting an exception like "No data exists for the row/column."

OdbcConnection DbConnection = new OdbcConnection(ConfigurationManager.AppSettings["ConnectionStr"]);
DbConnection.Close();
string cmdText = "SELECT Team_ID FROM team_details WHERE Team_Code=?";
OdbcCommand cmd = new OdbcCommand(cmdText, DbConnection);

cmd.Parameters.Add("?Code", OdbcType.VarChar).Value = tbCode.Text; DbConnection.Open(); OdbcDataReader DR = cmd.ExecuteReader();

DR.Read();
if (DR.GetValue(0) != DBNull.Value)
{ args.IsValid = false; } else { args.IsValid = true; } DbConnection.Close();

I'm using Visual Studio 2008 and MySQL. and  MySql ODBC connector 5.1 and MDAC2.8.

Please guide me how to resolve this.


Answers (3)