using System; using System.Collections.Generic; using System.Data; using System.Data.SqlClient; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; public partial class frmViewStudentRegistrationForm : System.Web.UI.Page { SqlConnection sqlConn = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["RSIC"].ConnectionString); SqlDataAdapter sda = null; DataSet ds = null; string strStudentID; protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { strStudentID = Request.QueryString["ID"]; if (strStudentID != "") { FillStudentRegistrationDetails(strStudentID); } } } void FillStudentRegistrationDetails(string StudentID) { if (StudentID != "") { sqlConn.Open(); string strQuery = "SELECT AdmissionID as OrderID, [StudentName],[EduQua],[FatherName],[Address],[City],[State], " + " [Pincode] ,[ResidenceNo],[OfficeNo],[MobileNo],[EmailId], " + " [BScBanFin],[BScAccFin],[BscBuss],[BscEco],[BScEcoMan],[DipEco],[BscMana] FROM [StudentRegistraion] where AdmissionID = '" + StudentID + "' "; sda = new SqlDataAdapter(strQuery,sqlConn); ds = new DataSet(); sda.Fill(ds); if (ds.Tables[0].Rows.Count > 0) { lblStudentName.Text = Convert.ToString(ds.Tables[0].Rows[0]["StudentName"]); lblqua.Text = Convert.ToString(ds.Tables[0].Rows[0]["EduQua"]); lblFathersName.Text = Convert.ToString(ds.Tables[0].Rows[0]["FatherName"]); lblAddress.Text = Convert.ToString(ds.Tables[0].Rows[0]["Address"]); lblCity.Text = Convert.ToString(ds.Tables[0].Rows[0]["City"]); lblState.Text = Convert.ToString(ds.Tables[0].Rows[0]["State"]); lblPincode.Text = Convert.ToString(ds.Tables[0].Rows[0]["Pincode"]); lblResidence.Text = Convert.ToString(ds.Tables[0].Rows[0]["ResidenceNo"]); lblOffice.Text = Convert.ToString(ds.Tables[0].Rows[0]["OfficeNo"]); lblMobileNo.Text = Convert.ToString(ds.Tables[0].Rows[0]["MobileNo"]); lblEmail.Text = Convert.ToString(ds.Tables[0].Rows[0]["EmailId"]); lblGrade.Text = Convert.ToString(ds.Tables[0].Rows[0]["BScBanFin"]); lblAcademicYear.Text = Convert.ToString(ds.Tables[0].Rows[0]["BScAccFin"]); lblPassportType.Text = Convert.ToString(ds.Tables[0].Rows[0]["BscBuss"]); lblOrder1.Text = Convert.ToString(ds.Tables[0].Rows[0]["BscEco"]); lblFromWhere.Text = Convert.ToString(ds.Tables[0].Rows[0]["BScEcoMan"]); lblParentsOccupation1.Text = Convert.ToString(ds.Tables[0].Rows[0]["DipEco"]); lblParentsDesignation1.Text = Convert.ToString(ds.Tables[0].Rows[0]["BscMana"]); } else { Response.Write(""); } } } protected void dtnPrint_Click(object sender, EventArgs e) { dtnPrint.Visible = false; } }