protected void GridView_Ratings_RowDataBound(object sender, GridViewRowEventArgs e) { try { JRA_Lib JRALib_Data = new JRA_Lib(); DataTable dt = new DataTable(); if (e.Row.RowType == DataControlRowType.DataRow) { int ID = UDFLib.ConvertToInteger(GridView_Ratings.DataKeys[e.Row.RowIndex].Value.ToString()); if ((e.Row.RowState & DataControlRowState.Edit) > 0) { DropDownList ddList = (DropDownList)e.Row.FindControl("ddlDisplayText"); dt = BLL_JRA_Work_Category.JRA_GET_RISK_TYPES(JRALib_Data); ddList.DataSource = dt; ddList.DataTextField = Convert.ToString(dt.Columns["Type_Display_Text"]); ddList.DataValueField = Convert.ToString(dt.Columns["Type_ID"]); ddList.DataBind(); ddList.Items.Insert(0, new ListItem("-Select-", "0")); DataRowView dr = e.Row.DataItem as DataRowView; //ddList.SelectedValue = dr["Risk_TYPE"].ToString(); ddList.Items.FindByValue(Convert.ToString(dr["Risk_Type"])).Selected = true; } } } catch { } }
protected void ClearFilter() { JRA_Lib lObjWC = new JRA_Lib(); lObjWC.Work_Categ_Parent_ID = null; lObjWC.Mode = 3; DataTable dtAllChilds = BLL_JRA_Work_Category.JRA_GET_WORK_CATEGORY_LIST(lObjWC); DataTable dtAllChildsCloned = dtAllChilds.Clone(); dtAllChildsCloned.Columns["Work_Categ_Value"].DataType = typeof(float); foreach (DataRow row in dtAllChilds.Rows) { dtAllChildsCloned.ImportRow(row); } DataView dv = dtAllChildsCloned.DefaultView; dv.Sort = "Work_Categ_Value"; dtAllChilds = dv.ToTable(); ddlChildWorkCateg.DataSource = dtAllChilds; ddlChildWorkCateg.DataTextField = "Work_Category_Display"; ddlChildWorkCateg.DataValueField = "Work_Categ_ID"; ddlChildWorkCateg.DataBind(); ddlChildWorkCateg.Items.Insert(0, new ListItem("-Select All-", "0")); ddlParentWorkCateg.SelectedIndex = 0; ddlChildWorkCateg.SelectedIndex = 0; }
private void Load_WorkCategory() { JRA_Lib JRALib_Data = new JRA_Lib(); JRALib_Data.Type_ID = 0; DataTable dt = BLL_JRA_Work_Category.JRA_GET_TYPE_LIST(JRALib_Data); }
protected void Search_WorkCategory() { int rowcount = ucCustomPagerItems.isCountRecord; int SearchRows = 0; int TotalRows = 0; JRA_Lib JRALib_Data = new JRA_Lib(); JRALib_Data.SearchText = txtfilter.Text.Trim(); JRALib_Data.SearchCate = ddlFiter.SelectedValue == "0" ? null : ddlFiter.SelectedValue; JRALib_Data.PageNumber = ucCustomPagerItems.CurrentPageIndex; JRALib_Data.PageSize = ucCustomPagerItems.PageSize; DataTable dt = BLL_JRA_Work_Category.JRA_SEARCH_WORK_CATEGORY(JRALib_Data); GridView_Category.DataSource = dt; GridView_Category.DataBind(); if (dt.Rows.Count > 0) { SearchRows = Convert.ToInt32(dt.Rows[0]["SearchRows"]); TotalRows = Convert.ToInt32(dt.Rows[0]["TotalRows"]); } if (ucCustomPagerItems.isCountRecord == 1) { rowcount = SearchRows; ucCustomPagerItems.CountTotalRec = Convert.ToString(TotalRows); ucCustomPagerItems.BuildPager(); } }
protected void GridView_Type_RowUpdating(object sender, GridViewUpdateEventArgs e) { JRA_Lib JRALib_Data = new JRA_Lib(); try { int ID = UDFLib.ConvertToInteger(GridView_Type.DataKeys[e.RowIndex].Values[0].ToString()); GridViewRow row = (GridViewRow)GridView_Type.Rows[e.RowIndex]; JRALib_Data.Type_ID = ID; JRALib_Data.Type = ((DropDownList)row.FindControl("ddlType")).SelectedValue; JRALib_Data.Type_Value = ((TextBox)row.FindControl("txtType_Value")).Text; JRALib_Data.Type_Display_Text = ((TextBox)row.FindControl("txtType_Display_Text")).Text; JRALib_Data.Type_Description = ((TextBox)row.FindControl("txtType_Desc")).Text; JRALib_Data.Type_Color = ((DropDownList)row.FindControl("ddlGrdType_Color")).SelectedItem.Text; JRALib_Data.UserID = Convert.ToInt32(Session["USERID"]); JRALib_Data.DB_Mode = "U"; if (ValidateType(JRALib_Data.Type, JRALib_Data.Type_Value, JRALib_Data.Type_Description, JRALib_Data.Type_Display_Text, JRALib_Data.Type_Color) == true) { int result = BLL_JRA_Work_Category.JRA_INS_TYPE(JRALib_Data); GridView_Type.EditIndex = -1; Search_Type(); } } catch { } }
protected void GridView_Category_RowUpdating(object sender, GridViewUpdateEventArgs e) { JRA_Lib JRALib_Data = new JRA_Lib(); try { GridViewRow row = (GridViewRow)GridView_Category.Rows[e.RowIndex]; int ID = UDFLib.ConvertToInteger(GridView_Category.DataKeys[e.RowIndex].Values[0].ToString()); GridView_Category.EditIndex = -1; JRALib_Data.UserID = Convert.ToInt32(Session["USERID"]); JRALib_Data.Work_Categ_ID = Convert.ToInt32(ID); JRALib_Data.Work_Categ_Parent_ID = Convert.ToInt32(((HiddenField)row.FindControl("hdnParent_Work_Categ_ID")).Value); JRALib_Data.Work_Category_Name = (((TextBox)row.FindControl("txtCategory_Name")).Text.Trim()); JRALib_Data.Work_Categ_Value = (((TextBox)row.FindControl("txtWork_Categ_Value")).Text.Trim()); JRALib_Data.DB_Mode = "U"; int result = BLL_JRA_Work_Category.JRA_INS_WorkCategory(JRALib_Data); Search_WorkCategory(); Load_CategoryList(null, 0); } catch { } }
protected void ddlParentWorkCateg_SelectedIndexChanged(object sender, EventArgs e) { JRA_Lib lObjWC = new JRA_Lib(); lObjWC.Work_Categ_Parent_ID = UDFLib.ConvertToInteger(ddlParentWorkCateg.SelectedValue); lObjWC.Mode = 1; DataTable dtChilds = BLL_JRA_Work_Category.JRA_GET_WORK_CATEGORY_LIST(lObjWC); DataView dv = dtChilds.DefaultView; DataTable dtChildsCloned = dtChilds.Clone(); dtChildsCloned.Columns["Work_Categ_Value"].DataType = typeof(float); foreach (DataRow row in dtChilds.Rows) { dtChildsCloned.ImportRow(row); } dv = dtChildsCloned.DefaultView; dv.Sort = "Work_Categ_Value"; dtChilds = dv.ToTable(); ddlChildWorkCateg.DataSource = dtChilds; ddlChildWorkCateg.DataTextField = "Work_Category_Display"; ddlChildWorkCateg.DataValueField = "Work_Categ_ID"; ddlChildWorkCateg.DataBind(); ddlChildWorkCateg.Items.Insert(0, new ListItem("-SELECT ALL-", "0")); }
private void SearchRiskType() { JRA_Lib JRALib_Data = new JRA_Lib(); DataTable dt = BLL_JRA_Work_Category.JRA_GET_RATINGS_SEARCH(JRALib_Data); GridView_Ratings.DataSource = dt; GridView_Ratings.DataBind(); }
public static DataTable JRA_GET_WORK_CATEGORY(JRA_Lib objJRALibData) { SqlParameter[] sqlprm = new SqlParameter[] { new SqlParameter("@Type", objJRALibData.Type_ID) }; return(SqlHelper.ExecuteDataset(connection, CommandType.StoredProcedure, "JRA_GET_TYPE", sqlprm).Tables[0]); }
protected void BindCombos() { JRA_Lib lObjWC = new JRA_Lib(); lObjWC.Work_Categ_Parent_ID = null; lObjWC.Mode = 0; DataTable dt = BLL_JRA_Work_Category.JRA_GET_WORK_CATEGORY_LIST(lObjWC); DataView dv = dt.DefaultView; DataTable dtCloned = dt.Clone(); dtCloned.Columns["Work_Categ_Value"].DataType = typeof(float); foreach (DataRow row in dt.Rows) { dtCloned.ImportRow(row); } dv = dtCloned.DefaultView; dv.Sort = "Work_Categ_Value"; dt = dv.ToTable(); ddlParentWorkCateg.DataSource = dt; ddlParentWorkCateg.DataTextField = "Work_Category_Display"; ddlParentWorkCateg.DataValueField = "Work_Categ_ID"; ddlParentWorkCateg.DataBind(); ddlParentWorkCateg.Items.Insert(0, new ListItem("-SELECT ALL-", "0")); lObjWC = new JRA_Lib(); lObjWC.Work_Categ_Parent_ID = null; lObjWC.Mode = 3; DataTable dtAllChilds = BLL_JRA_Work_Category.JRA_GET_WORK_CATEGORY_LIST(lObjWC); DataTable dtAllChildsCloned = dtAllChilds.Clone(); dtAllChildsCloned.Columns["Work_Categ_Value"].DataType = typeof(float); foreach (DataRow row in dtAllChilds.Rows) { dtAllChildsCloned.ImportRow(row); } dv = dtAllChildsCloned.DefaultView; dv.Sort = "Work_Categ_Value"; dtAllChilds = dv.ToTable(); ddlChildWorkCateg.DataSource = dtAllChilds; ddlChildWorkCateg.DataTextField = "Work_Category_Display"; ddlChildWorkCateg.DataValueField = "Work_Categ_ID"; ddlChildWorkCateg.DataBind(); ddlChildWorkCateg.Items.Insert(0, new ListItem("-SELECT ALL-", "0")); BLL_Infra_VesselLib objVsl = new BLL_Infra_VesselLib(); DataTable dtVessel = objVsl.Get_VesselList(0, 0, Convert.ToInt32(Session["USERCOMPANYID"].ToString()), "", Convert.ToInt32(Session["USERCOMPANYID"].ToString())); DDLVessel.DataSource = dtVessel; DDLVessel.DataTextField = "Vessel_name"; DDLVessel.DataValueField = "Vessel_id"; DDLVessel.DataBind(); DDLVessel.Items.Insert(0, new ListItem("--SELECT ALL--", null)); }
public static DataTable JRA_GET_WORK_CATEGORY_LIST(JRA_Lib objJRALibData) { SqlParameter[] sqlprm = new SqlParameter[] { new SqlParameter("@Work_Categ_Parent_ID", objJRALibData.Work_Categ_Parent_ID), new SqlParameter("@Mode", objJRALibData.Mode) }; return(SqlHelper.ExecuteDataset(connection, CommandType.StoredProcedure, "JRA_GET_WORK_CATEGORY_LIST", sqlprm).Tables[0]); }
protected void Load_TypeList() { JRA_Lib JRALib_Data = new JRA_Lib(); JRALib_Data.Type_ID = 0; DataTable dt = BLL_JRA_Work_Category.JRA_GET_TYPE_LIST(JRALib_Data); GridView_Type.DataSource = dt; GridView_Type.DataBind(); }
public static DataTable JRA_GET_TYPE_SEARCH(JRA_Lib JRALib_Data) { SqlParameter[] sqlPrm = new SqlParameter[] { new SqlParameter("@SearchText", JRALib_Data.SearchText), new SqlParameter("@SearchType", JRALib_Data.SearchType), new SqlParameter("@PAGENUMBER", JRALib_Data.PageNumber), new SqlParameter("@PAGESIZE", JRALib_Data.PageSize), }; return(SqlHelper.ExecuteDataset(connection, CommandType.StoredProcedure, "JRA_GET_TYPE_SEARCH", sqlPrm).Tables[0]); }
private void SaveRisk_Type(string DB_Mode) { JRA_Lib JRALib_Data = new JRA_Lib(); JRALib_Data.RiskType = ddlRiskType.SelectedValue; JRALib_Data.RatingValue = Convert.ToInt32(txtRatingVal.Text); JRALib_Data.UserID = Convert.ToInt32(Session["USERID"]); JRALib_Data.DB_Mode = DB_Mode; int result = BLL_JRA_Work_Category.JRA_INS_RatingType(JRALib_Data); }
protected void GridView_Ratings_RowDeleting(object sender, GridViewDeleteEventArgs e) { JRA_Lib JRALib_Data = new JRA_Lib(); int ID = UDFLib.ConvertToInteger(GridView_Ratings.DataKeys[e.RowIndex].Value.ToString()); JRALib_Data.Rating_ID = ID; JRALib_Data.UserID = Convert.ToInt32(Session["USERID"]); JRALib_Data.DB_Mode = "D"; int result = BLL_JRA_Work_Category.JRA_INS_RatingType(JRALib_Data); SearchRiskType(); }
private void LoadRisk_Type() { JRA_Lib JRALib_Data = new JRA_Lib(); DataTable dt = BLL_JRA_Work_Category.JRA_GET_RISK_TYPES(JRALib_Data); ddlRiskType.DataSource = dt; ddlRiskType.DataTextField = Convert.ToString(dt.Columns["Type_Display_Text"]); ddlRiskType.DataValueField = Convert.ToString(dt.Columns["Type_ID"]); ddlRiskType.DataBind(); ddlRiskType.Items.Insert(0, new ListItem("-Select-", "0")); ViewState["vsRiskType"] = dt; }
public static DataTable JRA_SEARCH_WORK_CATEGORY(JRA_Lib objJRALibData) { SqlParameter[] sqlPrm = new SqlParameter[] { new SqlParameter("@SearchText", objJRALibData.SearchText), new SqlParameter("@SearchCate", objJRALibData.SearchCate), new SqlParameter("@PAGENUMBER", objJRALibData.PageNumber), new SqlParameter("@PAGESIZE", objJRALibData.PageSize) }; DataTable dt = SqlHelper.ExecuteDataset(connection, CommandType.StoredProcedure, "JRA_GET_WORK_CATEGORY_SEARCH", sqlPrm).Tables[0]; return(dt); }
public static int JRA_INS_RatingType(JRA_Lib objJRALibData) { SqlParameter[] sqlprm = new SqlParameter[] { new SqlParameter("@Rating_ID", objJRALibData.Rating_ID), new SqlParameter("@Risk_TYPE", objJRALibData.RiskType), new SqlParameter("@Rating_VALUE", objJRALibData.RatingValue), new SqlParameter("@UserID", objJRALibData.UserID), new SqlParameter("@DB_Mode", objJRALibData.DB_Mode) }; return(SqlHelper.ExecuteNonQuery(connection, CommandType.StoredProcedure, "JRA_INSUPD_RISK_RATING", sqlprm)); }
protected void GridView_Category_RowDeleting(object sender, GridViewDeleteEventArgs e) { JRA_Lib JRALib_Data = new JRA_Lib(); int ID = UDFLib.ConvertToInteger(GridView_Category.DataKeys[e.RowIndex].Value.ToString()); JRALib_Data.Work_Categ_ID = ID; JRALib_Data.UserID = Convert.ToInt32(Session["USERID"]); JRALib_Data.DB_Mode = "D"; int result = BLL_JRA_Work_Category.JRA_INS_WorkCategory(JRALib_Data); //GroupGridviewHeader(); Search_WorkCategory(); Load_CategoryList(null, 0); }
private void SaveType(string DB_Mode) { JRA_Lib JRALib_Data = new JRA_Lib(); JRALib_Data.Type_ID = 0; JRALib_Data.Type = ddlType.SelectedItem.Text; JRALib_Data.Type_Value = txtTypeValue.Text.Trim(); JRALib_Data.Type_Display_Text = txtDisplayText.Text.Trim(); JRALib_Data.Type_Description = txtDesc.Text.Trim(); JRALib_Data.Type_Color = ddlColors.SelectedItem.Text; JRALib_Data.UserID = Convert.ToInt32(Session["USERID"]); JRALib_Data.DB_Mode = DB_Mode; int result = BLL_JRA_Work_Category.JRA_INS_TYPE(JRALib_Data); }
public static int JRA_INS_TYPE(JRA_Lib objJRALibData) { SqlParameter[] sqlprm = new SqlParameter[] { new SqlParameter("@Type_ID", objJRALibData.Type_ID), new SqlParameter("@Type", objJRALibData.Type), new SqlParameter("@Type_Value", objJRALibData.Type_Value), new SqlParameter("@Type_Display_Text", objJRALibData.Type_Display_Text), new SqlParameter("@Type_Description", objJRALibData.Type_Description), new SqlParameter("@Type_Color", objJRALibData.Type_Color), new SqlParameter("@UserID", objJRALibData.UserID), new SqlParameter("@DB_Mode", objJRALibData.DB_Mode) }; return(SqlHelper.ExecuteNonQuery(connection, CommandType.StoredProcedure, "JRA_INSUPD_TYPE_LIST", sqlprm)); }
public void LoadCombos() { JRA_Lib lObjWC = new JRA_Lib(); lObjWC.Work_Categ_Parent_ID = null; lObjWC.Mode = 3; DataTable dtW = BLL_JRA_Work_Category.JRA_GET_WORK_CATEGORY_LIST(lObjWC); ddlParentWorkCateg.DataSource = dtW; ddlParentWorkCateg.DataTextField = "Work_Category_Display"; ddlParentWorkCateg.DataValueField = "Work_Categ_ID_TYPE"; ddlParentWorkCateg.DataBind(); ddlParentWorkCateg.Items.Insert(0, new ListItem("-SELECT ALL-", "0")); ddlCTWorkCategory.DataSource = dtW; ddlCTWorkCategory.DataTextField = "Work_Category_Display"; ddlCTWorkCategory.DataValueField = "Work_Categ_ID"; ddlCTWorkCategory.DataBind(); ddlParentWorkCateg.SelectedIndex = 0; }
protected void Load_CategoryList(int?ParentCateID, int Mode) { JRA_Lib ObjJRALib = new JRA_Lib(); ObjJRALib.Mode = Mode; ObjJRALib.Work_Categ_Parent_ID = ParentCateID; DataTable dt = BLL_JRA_Work_Category.JRA_GET_WORK_CATEGORY_LIST(ObjJRALib); ddlParentCat.DataSource = dt; ddlParentCat.DataTextField = Convert.ToString(dt.Columns["Work_Category_Name"]); ddlParentCat.DataValueField = Convert.ToString(dt.Columns["Work_Categ_ID"]); ddlParentCat.DataBind(); ddlParentCat.Items.Insert(0, new ListItem("-Select-", "0")); ddlFiter.DataSource = dt; ddlFiter.DataTextField = Convert.ToString(dt.Columns["Work_Category_Name"]); ddlFiter.DataValueField = Convert.ToString(dt.Columns["Work_Categ_ID"]); ddlFiter.DataBind(); ddlFiter.Items.Insert(0, new ListItem("-Select-", "0")); }
private void SaveWorkCategory(string DB_Mode) { JRA_Lib JRALib_Data = new JRA_Lib(); JRALib_Data.UserID = Convert.ToInt32(Session["USERID"]); JRALib_Data.Work_Categ_ID = Convert.ToInt32(0); JRALib_Data.Work_Categ_Parent_ID = Convert.ToInt32(ddlParentCat.SelectedValue); JRALib_Data.Work_Categ_Value = txtCatVal.Text.Trim(); JRALib_Data.Work_Category_Name = txtCatName.Text.Trim(); JRALib_Data.DB_Mode = DB_Mode; int result = BLL_JRA_Work_Category.JRA_INS_WorkCategory(JRALib_Data); if (result == 999)//CHECK FOR DUPLICATE WORK CATEGORY NAME { string js = ""; js = "alert('Work Category Name already exists.');"; ScriptManager.RegisterStartupScript(this, this.GetType(), "alert", js, true); } }
protected void ClearFilter() { JRA_Lib lObjWC = new JRA_Lib(); lObjWC.Work_Categ_Parent_ID = null; lObjWC.Mode = 3; DataTable dtAllChilds = BLL_JRA_Work_Category.JRA_GET_WORK_CATEGORY_LIST(lObjWC); ddlChildWorkCateg.DataSource = dtAllChilds; ddlChildWorkCateg.DataTextField = "Work_Category_Display"; ddlChildWorkCateg.DataValueField = "Work_Categ_ID"; ddlChildWorkCateg.DataBind(); ddlChildWorkCateg.Items.Insert(0, new ListItem("-Select All-", "0")); ddlParentWorkCateg.SelectedIndex = 0; ddlChildWorkCateg.SelectedIndex = 0; ddlParentWorkCateg.SelectedIndex = 0; ddlAssessmentStatus.SelectedIndex = 0; txtFromDate.Text = ""; txtToDate.Text = ""; DDLVessel.SelectedIndex = 0; }
protected void GridView_Ratings_RowUpdating(object sender, GridViewUpdateEventArgs e) { JRA_Lib JRALib_Data = new JRA_Lib(); try { int ID = UDFLib.ConvertToInteger(GridView_Ratings.DataKeys[e.RowIndex].Values[0].ToString()); GridViewRow row = (GridViewRow)GridView_Ratings.Rows[e.RowIndex]; JRALib_Data.Rating_ID = ID; JRALib_Data.RiskType = ((DropDownList)row.FindControl("ddlDisplayText")).SelectedValue; JRALib_Data.RatingValue = Convert.ToInt32(((TextBox)row.FindControl("txtRisk")).Text); JRALib_Data.UserID = Convert.ToInt32(Session["USERID"]); JRALib_Data.DB_Mode = "U"; int result = BLL_JRA_Work_Category.JRA_INS_RatingType(JRALib_Data); GridView_Ratings.EditIndex = -1; SearchRiskType(); } catch { } }
public static int JRA_INS_WorkCategory(JRA_Lib objJRALibData) { int ReturnVal = 0; SqlParameter[] sqlprm = new SqlParameter[] { new SqlParameter("@Work_Categ_ID", objJRALibData.Work_Categ_ID), new SqlParameter("@Work_Categ_Value", objJRALibData.Work_Categ_Value), new SqlParameter("@Work_Category_Name", objJRALibData.Work_Category_Name), new SqlParameter("@Work_Categ_Parent_ID", objJRALibData.Work_Categ_Parent_ID), new SqlParameter("@UserID", objJRALibData.UserID), new SqlParameter("@DB_Mode", objJRALibData.DB_Mode), new SqlParameter("@ReturnVal", objJRALibData.ReturnVal) }; sqlprm[sqlprm.Length - 1].Direction = ParameterDirection.InputOutput; SqlHelper.ExecuteNonQuery(connection, CommandType.StoredProcedure, "JRA_INSUPD_WORK_CATEGORY_LIST", sqlprm); ReturnVal = Convert.ToInt32(sqlprm[sqlprm.Length - 1].Value); return(ReturnVal); }
public static DataTable JRA_GET_RATINGS_SEARCH(JRA_Lib JRALib_Data) { return(SqlHelper.ExecuteDataset(connection, CommandType.StoredProcedure, "JRA_GET_RATINGS_SEARCH").Tables[0]); }
public static DataTable JRA_GET_RATINGS_SEARCH(JRA_Lib JRALib_Data) { return(DAL_JRA_Work_Category.JRA_GET_RATINGS_SEARCH(JRALib_Data)); }
protected void BindCombos() { JRA_Lib lObjWC = new JRA_Lib(); lObjWC.Work_Categ_Parent_ID = null; lObjWC.Mode = 0; DataTable dt = BLL_JRA_Work_Category.JRA_GET_WORK_CATEGORY_LIST(lObjWC); DataView dv = dt.DefaultView; DataTable dtCloned = dt.Clone(); dtCloned.Columns["Work_Categ_Value"].DataType = typeof(float); foreach (DataRow row in dt.Rows) { dtCloned.ImportRow(row); } dv = dtCloned.DefaultView; dv.Sort = "Work_Categ_Value"; dt = dv.ToTable(); ddlParentWorkCateg.DataSource = dt; ddlParentWorkCateg.DataTextField = "Work_Category_Display"; ddlParentWorkCateg.DataValueField = "Work_Categ_ID"; ddlParentWorkCateg.DataBind(); ddlParentWorkCateg.Items.Insert(0, new ListItem("-Select All-", "0")); lObjWC = new JRA_Lib(); lObjWC.Work_Categ_Parent_ID = null; lObjWC.Mode = 3; DataTable dtAllChilds = BLL_JRA_Work_Category.JRA_GET_WORK_CATEGORY_LIST(lObjWC); DataTable dtAllChildsCloned = dtAllChilds.Clone(); dtAllChildsCloned.Columns["Work_Categ_Value"].DataType = typeof(float); foreach (DataRow row in dtAllChilds.Rows) { dtAllChildsCloned.ImportRow(row); } dv = dtAllChildsCloned.DefaultView; dv.Sort = "Work_Categ_Value"; dtAllChilds = dv.ToTable(); ddlChildWorkCateg.DataSource = dtAllChilds; ddlChildWorkCateg.DataTextField = "Work_Category_Display"; ddlChildWorkCateg.DataValueField = "Work_Categ_ID"; ddlChildWorkCateg.DataBind(); ddlChildWorkCateg.Items.Insert(0, new ListItem("-Select All-", "0")); ddlParentWorkCateg.SelectedIndex = 0; ddlChildWorkCateg.SelectedIndex = 0; ddlWorkCategory.DataSource = dtAllChilds; ddlWorkCategory.DataTextField = "Work_Category_Display"; ddlWorkCategory.DataValueField = "Work_Categ_ID"; ddlWorkCategory.DataBind(); ddlWorkCategory.Items.Insert(0, new ListItem("-Select All-", "0")); ddlWorkCategory.SelectedIndex = 0; DataSet dsSev = BLL_JRA_Hazards.GET_TYPE("Severity"); ddlSeverity.DataSource = dsSev.Tables[0]; ddlSeverity.DataTextField = "Type_Display_Text"; ddlSeverity.DataValueField = "Type_ID"; ddlSeverity.DataBind(); ddlSeverity.Items.Insert(0, new ListItem("-Select All-", "0")); DataSet dsLkhd = BLL_JRA_Hazards.GET_TYPE("Likelihood"); ddlLikelihood.DataSource = dsLkhd.Tables[0]; ddlLikelihood.DataTextField = "Type_Display_Text"; ddlLikelihood.DataValueField = "Type_ID"; ddlLikelihood.DataBind(); ddlLikelihood.Items.Insert(0, new ListItem("-Select All-", "0")); DataSet dsModRis = BLL_JRA_Hazards.JRA_GET_MODIFIED_RISKS(); ddlModifiedRisk.DataSource = dsModRis.Tables[0]; ddlModifiedRisk.DataTextField = "Type_Display_Text"; ddlModifiedRisk.DataValueField = "Type_ID"; ddlModifiedRisk.DataBind(); ddlModifiedRisk.Items.Insert(0, new ListItem("-Select All-", "0")); }