using System; using System.Collections; using System.Configuration; using System.Data; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.HtmlControls; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Data.SqlClient; public partial class stu_Student : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { string xadmin = Session["admin"].ToString(); if (xadmin == "") Response.Redirect("/mt/Default.aspx"); if (xadmin == "True") { DataBind(); } } } protected void btnUse_Click(object sender, EventArgs e) { if (txtSearch.Text=="") { lblResult.Text = "من فضلك أدخل الرقم الجامعي حتى يتم البحث"; return; } SDtbl0.SelectCommand = "SELECT tbl_StuShow.Name, tbl_StuShow.Stu_No, tbl_StuShow.Stu_Mobil, College.Name AS Coll, "+ "Universities.Name AS Uni, Level.Name AS Level, tbl_StuShow.Code , tbl_StuShow.Stu_Wechat FROM tbl_StuShow INNER JOIN College ON " + "tbl_StuShow.Stu_Fac = College.Code INNER JOIN Universities ON tbl_StuShow.Stu_Uni = Universities.Code INNER JOIN "+ "Level ON tbl_StuShow.Stu_Level = Level.Code " + " where tbl_StuShow.Stu_No=@User"; SDtbl0.SelectParameters.Add("User", txtSearch.Text); grdtbl0.DataBind(); } protected void grdtbl0_SelectedIndexChanged(object sender, EventArgs e) { Response.Redirect("Detail.aspx?Code=" + grdtbl0.SelectedRow.Cells[0].Text.ToString() + "&Name=" + grdtbl0.SelectedRow.Cells[1].Text.ToString()); } }