private void BindLists() { DListDocType.DataSource = DALC.GetDataTable("ID,Name,Series,CONCAT(Name,' (',Series,') ') as DocNumber", "DocumentTypes", ""); DListDocType.DataValueField = "ID"; DListDocType.DataTextField = "DocNumber"; DListDocType.DataBind(); DListDocType.Items.Insert(0, new ListItem("--", "-1")); DListEyeColor.DataSource = DALC.GetDataTable("ID,Name", "Colors", "Order By [Priority] asc, Name asc"); DListEyeColor.DataBind(); DListEyeColor.Items.Insert(0, new ListItem("--", "-1")); DListHairColor.DataSource = DListEyeColor.DataSource; DListHairColor.DataBind(); DListHairColor.Items.Insert(0, new ListItem("--", "-1")); DListCountries.DataSource = DALC.GetDataTable("ID,Name", "Countries", ""); DListCountries.DataBind(); DListCountries.Items.Insert(0, new ListItem("--", "-1")); DListBirthRegistraionCountry.DataSource = DListCountries.DataSource; DListBirthRegistraionCountry.DataBind(); DListBirthRegistraionCountry.Items.Insert(0, new ListItem("--", "-1")); RListAdoptionPersonsStatus.DataSource = DALC.GetDataTable("ID,Name", "AdoptionPersonsStatus", ""); RListAdoptionPersonsStatus.DataBind(); RListAdoptionPersonsStatus.SelectedIndex = 0; DListChildFirstRegistrationPlace.DataSource = DALC.GetDataTable("ID,Name", "AdoptionOrganizations", "Where AdoptionOrganizationsTypesID=20"); DListChildFirstRegistrationPlace.DataBind(); DListChildFirstRegistrationPlace.Items.Insert(0, new ListItem("- İcra Hakimiyyəti -", "-1")); }
private void BindList() { DataTable DtContent = DALC.GetDataTable("*", "Contents", "Where ID=1"); LtrContentTitle.Text = DtContent._Rows("Title"); LtrContentText.Text = DtContent._Rows("ContentText"); DListOrganizations.DataSource = DALC.GetDataTable("ID,Name", "AdoptionOrganizations", "Where AdoptionOrganizationsTypesID=20"); DListOrganizations.DataBind(); DListOrganizations.Items.Insert(0, new ListItem("- İcra Hakimiyyəti -", "-1")); DListEyeColor.DataSource = DALC.GetDataTable("ID,Name", "Colors", ""); DListEyeColor.DataBind(); DListEyeColor.Items.Insert(0, new ListItem("- Göz rəngi -", "-1")); DListHairColor.DataSource = DALC.GetDataTable("ID,Name", "Colors", ""); DListHairColor.DataBind(); DListHairColor.Items.Insert(0, new ListItem("- Saç rəngi -", "-1")); }