Helo Sir,
I have a Query that after binding data into multi select dropdownlist and saves the selected into Database by concatenation (,)comma.
Eg: New Delhi,Mumbai,Pune,Ajmer.
So, how can we Bind the same saved data checked into multi select dropdownlist on Edit button and also bind remaining who is not checked. ?
public List<CityMaster> GetCityMaster()
{
List<CityMaster> oGetCityList = new List<CityMaster>();
CityMaster _GetCityList;
DataTable dt = new DataTable();
dt = SqlHelper.ExecuteDataset(CommandType.StoredProcedure, "usp_GetCityMaster").Tables[0];
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
_GetCityList = new CityMaster();
_GetCityList.CityId = Convert.ToInt32(dt.Rows[i]["CityId"]);
_GetCityList.CountryId = Convert.ToInt32(dt.Rows[i]["CountryId"]);
_GetCityList.CountryName = Convert.ToString(dt.Rows[i]["CountryName"]);
_GetCityList.CityName = Convert.ToString(dt.Rows[i]["CityName"]);
_GetCityList.CityUrl = Convert.ToString(dt.Rows[i]["CityUrl"]);
_GetCityList.IsActive = Convert.ToBoolean(dt.Rows[i]["IsActive"].ToString());
_GetCityList.IsUrlActive = Convert.ToBoolean(dt.Rows[i]["IsUrlActive"].ToString());
_GetCityList.CategorisedView = Convert.ToBoolean(dt.Rows[i]["CategorisedView"]);
_GetCityList.IsSubDomain = Convert.ToBoolean(dt.Rows[i]["IsSubDomain"]);
_GetCityList.PageHeading = Convert.ToString(dt.Rows[i]["PageHeading"]);
_GetCityList.BreadcrumbHeading = Convert.ToString(dt.Rows[i]["BreadcrumbHeading"]);
_GetCityList.BannerContent = Convert.ToString(dt.Rows[i]["BannerContent"]);
_GetCityList.ShortContent = Convert.ToString(dt.Rows[i]["ShortContent"]);
_GetCityList.LongContent = Convert.ToString(dt.Rows[i]["LongContent"]);
_GetCityList.PageTitle = Convert.ToString(dt.Rows[i]["PageTitle"]);
_GetCityList.MetaDescription = Convert.ToString(dt.Rows[i]["MetaDescription"]);
_GetCityList.MetaKeywords = Convert.ToString(dt.Rows[i]["MetaKeywords"]);
oGetCityList.Add(_GetCityList);
}
}
return oGetCityList;
// City Dynamic Dropdowns
string CityName = "";
CityName = _ProductMaster.CityTags;
string[] values = CityName.Split(',').Select(svalues => svalues.Trim()).ToArray();
if (!string.IsNullOrEmpty(CityName))
{
if (!(values[0] == "0"))
{
foreach (string Items in values)
{
}
}
}
List<CityMaster> _lstCityMasterBO = new List<CityMaster>();
CityMaster _CityMasterBO = new CityMaster();
_lstCityMasterBO = _CityMasterDAL.GetCityMaster().Where(m => m.CountryId == CountryId && m.IsActive == true).ToList();
ViewBag.ddlcitymaster = new SelectList(_lstCityMasterBO.OrderBy(s => s.CityId).Where(m => m.IsActive == true).OrderBy(m => m.CityName),
"CityId", "CityName", ViewBag.citylist).ToList();
City Tags <br />
@Html.ListBox("ddlcitymaster", ViewBag.ddlcitymaster as SelectList)
Create PROCEDURE usp_GetCityMaster
AS
BEGIN
--CityMaster--[1]
SELECT CityId,City.CountryId,Con.CountryName,CityName,CityUrl,ISNULL(City.RedirectUrl,'') as RedirectUrl,ISNULL(City.IsActive,0) as IsActive,ISNULL(City.IsUrlActive,0) as IsUrlActive
,ISNULL(City.IsSubDomain,0) as IsSubDomain,ISNULL(City.CategorisedView,0) as CategorisedView,ISNULL(City.PageHeading,'') as PageHeading
,ISNULL(City.BreadcrumbHeading,'') as BreadcrumbHeading,ISNULL(City.BannerContent,'') as BannerContent,ISNULL(City.ShortContent,'') as ShortContent
,ISNULL(City.LongContent,'') as LongContent,ISNULL(City.PageTitle,'') as PageTitle,ISNULL(City.MetaDescription,'') as MetaDescription,
ISNULL(City.MetaKeywords,'') as MetaKeywords FROM CityMaster(NOLOCK)CITY JOIN CountryMaster(NOLOCK)Con ON CITY.CountryId
= Con.CountryId
END