RadGrid 动态数据绑定列 - 检查每个单元格值

Question

我有一个 Radgrid，它具有来自数据库查询的动态数据绑定字段，并且每次它们都不同。现在，当此数据显示在网格上时，我想将 0 的单元格的值更改为“”或“”。

谢谢

Answer 1

您需要挂钩 CellFormatting 事件。您可以在此处检查单元格的值并根据需要更改它。

大致如下：

Private Sub RadGrid_CellFormatting(sender As Object, e As CellFormattingEventArgs) Handles RadGrid.CellFormatting
            if e.CellElement.RowInfo.Cells("ZeroColumn").Value = "0" then
               e.CellElement.RowInfo.Cells("ZeroColumn").Value = "."
            end if
    End Sub

Answer 2

try
{
    if (e.Row.RowType == DataControlRowType.Header)
    {
        e.Row.Cells[e.Row.Cells.Count - 1].Visible = false;
    }

    if (e.Row.RowType == DataControlRowType.DataRow)
    {
        for (int i = 3; i < e.Row.Cells.Count; ++i)
        {
            TextBox tb = new TextBox();
            tb.ID = "txtRow" + e.Row.RowIndex.ToString() + "Column" + i.ToString();
            tb.Width = 50;
            //if (Convert.ToBoolean(e.Row.Cells[i].Text) == false)
            //tb.Text = "0";
            //tb.Text = e.Row.Cells[i].Text;
            e.Row.Cells[i].Controls.Add(tb);
            // e.Row.Cells[i].Enabled = Convert.ToBoolean(e.Row.Cells[i].Text);
        }
        e.Row.Cells[e.Row.Cells.Count - 1].Visible = false;
    }
}
catch (Exception ex)
{ }