or



01.private void RadMultiColumnComboBox3SelectedIndexChanged(object sender, EventArgs e)02. {03. string a;04. a = string.Format("{0}", radMultiColumnComboBox3.EditorControl.Rows[radMultiColumnComboBox3.SelectedIndex].Cells["customerID"].Value);05. Int32 b;06. Int32.TryParse(a, out b);07. radMultiColumnComboBox4.Enabled = true;08. OleDbConnection conn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|/RoadRunnerDB.mdb");09. string cmdStr = string.Format("Select * FROM addressList WHERE customerID = {0}", b);10. 11. try12. {13. conn.Open();14. OleDbCommand cmd = new OleDbCommand(cmdStr, conn);15. OleDbDataReader reader = cmd.ExecuteReader();16. //fill the grid!??17. }18. catch (Exception ex)19. {20. MessageBox.Show(ex.Message);21. }22. }


private void BindGrid() { this.ExportSettingGridView.AllowAddNewRow = false; this.ExportSettingGridView.AutoGenerateColumns = false; this.ExportSettingGridView.AutoSizeColumnsMode = GridViewAutoSizeColumnsMode.Fill; this.ExportSettingGridView.ShowGroupPanel = false; this.ExportSettingGridView.MasterTemplate.EnableGrouping = false; this.ExportSettingGridView.EnableHotTracking = true; //Settings Name column
GridViewTextBoxColumn nameCol = new GridViewTextBoxColumn(); nameCol.FieldName = "Name"; nameCol.Name = "Name"; nameCol.HeaderText = "Export Setting"; this.ExportSettingGridView.Columns.Add(nameCol); //Settings Na Option Combo Box GridViewComboBoxColumn naDataOptionCol = new GridViewComboBoxColumn(); naDataOptionCol.FieldName = "NaData.NaDataOption"; naDataOptionCol.Name = "NaData.NaDataOption"; naDataOptionCol.HeaderText = "NA Data Option"; naDataOptionCol.DataSource = Enum.GetValues(typeof(NADataOption)); naDataOptionCol.DataType = typeof(NADataOption); naDataOptionCol.DataSourceNullValue = NADataOption.BLANKROW;
this.ExportSettingGridView.Columns.Add(naDataOptionCol); //Setting NA Option Custom Text field Columns GridViewTextBoxColumn naDataOptionCustomCol = new GridViewTextBoxColumn(); naDataOptionCustomCol.FieldName = "NaData.Custom"; naDataOptionCustomCol.Name = "NaData.Custom"; naDataOptionCustomCol.HeaderText = "NA Data Option Custom"; this.ExportSettingGridView.Columns.Add(naDataOptionCustomCol); //Setting IncludePartialLastPeriod GridViewComboBoxColumn includePartialLastPeriodCol = new GridViewComboBoxColumn(); includePartialLastPeriodCol.FieldName = "IncludePartialLastPeriod"; includePartialLastPeriodCol.HeaderText = "Include Partial Last Period"; includePartialLastPeriodCol.Name = "IncludePartialLastPeriod"; includePartialLastPeriodCol.DataSource = new String[] { "True", "False" }; includePartialLastPeriodCol.DataType = typeof(bool); this.ExportSettingGridView.Columns.Add(includePartialLastPeriodCol);
//Setting Sorting Column GridViewComboBoxColumn sortingCol = new GridViewComboBoxColumn(); sortingCol.FieldName = "Sorting"; sortingCol.HeaderText = "Sorting"; sortingCol.Name = "Sorting"; sortingCol.DataSource = new String[] { "ASC", "DESC" }; this.ExportSettingGridView.Columns.Add(sortingCol); //Setting Data Load Position GridViewComboBoxColumn dataPostionOptionsCol = new GridViewComboBoxColumn(); dataPostionOptionsCol.FieldName = "DataLoadPosition.CursorLocation"; dataPostionOptionsCol.Name = "DataLoadPosition.CursorLocation"; dataPostionOptionsCol.HeaderText = "Cursor Location"; dataPostionOptionsCol.DataSource = new String[] { "True", "False" }; dataPostionOptionsCol.DataType = typeof(bool); dataPostionOptionsCol.DropDownStyle = Telerik.WinControls.RadDropDownStyle.DropDownList; this.ExportSettingGridView.Columns.Add(dataPostionOptionsCol); //Setting Data Load Cell location GridViewTextBoxColumn cellCol = new GridViewTextBoxColumn(); cellCol.FieldName = "DataLoadPosition.Cell"; cellCol.Name = "DataLoadPosition.Cell"; cellCol.HeaderText = "Cell Location"; this.ExportSettingGridView.Columns.Add(cellCol); this.ExportSettingGridView.BestFitColumns(); }
private void newButton_Click(object sender, EventArgs e)
{
this.ExportSettingGridView.AllowAddNewRow = !this.ExportSettingGridView.AllowAddNewRow;
}
private void ExportSettingGridView_DefaultValuesNeeded(object sender, GridViewRowEventArgs e)
{
if (e.Row != null && e.Row is GridViewNewRowInfo)
{
e.Row.Cells["NaData.NaDataOption"].Value = currentProfile.NaData.NaDataOption;
e.Row.Cells["NaData.Custom"].Value = currentProfile.NaData.Custom;
e.Row.Cells["DataLoadPosition.CursorLocation"].Value = currentProfile.DataLoadPosition.CursorLocation;
e.Row.Cells["DataLoadPosition.Cell"].Value = currentProfile.DataLoadPosition.Cell;
}
}
