Dim exporter As New ExportToExcelML(documentTop.DataGrid) |
exporter.SheetMaxRows = ExcelMaxRows._65536 |
exporter.ExportVisualSettings = True |
Dim fileName As String = "c:\ExportedData.xls" |
exporter.RunExport(fileName) |
Me.DataGrid.ColumnChooser.Show() |
In our database tables we have a field isDeleted. This indicates if a record is logically deleted.
There is a Delete-Button on the form. If the user presses this button, the flag should be set, then the data saved. After that the window is closed and the user gets back to the form with the list. The list is built upon a database view with the where-clause "where IsDeleted = 0".
For editing the data I have a detail data form with a ObjectView. On the form there is a RadCheckbox-Control named cbIsDeleted.
The control is bound via the IsChecked-Property to the persistent data.
cbIsDeleted.ToggleState = |
Telerik.WinControls.Enumerations.ToggleState.On; |
I tried also:
cbIsDeleted.Checked = true; |
private void BindData()
{
radGridView1.GridElement.BeginUpdate();
var gridViewLookUpColumn = ((GridViewLookUpColumn)(radGridView1.CurrentRow.Cells["column1"].ColumnInfo));
if (gridViewLookUpColumn == null) return;
gridViewLookUpColumn.DataSource = FillData();
gridViewLookUpColumn.DisplayMember = "Name";
gridViewLookUpColumn.ValueMember = "Id";
gridViewLookUpColumn.DropDownStyle = RadDropDownStyle.DropDownList;
radGridView1.GridElement.EndUpdate();
}
private static DataTable FillData()
{
var dt = new DataTable();
dt.Columns.Add(new DataColumn("Name", typeof(String)));
dt.Columns.Add(new DataColumn("Id", typeof(Int32)));
var dr = dt.NewRow();
dr["Name"] = "Test 1";
dr["Id"] = 1;
dt.Rows.Add(dr);
dr = dt.NewRow();
dr["Name"] = "Test 2";
dr["Id"] = "2";
dt.Rows.Add(dr);
return dt;
}
private void radGridView1_CellBeginEdit(object sender, GridViewCellCancelEventArgs e)
{
BindData();
}
private void radGridView1_CellEndEdit(object sender, GridViewCellEventArgs e)
{
try
{
var radEditor = radGridView1.ActiveEditor;
if (radEditor == null) return;
switch (radEditor.GetType().Name)
{
case "RadComboBoxEditor":
{
var element = ((RadComboBoxElement)((RadComboBoxEditor)radGridView1.ActiveEditor).EditorElement);
if (element == null) return;
var selectedText = ((RadComboBoxItem) element.SelectedItem).Text;
MessageBox.Show("Begin" + selectedText);
radGridView1.CurrentRow.Cells["column1"].CellElement.Text = selectedText;
//radGridView1.Rows[e.RowIndex + 1].Cells[e.ColumnIndex + 1].Value = element.SelectedValue;
break;
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}