protected void btngo_Click(object sender, EventArgs e) { try { if (txtbatch.Text != "--Select--" || chklsbatch.Items.Count != null) { int itemcount = 0; for (itemcount = 0; itemcount < chklsbatch.Items.Count; itemcount++) { if (chklsbatch.Items[itemcount].Selected == true) { if (sqlbatch == "") { sqlbatch = "'" + chklsbatch.Items[itemcount].Value.ToString() + "'"; } else { sqlbatch = sqlbatch + "," + "'" + chklsbatch.Items[itemcount].Value.ToString() + "'"; } } } if (sqlbatch != "") { sqlbatch = " in(" + sqlbatch + ")"; sqlbatchquery = " and r.batch_year " + sqlbatch + ""; } else { sqlbatchquery = " "; } } if (txtdegree.Text != "---Select---" || chklstdegree.Items.Count != null) { int itemcount = 0; for (itemcount = 0; itemcount < chklstdegree.Items.Count; itemcount++) { if (chklstdegree.Items[itemcount].Selected == true) { if (strdegree == "") { strdegree = "'" + chklstdegree.Items[itemcount].Value.ToString() + "'"; } else { strdegree = strdegree + "," + "'" + chklstdegree.Items[itemcount].Value.ToString() + "'"; } } } if (strdegree != "") { sqldegree = " in(" + strdegree + ")"; sqldegree = " and r.degree_code " + strdegree + ""; } else { sqldegree = " "; } } if (txtbranch.Text != "---Select---" || chklstbranch.Items.Count != null) { int itemcount = 0; for (itemcount = 0; itemcount < chklstbranch.Items.Count; itemcount++) { if (chklstbranch.Items[itemcount].Selected == true) { if (sqlbranch == "") { sqlbranch = "'" + chklstbranch.Items[itemcount].Value.ToString() + "'"; } else { sqlbranch = sqlbranch + "," + "'" + chklstbranch.Items[itemcount].Value.ToString() + "'"; } } } if (sqlbranch != "") { sqlbranch = " in(" + sqlbranch + ")"; sqlbranchquery = " and r.degree_code " + sqlbranch + ""; } else { sqlbranchquery = " "; } } if (txtsec.Text != "---Select---" || chklssec.Items.Count != null) { int itemcount = 0; int cnt = 0; for (itemcount = 0; itemcount < chklssec.Items.Count; itemcount++) { if (chklssec.Items[itemcount].Selected == true) { cnt++; if (sqlsec == "") { sqlsec = "'" + chklssec.Items[itemcount].Value.ToString() + "'"; } else { sqlsec = sqlsec + "," + "'" + chklssec.Items[itemcount].Value.ToString() + "'"; } } } if (cnt == chklssec.Items.Count) { if (sqlsec == "") { sqlsec = "''"; } else { sqlsec = sqlsec + "," + "''"; } } if (sqlsec != "") { sqlsec = " in(" + sqlsec + ")"; sqlsecquery = " and isnull(r.sections,'') " + sqlsec + ""; } else { sqlsecquery = " "; } } studtype = ddlstutype.Text;//added by rajasekar 10/09/2018 if (sqldegree != " " || sqlbranchquery != " ") { Fpstudenttransport.Visible = true; Fpstudenttransport.Sheets[0].RowCount = 0; Fpstudenttransport.Sheets[0].ColumnCount = 0; Fpstudenttransport.Sheets[0].ColumnHeader.Visible = true; Fpstudenttransport.Sheets[0].ColumnCount++; Fpstudenttransport.Sheets[0].AutoPostBack = true; Fpstudenttransport.Sheets[0].ColumnHeader.RowCount = 1; Fpstudenttransport.Sheets[0].ColumnCount = 11; Fpstudenttransport.Sheets[0].RowCount = 0; Fpstudenttransport.Sheets[0].PageSize = 5000; ds2.Dispose(); ds2.Reset(); ds2 = d2.Bindstudenttransport(sqlbatchquery, sqlbranchquery, sqlsecquery, studtype);//modified by rajasekar 10/09/2018 if (ds2.Tables[0].Rows.Count > 0) { errmsg.Visible = false; lblnorec.Visible = false; Fpstudenttransport.Visible = true; //btnxl.Visible = true; //btnprintmaster.Visible = true; Fpstudenttransport.Sheets[0].ColumnHeader.Cells[0, 0].Text = "S.No"; Fpstudenttransport.Sheets[0].ColumnHeader.Cells[0, 1].Text = "Roll No"; Fpstudenttransport.Sheets[0].ColumnHeader.Cells[0, 2].Text = "Reg No"; Fpstudenttransport.Sheets[0].ColumnHeader.Cells[0, 3].Text = "Student Name"; Fpstudenttransport.Sheets[0].ColumnHeader.Cells[0, 4].Text = "Gender"; Fpstudenttransport.Sheets[0].ColumnHeader.Cells[0, 5].Text = "Student Type"; Fpstudenttransport.Sheets[0].ColumnHeader.Cells[0, 6].Text = "Route"; Fpstudenttransport.Sheets[0].ColumnHeader.Cells[0, 7].Text = "Transport No"; Fpstudenttransport.Sheets[0].ColumnHeader.Cells[0, 8].Text = "Starting Point"; Fpstudenttransport.Sheets[0].ColumnHeader.Cells[0, 9].Text = "Hostel Name"; Fpstudenttransport.Sheets[0].ColumnHeader.Cells[0, 10].Text = "Room No"; Fpstudenttransport.Sheets[0].Columns[0].Width = 50; Fpstudenttransport.Sheets[0].Columns[1].Width = 150; Fpstudenttransport.Sheets[0].Columns[2].Width = 150; Fpstudenttransport.Sheets[0].Columns[3].Width = 250; Fpstudenttransport.Sheets[0].Columns[4].Width = 80; Fpstudenttransport.Sheets[0].Columns[5].Width = 120; Fpstudenttransport.Sheets[0].Columns[6].Width = 50; Fpstudenttransport.Sheets[0].Columns[7].Width = 50; Fpstudenttransport.Sheets[0].Columns[8].Width = 80; Fpstudenttransport.Sheets[0].Columns[9].Width = 200; Fpstudenttransport.Sheets[0].Columns[10].Width = 80; int sno = 0; for (int rolcount = 0; rolcount < ds2.Tables[0].Rows.Count; rolcount++) { sno++; Fpstudenttransport.Sheets[0].RowCount = Fpstudenttransport.Sheets[0].RowCount + 1; Fpstudenttransport.Sheets[0].Rows[Fpstudenttransport.Sheets[0].RowCount - 1].Font.Bold = false; Fpstudenttransport.Sheets[0].Cells[Fpstudenttransport.Sheets[0].RowCount - 1, 0].Text = Convert.ToString(sno); Fpstudenttransport.Sheets[0].Cells[Fpstudenttransport.Sheets[0].RowCount - 1, 0].HorizontalAlign = HorizontalAlign.Center; Fpstudenttransport.Sheets[0].Cells[Fpstudenttransport.Sheets[0].RowCount - 1, 1].Text = ds2.Tables[0].Rows[rolcount]["Roll_No"].ToString(); Fpstudenttransport.Sheets[0].Cells[Fpstudenttransport.Sheets[0].RowCount - 1, 1].HorizontalAlign = HorizontalAlign.Left; Fpstudenttransport.Sheets[0].Cells[Fpstudenttransport.Sheets[0].RowCount - 1, 2].CellType = new FarPoint.Web.Spread.TextCellType(); Fpstudenttransport.Sheets[0].Cells[Fpstudenttransport.Sheets[0].RowCount - 1, 2].Text = ds2.Tables[0].Rows[rolcount]["Reg_No"].ToString();; Fpstudenttransport.Sheets[0].Cells[Fpstudenttransport.Sheets[0].RowCount - 1, 2].HorizontalAlign = HorizontalAlign.Left; Fpstudenttransport.Sheets[0].Cells[Fpstudenttransport.Sheets[0].RowCount - 1, 3].Text = ds2.Tables[0].Rows[rolcount]["Stud_Name"].ToString(); Fpstudenttransport.Sheets[0].Cells[Fpstudenttransport.Sheets[0].RowCount - 1, 3].HorizontalAlign = HorizontalAlign.Left; Fpstudenttransport.Sheets[0].Cells[Fpstudenttransport.Sheets[0].RowCount - 1, 4].Text = ds2.Tables[0].Rows[rolcount]["Gender"].ToString(); Fpstudenttransport.Sheets[0].Cells[Fpstudenttransport.Sheets[0].RowCount - 1, 4].HorizontalAlign = HorizontalAlign.Left; Fpstudenttransport.Sheets[0].Cells[Fpstudenttransport.Sheets[0].RowCount - 1, 5].Text = ds2.Tables[0].Rows[rolcount]["Stud_Type"].ToString(); Fpstudenttransport.Sheets[0].Cells[Fpstudenttransport.Sheets[0].RowCount - 1, 5].HorizontalAlign = HorizontalAlign.Left; Fpstudenttransport.Sheets[0].Cells[Fpstudenttransport.Sheets[0].RowCount - 1, 6].Text = ds2.Tables[0].Rows[rolcount]["Bus_RouteID"].ToString(); Fpstudenttransport.Sheets[0].Cells[Fpstudenttransport.Sheets[0].RowCount - 1, 6].HorizontalAlign = HorizontalAlign.Center; Fpstudenttransport.Sheets[0].Cells[Fpstudenttransport.Sheets[0].RowCount - 1, 7].Text = ds2.Tables[0].Rows[rolcount]["VehID"].ToString(); Fpstudenttransport.Sheets[0].Cells[Fpstudenttransport.Sheets[0].RowCount - 1, 7].HorizontalAlign = HorizontalAlign.Center; Fpstudenttransport.Sheets[0].Cells[Fpstudenttransport.Sheets[0].RowCount - 1, 8].Text = ds2.Tables[0].Rows[rolcount]["Boarding"].ToString(); Fpstudenttransport.Sheets[0].Cells[Fpstudenttransport.Sheets[0].RowCount - 1, 8].HorizontalAlign = HorizontalAlign.Left; Fpstudenttransport.Sheets[0].Cells[Fpstudenttransport.Sheets[0].RowCount - 1, 9].Text = ds2.Tables[0].Rows[rolcount]["Hostel_Name"].ToString(); Fpstudenttransport.Sheets[0].Cells[Fpstudenttransport.Sheets[0].RowCount - 1, 9].HorizontalAlign = HorizontalAlign.Left; Fpstudenttransport.Sheets[0].Cells[Fpstudenttransport.Sheets[0].RowCount - 1, 10].Text = ds2.Tables[0].Rows[rolcount]["Room_Name"].ToString(); Fpstudenttransport.Sheets[0].Cells[Fpstudenttransport.Sheets[0].RowCount - 1, 10].HorizontalAlign = HorizontalAlign.Left; } } else { lblnorec.Visible = true; Fpstudenttransport.Visible = false; //btnxl.Visible = false; //btnprintmaster.Visible = false; } } else { Fpstudenttransport.Visible = false; errmsg.Visible = true; errmsg.Text = "Please Select Branch and Degree"; } } catch (Exception ex) { errmsg.Text = ex.ToString(); } }