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);
}
}
