private void PopulateGrid() { DataTable dt; dt = new DataTable(); dt = m_oState.GetStateList(); grdTrans.DataSource = dt; TransView.Columns[0].Visible = false; TransView.Columns[1].Width = 150; TransView.Columns[2].Width = 150; TransView.Columns[1].Caption = "State"; TransView.Columns[2].Caption = "Country"; TransView.Columns[3].Visible = false; }
private void PopulateState(int argCountryId) { m_tState = new DataTable(); m_tState = m_oState.GetStateList(); cboState.Properties.DataSource = null; DataView dv; dv = new DataView(m_tState); dv.RowFilter = "CountryId = " + argCountryId; cboState.Properties.DataSource = dv.ToTable(); cboState.Properties.ForceInitialize(); cboState.Properties.PopulateColumns(); cboState.Properties.DisplayMember = "StateName"; cboState.Properties.ValueMember = "StateId"; cboState.Properties.Columns["StateId"].Visible = false; cboState.Properties.Columns["CountryName"].Visible = false; cboState.Properties.Columns["CountryId"].Visible = false; cboState.Properties.ShowHeader = false; cboState.Properties.ShowFooter = false; }