private DataView GetDataView() { /* DataTable dt = new DataTable(); * dt.Locale = CultureInfo.InvariantCulture; * dt.Columns.Add("company_uid", typeof(string)); * dt.Columns.Add("company_name", typeof(string)); * dt.Columns.Add("domain", typeof(string)); * dt.Columns.Add("company_type", typeof(byte)); * dt.Columns.Add("is_active", typeof(bool)); * dt.Columns.Add("creation_date", typeof(DateTime)); * dt.Columns.Add("start_date", typeof(DateTime)); * dt.Columns.Add("end_date", typeof(DateTime)); * * ICompanyInfo[] companies = Configurator.Create().ListCompanies(); * foreach (ICompanyInfo company in companies) * { * DataRow row = dt.NewRow(); * row["company_uid"] = company.Id; * row["company_name"] = company.; * * dt.Rows.Add(row); * } */ DataView view = CManage.GetCompaniesDataTable().DefaultView; view.Sort = Session[SortColumn_key].ToString(); string filter = string.Empty; if (ddType.SelectedItem.Value != "0") { filter = "company_type='" + ddType.SelectedItem.Value + "'"; } if (ddActivity.SelectedItem.Value == "1") { if (filter.Length > 0) { filter += " AND "; } filter += "Is_Active='True'"; } if (ddActivity.SelectedItem.Value == "-1") { if (filter.Length > 0) { filter += " AND "; } filter += "Is_Active='False'"; } if (filter.Length > 0) { view.RowFilter = filter; } return(view); }
private void BindValues() { DataView dv = CManage.GetCompaniesDataTable().DefaultView; dv.Sort = "Company_Name"; ddCompanies.DataSource = dv; ddCompanies.DataTextField = "Company_Name"; ddCompanies.DataValueField = "Company_Uid"; ddCompanies.DataBind(); txtAmount.Text = "0"; txtBonus.Text = "0"; PaymentDate.Text = DateTime.Today.ToShortDateString(); }