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.
try
12.
{
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;
}
}