or
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); } }
myconn = New SqlConnection(constr) myconn.Open() mycomm = New SqlCommand("Select * from tab1 ", myconn) reader = mycomm.ExecuteReader reader.Read() DataGridView1.Rows(DataGridView1.CurrentRow.Index).Cells(0).Value = reader(0).ToString.ToUpper DataGridView1.Rows(DataGridView1.CurrentRow.Index).Cells(1).Value = reader(1).ToString.ToUpper DataGridView1.Rows(DataGridView1.CurrentRow.Index).Cells(2).Value = reader(2).ToString.ToUpper DataGridView1.Rows(DataGridView1.CurrentRow.Index).Cells(3).Value = reader(3).ToString.ToUpper DataGridView1.Rows(DataGridView1.CurrentRow.Index).Cells(4).Value = reader(4).ToString.ToUpper reader.Close() myconn.Close()