protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { // string id = kod.getDataCell("select ogr_id from ogrenci WHERE ogr_no = " + Request.QueryString["no"]); DataRow dr = kod.GetDataRow("Select * from ogrenci WHERE ogr_no =" + Request.QueryString["no"]); txtAd.Text = dr[1].ToString(); txtSoyadi.Text = dr[4].ToString(); txtOgrNo.Text = dr[2].ToString(); txtOkul.Text = dr[3].ToString(); txtBolum.Text = dr[5].ToString(); txtFakulte.Text = dr[6].ToString(); txtNotOrt.Text = dr[7].ToString(); txtTel.Text = dr[8].ToString(); txtAdres.Text = dr[9].ToString(); txtEposta.Text = dr[10].ToString(); txtOgrSicil.Text = dr[11].ToString(); txtSifre.Text = dr[12].ToString(); DataTable pp = kod.GetDataTable("select ogr_resimi from ogrenci WHERE ogr_no =" + Request.QueryString["no"]); RepeaterOgrResim.DataSource = pp; RepeaterOgrResim.DataBind(); DataTable cv = kod.GetDataTable("select ogr_cv from ogrenci WHERE ogr_no =" + Request.QueryString["no"]); RepeaterCV.DataSource = cv; RepeaterCV.DataBind(); } }
protected void Page_Load(object sender, EventArgs e) { RepeaterStajyerDetay.DataSource = kod.GetDataTable("SELECT * FROM [stajyer] WHERE stajyer_id=" + Request.QueryString["stajyerId"]); RepeaterStajyerDetay.DataBind(); DataTable pp = kod.GetDataTable("select ogr_resim from stajyer WHERE stajyer_id =" + Request.QueryString["stajyerId"]); RepeaterOgrResim.DataSource = pp; RepeaterOgrResim.DataBind(); DataTable cv = kod.GetDataTable("select ogr_cv from stajyer WHERE stajyer_id =" + Request.QueryString["stajyerId"]); RepeaterCV.DataSource = cv; RepeaterCV.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { RepeaterOgrenciDetay.DataSource = kod.GetDataTable("SELECT * FROM [ogrenci] WHERE ogr_id=" + Request.QueryString["ogrId"]); RepeaterOgrenciDetay.DataBind(); DataTable pp = kod.GetDataTable("select ogr_resimi from ogrenci WHERE ogr_id =" + Request.QueryString["ogrId"]); RepeaterOgrResim.DataSource = pp; RepeaterOgrResim.DataBind(); DataTable cv = kod.GetDataTable("select ogr_cv from ogrenci WHERE ogr_id =" + Request.QueryString["ogrId"]); RepeaterCV.DataSource = cv; RepeaterCV.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { //try //{ string StajKayitlimi = kod.getDataCell("select kurum_adi from stajyer WHERE ogr_no =" + Request.QueryString["no"]); Label1.Text = StajKayitlimi; if (Label1.Text == "") { PanelStajKaydet.Visible = true; Label1.Text = "Staj Yeri Seçmediniz"; ButtonStajİptal.Visible = false; } else { PanelStajKaydet.Visible = false; Label1.Text = StajKayitlimi; } //} //catch (Exception) //{ // //Label1.Text = "Kayıt Yok"; //} if (!Page.IsPostBack) { DataRow dr = kod.GetDataRow("Select * from ogrenci WHERE ogr_no =" + Request.QueryString["no"]); txtAd.Text = dr[1].ToString(); txtSoyadi.Text = dr[4].ToString(); txtOgrNo.Text = dr[2].ToString(); txtOkul.Text = dr[3].ToString(); txtBolum.Text = dr[5].ToString(); txtNotOrt.Text = dr[7].ToString(); txtTel.Text = dr[8].ToString(); txtEposta.Text = dr[11].ToString(); txtOgrSicil.Text = dr[11].ToString(); string danismanAd = kod.getDataCell("select hoca_adi from hoca WHERE sicil_no = '" + dr[11].ToString() + "'"); string danismanSoyad = kod.getDataCell("select hoca_soyadi from hoca WHERE hoca_adi = '" + danismanAd + "'"); txtDanısman.Text = danismanAd + " " + danismanSoyad; DataTable dt = kod.GetDataTable("SELECT * from kurum"); DropDownListKurumlar.DataSource = dt; DropDownListKurumlar.DataValueField = "kurum_kodu"; DropDownListKurumlar.DataTextField = "kurum_adi"; DropDownListKurumlar.DataBind(); LabelKurumKodunuz.Text = DropDownListKurumlar.SelectedItem.Value; DataRow kurum = kod.GetDataRow("Select * from kurum WHERE kurum_kodu = '" + LabelKurumKodunuz.Text + "' "); LabelKurumTel.Text = kurum[3].ToString(); LabelKurumEPosta.Text = kurum[4].ToString(); DataTable pp = kod.GetDataTable("select ogr_resimi from ogrenci WHERE ogr_no =" + Request.QueryString["no"]); RepeaterOgrResim.DataSource = pp; RepeaterOgrResim.DataBind(); DataTable cv = kod.GetDataTable("select ogr_cv from ogrenci WHERE ogr_no =" + Request.QueryString["no"]); RepeaterCV.DataSource = cv; RepeaterCV.DataBind(); } }