protected void Button2_Click(object sender, EventArgs e)
{
string tableExtension = DropDownList2.SelectedValue.ToLower();
//for show data
con.Open();
string sql = "SELECT * FROM apply" + tableExtension + " inner join dbbl,student where apply" + tableExtension + ".mobile_no = dbbl.mobile_no and apply" + tableExtension + ".tx_id = dbbl.tx_id and student.ROLL_NO=dbbl.hsc_roll and apply" + tableExtension + ".serialNo ='" + TextBox1.Text + "' ";
//SELECT * FROM `student` WHERE `BOARD_NAME`='RAJSHAHI' and `ROLL_NO`= '135323' and `PASS_YEAR`='2011'
MySqlCommand cmd = new MySqlCommand(sql, con);
MySqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
string serial = reader.GetString(0).ToString();
string name = reader.GetString(12).ToString();
string fname = reader.GetString(13).ToString();
string mname = reader.GetString(14).ToString();
string hscroll = reader.GetString(17).ToString();
string imgpath = reader.GetString(1).ToString() + "_" + reader.GetString(2).ToString() + ".jpg";
createAdmitPDF a = new createAdmitPDF();
a.createPDF(DropDownList2.SelectedValue, hscroll, serial, name, fname, mname, imgpath);
}
reader.Close();
con.Close();
//end show data
Response.Redirect("~/PDFs/Doc2.pdf");
}
public void showadmitcard(string unitName, Label lblName)
{
if (File.Exists(Server.MapPath("~/Images/") + mobileNoPanel7.Text + "_" + tx_idPanel7.Text + ".jpg"))
{
string studentImgPath = mobileNoPanel7.Text + "_" + tx_idPanel7.Text + ".jpg";
//mobileNoPanel7.Text+"_"+tx_idPanel7.Text+".jpg"
createAdmitPDF a = new createAdmitPDF();
a.createPDF(unitName, rollL.Text, lblName.Text, nameL.Text, f_nameL.Text, m_nameL.Text, studentImgPath);
Response.Redirect("~/PDFs/Doc2.pdf");
}
else
{
infoL.Visible = true;
infoL.Text = "Please Upload your own Image.";
infoL.Focus();
}
}