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();
}
}
