public void sehirUlkeUniBolum()
{
FillDDL();
dtIl = sql.crud.Sorgu("select * from Sehirler order by SehirAdi");
DropDownListAdresIl.DataSource = dtIl;
DropDownListAdresIl.DataTextField = "SehirAdi";
DropDownListAdresIl.DataBind();
dtDil = sql.crud.Sorgu("select * from Languages order by Language");
DropDownListdil.DataSource = dtDil;
DropDownListdil.DataTextField = "Language";
DropDownListdil.DataBind();
dtDil = sql.crud.Sorgu("select * from Languages order by Language");
DropDownListDil2.DataSource = dtDil;
DropDownListDil2.DataTextField = "Language";
DropDownListDil2.DataBind();
dtUlke = sql.crud.Sorgu("select * from Ulkeler order by UlkeAdi");
DropDownListulke1.DataSource = dtUlke;
DropDownListulke1.DataTextField = "UlkeAdi";
DropDownListulke1.DataBind();
dtSehir1 = sql.crud.Sorgu("select * from Sehirler order by SehirAdi");
DropDownList1.DataSource = dtSehir1;
DropDownList1.DataTextField = "SehirAdi";
DropDownList1.DataBind();
dtSehir1 = sql.crud.Sorgu("select * from Sehirler order by SehirAdi");
DropDownList2.DataSource = dtSehir1;
DropDownList2.DataTextField = "SehirAdi";
DropDownList2.DataBind();
dtSehir1 = sql.crud.Sorgu("select * from Sehirler order by SehirAdi");
DropDownListlisesehir.DataSource = dtSehir1;
DropDownListlisesehir.DataTextField = "SehirAdi";
DropDownListlisesehir.DataBind();
dtSehir1 = sql.crud.Sorgu("select * from Sehirler order by SehirAdi");
DropDownList3.DataSource = dtSehir1;
DropDownList3.DataTextField = "SehirAdi";
DropDownList3.DataBind();
dtuni = sql.crud.Sorgu("select * from Universiteler order by Universiteler");
DropDownListuniadi.DataSource = dtuni;
DropDownListuniadi.DataTextField = "Universiteler";
DropDownListuniadi.DataBind();
dtbolum = sql.crud.Sorgu("select * from Bolumler order by Bolumadi");
DropDownListbolumadi.DataSource = dtbolum;
DropDownListbolumadi.DataTextField = "Bolumadi";
DropDownListbolumadi.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
int adminid = Convert.ToInt32(Session["kod"]);
DataRow drAdmin2 = veritabani.GetDataRow("select * from giris_bilgileri where kod=" + adminid);
DataRow drtoptanci2 = veritabani.GetDataRow("select * from toptanci where kod=" + adminid);
if (adminid == 0 || drtoptanci2 == null)
{
Session.Clear();
Session.Abandon();
Response.Redirect("~/login.aspx");
}
else
{
DataRow drAdmin = veritabani.GetDataRow("select * from giris_bilgileri where kod=" + adminid);
DataRow drtoptanci = veritabani.GetDataRow("select * from toptanci where kod=" + adminid);
if (!IsPostBack)
{
SqlConnection Conn = new SqlConnection(s);
SqlCommand Cmd = new SqlCommand("Select * From adres_il", Conn);
SqlDataAdapter DA = new SqlDataAdapter(Cmd);
DA.Fill(DS, "ad");
DropDownListAdresIl.DataSource = DS.Tables["ad"];
DropDownListAdresIl.DataTextField = "ad";
DropDownListAdresIl.DataValueField = "kod";
DropDownListAdresIl.DataBind();
DropDownListAdresIl.Items.Insert(0, "Seçiniz");
DropDownListIlce.Items.Insert(0, "Seçiniz");
String kod2 = (String)Session["kod"];
DataRow toptanciDB = veritabani.GetDataRow("select * from toptanci where kod = '" + kod2 + "'");
DataRow adresilDB = veritabani.GetDataRow("select * from adres_il where kod = '" + toptanciDB["adres_il"].ToString() + "'");
DataRow adresilceDB = veritabani.GetDataRow("select * from adres_ilce where kod = '" + toptanciDB["adres_ilce"].ToString() + "'");
System.Diagnostics.Debug.WriteLine(adresilDB["ad"]);
LabelAd.Text = toptanciDB["ad"].ToString();
LabelSoyad.Text = toptanciDB["soyad"].ToString();
TextBox1.Text = toptanciDB["adres"].ToString();
LabelCepTel.Text = toptanciDB["cep_tel"].ToString();
LabelEvTel.Text = toptanciDB["is_tel"].ToString();
LabelAdresIl.Text = adresilDB["ad"].ToString();
LabelAdresIlce.Text = adresilceDB["ad"].ToString();
DataRow loginDB = veritabani.GetDataRow("select * from giris_bilgileri where kod = '" + kod2 + "'");
LabelMail.Text = loginDB["email"].ToString();
// LabelSifre.Text = loginDB["sifre"].ToString();
}
}
}
