[ابو ليلى]

السلام عليكم و رحمة الله و بركاته
جربه بهذا الشكل

PHP كود :

       public  int GetMaxHijriID(int hijriYear)
        {
            try
            {

                object maxHijriID = null;
                using (OleDbCommand comm = new OleDbCommand("SELECT MAX([HijriID]) FROM [Tab1] WHERE [HijriYear] = @HijriYear ", con))
                {
                    comm.Parameters.AddWithValue("@HijriYear", hijriYear);
                    con.Open();
                    maxHijriID = comm.ExecuteScalar();
                    con.Close();
                }
                maxHijriID = (maxHijriID.GetType() == typeof(System.DBNull)) ? 1 : maxHijriID;
                return int.Parse(Convert.ToString(maxHijriID));
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
                return -1;
            }



        }