private void BindMaterials()
    {
        DataSet dsGrp = new DataSet();
        Whitfieldcore wUser = new Whitfieldcore();
        dsGrp = wUser.GetAllMaterialTypes();
        if (dsGrp.Tables[0].Rows.Count > 0)
        {

            ddlType.DataSource = dsGrp;
            ddlType.DataTextField = "Mat_type_Desc";
            ddlType.DataValueField = "Mat_type_id";
            ddlType.DataBind();
            ddlType.Items.Insert(0, common.AddItemToList("Select Type", ""));

        }
    }
    private void BindMaterialTypes()
    {
        try
        {
            Whitfieldcore _dbClass = new Whitfieldcore();
            DataSet dsportfolio = new DataSet();
            dsportfolio = _dbClass.GetAllMaterialTypes();
            if (dsportfolio.Tables[0].Rows.Count > 0)
            {

                ddlMatType.DataSource = dsportfolio;
                ddlMatType.DataTextField = "Mat_type_Desc";
                ddlMatType.DataValueField = "Mat_type_id";
                ddlMatType.DataBind();
                ddlMatType.Items.Insert(0, common.AddItemToList("Fetch All Material Types", "0"));
            }
        }
        catch (Exception ex)
        {
            HttpResponse objResponse = HttpContext.Current.Response;
            objResponse.Write(ex.Message);
        }
    }