Dataset , problem , SQL
JEg har følgende data set , og får en MySql.Data.MySqlClient.MySqlException: Parameter '?AarGROUP' must be defined. ( det virkede fint indtil jeg satte aar ind , og hvis jeg smider den direkte i mysqlen viser den også data så hvad har jeg glemt)public DataSet GetResultCalculationAmounts(int typeID,int Aar)
{
MySqlConnection connection = Connection.GetConnection();
StringBuilder sql = new StringBuilder(4);
sql.Append("SELECT display_name, YEAR(al.date),sum(al.credit)-sum(al.debet) as sum FROM s_account a, s_account_line al ");
sql.Append("WHERE a.account_number = al.fk_account_number AND a.fk_account_type_id = ?TypeID AND YEAR(al.date)=?Aar");
sql.Append("GROUP BY a.fk_account_number");
sql.Append(";");
MySqlCommand cmd = new MySqlCommand(sql.ToString(), connection);
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add("?TypeID", MySqlDbType.Int32).Value = typeID;
//cmd.Parameters.Add("?Aar", MySqlDbType.Int32).Value = Aar;
MySqlDataAdapter adap = new MySqlDataAdapter(cmd);
DataSet ds = new DataSet("ResultCalculationAmounts");
adap.Fill(ds);
return ds;
}