IndexOutOfRangeException was unhandled
Bonjour,
Pouvez-vous me dire ce qui n'est pas correcte dans ce code svp:
Code:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32
| public static string GetNumber(string sFilter)
{
string number = string.Empty;
try
{
conn.Open();
SqlCommand cmd = new SqlCommand("SELECT MAX(FIELD1) FROM TABLE WHERE FIELD1 LIKE '@FILTER%'", cnx);
SqlParameter param = new SqlParameter();
param.ParameterName = "@FILTER";
param.Value = sFilter;
cmd.Parameters.Add(param);
SqlDataReader rdr = cmd.ExecuteReader();
if(rdr.HasRows == true)
{
number= rdr["FIELD1"].ToString();
}
rdr.Close();
cnx.Close();
return number;
}
catch (Exception e)
{
throw e;
}
} |
Merci,