protected void btn_deptpartmentsave_Click(object sender, EventArgs e) { try { DataTable dt = new DataTable(); dt.Columns.Add("DeptCode"); dt.Columns.Add("DeptName"); DataRow dr; if (dptgrid.Rows.Count > 0) { for (int ik = 0; ik < dptgrid.Rows.Count; ik++) { if ((dptgrid.Rows[ik].FindControl("cbcheck") as CheckBox).Checked == true) { dr = dt.NewRow(); dr[0] = Convert.ToString((dptgrid.Rows[ik].FindControl("lbldeptcode") as Label).Text); dr[1] = Convert.ToString((dptgrid.Rows[ik].FindControl("lbldeptname") as Label).Text); dt.Rows.Add(dr); } } if (dt.Rows.Count > 0) { SelectdptGrid.DataSource = dt; SelectdptGrid.DataBind(); Newdiv.Visible = false; SelectdptGrid.Visible = true; } else { imgdiv2.Visible = true; lbl_alert.Text = "Please Select Any Record"; } } } catch { } }
protected void Fpspread1_render(object sender, EventArgs e) { try { if (check == true) { poperrjs.Visible = true; string activerow = ""; string activecol = ""; activerow = Fpspread1.ActiveSheetView.ActiveRow.ToString(); activecol = Fpspread1.ActiveSheetView.ActiveColumn.ToString(); collegecode = Session["collegecode"].ToString(); if (activerow.Trim() != "") { //year(); string storeacr = Convert.ToString(Fpspread1.Sheets[0].Cells[Convert.ToInt32(activerow), 1].Text); string storename = Convert.ToString(Fpspread1.Sheets[0].Cells[Convert.ToInt32(activerow), 2].Text); string Store_PK = Convert.ToString(Fpspread1.Sheets[0].Cells[Convert.ToInt32(activerow), 1].Tag); Session["StorePK"] = Convert.ToString(Store_PK); string year1 = Convert.ToString(Fpspread1.Sheets[0].Cells[Convert.ToInt32(activerow), 3].Text); string depcode = Convert.ToString(Fpspread1.Sheets[0].Cells[Convert.ToInt32(activerow), 4].Tag); txt_storename.Text = Convert.ToString(storename); txt_storeacr.Text = Convert.ToString(storeacr); txt_startyear.Text = year1; //if (year1.Trim() != "") //{ // int index = Convert.ToInt32(yearhash[Convert.ToString(year1)]); // ddl_startyear.SelectedIndex = index; //} if (depcode.Trim() != "" && depcode.Trim() != null) { string selectquery = "select Dept_Code as DeptCode ,Dept_Name as DeptName from Department where Dept_Code in (" + depcode + ") and college_code ='" + collegecode + "'"; ds.Clear(); ds = d2.select_method_wo_parameter(selectquery, "Text"); if (ds.Tables[0].Rows.Count > 0) { SelectdptGrid.DataSource = ds; SelectdptGrid.DataBind(); SelectdptGrid.Visible = true; } else { ds = null; SelectdptGrid.DataSource = ds; SelectdptGrid.DataBind(); SelectdptGrid.Visible = false; } } else { ds = null; SelectdptGrid.DataSource = ds; SelectdptGrid.DataBind(); SelectdptGrid.Visible = false; } btn_save.Visible = false; btn_update.Visible = true; btn_delete.Visible = true; } } } catch { } }