public sehir sehirGetirId(int sehirId)
        {
            sehir s = new sehir();

            try
            {
                SqlCommand com = new SqlCommand("select * from Sehir where SehirId = @shrId  order by SehirAd", con);
                com.Parameters.AddWithValue("@shrId", sehirId);
                com.CommandType = CommandType.Text;

                con.Open();
                SqlDataReader dr = com.ExecuteReader();
                while (dr.Read())
                {
                    s.SehirId   = Convert.ToInt32(dr["SehirId"]);
                    s.SehirAd   = dr["SehirAd"].ToString();
                    s.PostaKodu = Convert.ToInt32(dr["PostaKodu"]);
                }
                dr.Close();
            }
            catch (Exception ex)
            {
            }
            finally
            {
                con.Close();
            }
            return(s);
        }
        public List <sehir> sehirGetirTum()
        {
            List <sehir> sehirler = new List <sehir>();

            try
            {
                SqlCommand com = new SqlCommand("select * from Sehir  order by SehirAd", con);
                com.CommandType = CommandType.Text;

                con.Open();
                SqlDataReader dr = com.ExecuteReader();
                while (dr.Read())
                {
                    sehir s = new sehir();
                    s.SehirId   = Convert.ToInt32(dr["SehirId"]);
                    s.SehirAd   = dr["SehirAd"].ToString();
                    s.PostaKodu = Convert.ToInt32(dr["PostaKodu"]);
                    sehirler.Add(s);
                }
                dr.Close();
            }
            catch (Exception ex)
            {
            }
            finally
            {
                con.Close();
            }
            return(sehirler);
        }