protected void BindDropDownLocation() { string WhereCondition = "LocType='B'"; string ColNames = "LocID+ ' - '+ LocName as LocName,LocID"; string tableName = "LocMaster"; DataTable dtLocation = requestQuote.GetLocation(WhereCondition, ColNames, tableName); ddlBranch.DataSource = dtLocation; ddlBranch.DataTextField = "LocName"; ddlBranch.DataValueField = "LocID"; ddlBranch.DataBind(); }