or
private void DataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
var location = Convert.ToString(dataGridView1[e.ColumnIndex, e.RowIndex].Value);
if (dataGridView1.Columns[e.ColumnIndex] is DataGridViewLinkColumn)
if (e.ColumnIndex == 4)
Process.Start(location);
else if (e.ColumnIndex == 5)
{
int i = dataGridView1.CurrentCell.RowIndex;
private void gridExpenses_CellValueChanged(object sender, GridViewCellEventArgs e)
{
if (e.Column.OwnerTemplate != gridExpenses.MasterTemplate && e.Column.Name == "colAmount")
{
EvaluateTotal((GridViewRowInfo)e.Row.Parent);
}
}
private void EvaluateTotal(GridViewRowInfo parent)
{
if (parent.ChildRows.Count > 0)
parent.Cells["colRemaining"].Value = gridExpenses.Evaluate("Sum(colAmount)", parent.ChildRows);
}
Also, I should export only visible columns in RadGridView and the text columns should be present only in the exported excel file and not to be displayed in RadGridView.
We are using Telerik Control version : 2013.3.1127.40
Regards,
Vimal
public
partial
class
Form1 : RadForm
{
public
Form1()
{
InitializeComponent();
this
.radGridView1.EditorRequired += radGridView1_EditorRequired;
this
.radGridView1.CellEditorInitialized += radGridView1_CellEditorInitialized;
}
void
radGridView1_CellEditorInitialized(
object
sender, GridViewCellEventArgs e)
{
if
(e.ActiveEditor
is
RadDropDownListEditor)
{
RadDropDownListEditor editor = e.ActiveEditor
as
RadDropDownListEditor;
RadDropDownListEditorElement element = (RadDropDownListEditorElement)editor.EditorElement;
element.DisplayMember =
"Description"
;
element.ValueMember =
"Code"
;
element.DataSource =
this
.CreateDataTable();
element.SelectedIndex = -1;
}
}
void
radGridView1_EditorRequired(
object
sender, EditorRequiredEventArgs e)
{
e.EditorType =
typeof
(RadDropDownListEditor);
}
private
DataTable CreateDataTable()
{
DataTable dataTable =
new
DataTable();
dataTable.Columns.Add(
"Code"
,
typeof
(
decimal
));
dataTable.Columns.Add(
"Description"
,
typeof
(
string
));
for
(
int
i = 0; i < 5; i++)
{
DataRow dr = dataTable.NewRow();
dr[0] = i + 1;
dr[1] =
"Description "
+ (i + 1);
dataTable.Rows.Add(dr);
}
return
dataTable;
}
}
private
void
gvProducts_ViewCellFormatting(
object
sender, Telerik.WinControls.UI.CellFormattingEventArgs e)
{
if
(e.CellElement
is
GridSummaryCellElement)
{
e.CellElement.TextAlignment = ContentAlignment.BottomRight;
e.CellElement.Font =
new
Font(e.CellElement.Font, FontStyle.Bold);
}
}