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.
Suthish NairPosted Jun 25, 2011, 7:37 AM
//if(DR.HasRows)
//{
while(DR.Read())
{
if (DR.GetValue(0) != DBNull.Value)
{ args.IsValid = false; } else { args.IsValid = true; }
}
//}
Able AliasPosted Jun 26, 2011, 12:55 AM
Sam HobbsPosted Jun 26, 2011, 12:51 AM