public void FillLocationGrid(long WarehouseID)
{
CustomProfile profile = CustomProfile.GetProfile();
iWarehouseClient Warehouseclient = new iWarehouseClient();
DataSet ds = new DataSet();
ds = Warehouseclient.GetWarehouseLocationByID(WarehouseID, profile.DBConnection._constr);
GVLocation.DataSource = ds;
// GVLocation.DataSource = Warehouseclient.GetWarehouseLocation(WarehouseID, profile.DBConnection._constr);
GVLocation.DataBind();
}
private void GVLocDataBind()
{
StringBuilder sql = new StringBuilder(string.Format("select * from jp_wh_loc_v where area_id = '{0}'", DdlArea.SelectedValue));
if (TxtLocation.Text.Trim() != "")
{
sql.Append(string.Format("and location like '{0}'", TxtLocation.Text));
}
GVLocation.DataSource = DBHelper.createGridView(sql.ToString());
GVLocation.DataBind();
}