public void GetdatafromStudentRegistration()
{
SqlConnection con = ConnectionUtil.getConnection();
try
{
SqlDataReader dr = new Dynamic().ExecuteDataReader(con, Procs.GetdatafromStudentRegistration, Convert.ToString(Session["StudentRN"]).Trim());
if (dr != null)
{
if (dr.HasRows)
{
while (dr.Read())
{
if (!string.IsNullOrEmpty(Convert.ToString(dr["Id"])))
{
HdId.Value = Convert.ToString(dr["Id"]);
}
if (!string.IsNullOrEmpty(Convert.ToString(dr["Name"])))
{
txtname.Text = Convert.ToString(dr["Name"]);
}
if (!string.IsNullOrEmpty(Convert.ToString(dr["StudentRegistrationNumber"])))
{
txtstudentrn.Text = Convert.ToString(dr["StudentRegistrationNumber"]);
}
if (!string.IsNullOrEmpty(Convert.ToString(dr["COLLEGENAME"])))
{
txtcollegename.Text = Convert.ToString(dr["COLLEGENAME"]);
}
if (Convert.ToString(dr["GENDER"]) == "1")
{
rad_MGender.Checked = true;
rad_FGender.Checked = false;
}
else
{
rad_MGender.Checked = false;
rad_FGender.Checked = true;
}
DropDownList1.SelectedValue = dr["BRANCHNAME"].ToString();
if (!string.IsNullOrEmpty(Convert.ToString(dr["PHONENUMBER"])))
{
txtphonenumber.Text = Convert.ToString(dr["PHONENUMBER"]);
}
if (!string.IsNullOrEmpty(Convert.ToString(dr["EMAILID"])))
{
txtemailid.Text = Convert.ToString(dr["EMAILID"]);
}
if (!string.IsNullOrEmpty(Convert.ToString(dr["Comments"])))
{
txtcomments.Text = Convert.ToString(dr["Comments"]);
}
}
}
dr.Close();
dr.Dispose();
}
}
catch (Exception)
{
throw;
}
finally
{
if (con.State == ConnectionState.Open)
{
con.Close();
}
}
}
