void metot1()
{
var degerler = from x in db.TBLCARI
select new
{
x.ID,
x.AD,
x.SOYAD,
x.IL,
x.ILCE,
};
gridControl1.DataSource = degerler.ToList();
labelControl12.Text = db.TBLCARI.Count().ToString();
lookUpEdit1.Properties.DataSource = (from x in db.TBLILLER
select new
{
x.id,
x.sehir,
}).ToList();
labelControl16.Text = db.TBLCARI.Select(x => x.IL).Distinct().Count().ToString();
labelControl14.Text = db.TBLCARI.Select(x => x.ILCE).Distinct().Count().ToString();
labelControl18.Text = db.maksil().FirstOrDefault();
}