private void DataBindDDl() { try { DataSet ds = PH_RateCalc.PH_RateCalc_DateWeekSelAll(AppCode.strConnDB); ddlDateWeek.DataTextField = "dateweek"; ddlDateWeek.DataValueField = "dateweek"; ddlDateWeek.DataSource = ds; ddlDateWeek.DataBind(); /*DataTable dt = PH_UserVendor.PH_UserVendor_SelectAll(AppCode.strConnDB); * ddlVendorCode.DataTextField = "vendor_code"; * ddlVendorCode.DataValueField = "vendor_code"; * ddlVendorCode.DataSource = dt; * ddlVendorCode.DataBind();*/ DataTable dt = PH_HaulierInfo.PH_Haulier_SelAll(AppCode.strConnDB); ddlHaluier.DataTextField = "haulier_abbr"; ddlHaluier.DataValueField = "haulier_abbr"; ddlHaluier.DataSource = dt; ddlHaluier.DataBind(); } catch (Exception ex) { lblErr.Text = ex.Message; PH_ExceptionManager.WriteError(ex.Message); } }
private void DataBindDateWeek() { try { DataSet ds = PH_RateCalc.PH_RateCalc_DateWeekSelAll(AppCode.strConnDB); //PH_ExceptionManager.WriteError("DataBindDateWeek >>" + ds.Tables[0].Rows.Count); ddlDateWeek.DataValueField = "dateweek"; ddlDateWeek.DataTextField = "dateweek"; ddlDateWeek.DataSource = ds.Tables[0]; ddlDateWeek.DataBind(); if (ddlDateWeek.Items.Count > 0) { ddlDateWeek.ClearSelection(); ddlDateWeek.Items[0].Selected = true; } } catch (Exception ex) { PH_ExceptionManager.WriteError("DataBindDateWeek >>" + ex.Message); } }