protected void ddlFile_SelectedIndexChanged(object sender, EventArgs e) { DataSet ds = new DataSet(); ds = (DataSet)ViewState["dataset"]; if (ds.Tables[0].Rows.Count > 0) { for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { if (ddlFile.SelectedValue.ToString() == ds.Tables[0].Rows[i]["FILE_NAME"].ToString()) { lblTotalRecord.Text = ds.Tables[0].Rows[i]["total_records"].ToString(); lblTotalFile.Attributes.Add("style", "visibility:visible;"); lblTotalRecord.Attributes.Add("style", "visibility:visible;"); } } } GridView1.DataSource = null; GridView1.DataBind(); GV_TransInfo.DataSource = null; GV_TransInfo.DataBind(); GV_AvalilableMatch.DataSource = null; GV_AvalilableMatch.DataBind(); Panel1.Visible = false; Panel2.Visible = false; Panel3.Visible = false; // btnSubmit.Attributes.Add("style", "visibility:hidden;"); lblTransaction.Attributes.Add("style", "visibility:hidden;"); lblFieldTrans.Attributes.Add("style", "visibility:hidden;"); lblMessage.Text = ""; }
private void loadGV_AvalilableMatch() { DataSet ds = new DataSet(); OracleParameter[] parms = new OracleParameter[10]; parms[0] = new OracleParameter(); parms[0] = _dbConfig.Oracle_Param("P_company_code", OracleType.VarChar, ParameterDirection.Input, ddlCompanyCode.SelectedValue.ToString()); parms[1] = new OracleParameter(); parms[1] = _dbConfig.Oracle_Param("P_FILE_NAME", OracleType.VarChar, ParameterDirection.Input, ddlFile.SelectedItem.ToString()); parms[2] = new OracleParameter(); parms[2] = _dbConfig.Oracle_Param("P_Trans_type", OracleType.VarChar, ParameterDirection.Input, ""); parms[3] = new OracleParameter(); parms[3] = _dbConfig.Oracle_Param("P_Rowid", OracleType.VarChar, ParameterDirection.Input, ROWID); parms[4] = new OracleParameter(); parms[4] = _dbConfig.Oracle_Param("p_bank_code", OracleType.VarChar, ParameterDirection.Input, ""); parms[5] = new OracleParameter(); parms[5] = _dbConfig.Oracle_Param("p_branch_code", OracleType.VarChar, ParameterDirection.Input, ""); parms[6] = new OracleParameter(); parms[6] = _dbConfig.Oracle_Param("P_Userid", OracleType.VarChar, ParameterDirection.Input, Session["U_NAME"].ToString());//Session["U_NAME"].ToString() parms[7] = new OracleParameter(); parms[7] = _dbConfig.Oracle_Param("P_type", OracleType.VarChar, ParameterDirection.Input, "11"); parms[8] = new OracleParameter(); parms[8] = _dbConfig.Oracle_Param("DATA_RESULTSET", OracleType.Cursor, ParameterDirection.Output, ""); parms[9] = new OracleParameter(); parms[9] = _dbConfig.Oracle_Param("v_retval", OracleType.VarChar, ParameterDirection.Output, ""); ds = _dbConfig.Oracle_GetDataSetSP("SP_Data_Segregation", parms); if (parms[9].Value.ToString() == "") { if (ds.Tables[0].Rows.Count > 0) { //DataTable dt = new DataTable(); //dt = ds.Tables[0]; // ViewState["TaskTable"] = dt; GV_AvalilableMatch.DataSource = ds; //// GridView1.PageSize = 20; GV_AvalilableMatch.DataBind(); lblMessage.Text = ""; lblTransaction.Text = ds.Tables[0].Rows.Count.ToString(); // btnSubmit.Attributes.Add("style", "visibility:visible;"); // lblFieldTrans.Attributes.Add("style", "visibility:visible;"); // lblTransaction.Attributes.Add("style", "visibility:visible;"); Panel3.Visible = true; } else { DataRow dr = ds.Tables[0].NewRow(); ds.Tables[0].Rows.Add(dr); GV_AvalilableMatch.DataSource = ds.Tables[0]; GV_AvalilableMatch.DataBind(); int Newcell = GV_AvalilableMatch.Rows[0].Cells.Count; GV_AvalilableMatch.Rows[0].Cells.Clear(); GV_AvalilableMatch.Rows[0].Cells.Add(new TableCell()); GV_AvalilableMatch.Rows[0].Cells[0].ColumnSpan = Newcell; GV_AvalilableMatch.Rows[0].Cells[0].HorizontalAlign = HorizontalAlign.Center; GV_AvalilableMatch.Rows[0].Cells[0].Text = "No data found."; Panel3.Visible = true; //btnSubmit.Attributes.Add("style", "visibility:hidden;"); //GV_AvalilableMatch.DataSource = null; //GV_AvalilableMatch.DataBind(); //lblMessage.Text = "No data found."; // lblTransaction.Text = ds.Tables[0].Rows.Count.ToString(); // lblFieldTrans.Attributes.Add("style", "visibility:hidden;"); // lblTransaction.Attributes.Add("style", "visibility:hidden;"); } } }