public static SelectList GetLanguageCodes(string ConnectionString)
{
SettingFacade fac = new SettingFacade(ConnectionString);
DataTable dt = fac.GetLanguageCodes();
List <SelectListItem> lstAllLanguage = new List <SelectListItem>();
for (int i = 0; i < dt.Rows.Count; i++)
{
lstAllLanguage.Add(new SelectListItem {
Value = dt.Rows[i]["inLanguage"].ToString(), Text = dt.Rows[i]["Language"].ToString()
});
}
return(new SelectList(lstAllLanguage, "Value", "Text"));
}