string sam = PostcountSummary(); GridViewSummaryItem Total = new GridViewSummaryItem("FullName", " Journal Entry Count: {0} ", GridAggregateFunction.Count); GridViewSummaryItem sumDebCre = new GridViewSummaryItem("DebitAmount", " $ {0}", GridAggregateFunction.Sum); GridViewSummaryItem sumPost = new GridViewSummaryItem("PostedImage", "{0}", sam); GridViewSummaryRowItem summaryRowItem = new GridViewSummaryRowItem(new GridViewSummaryItem[] { Total, sumDebCre, sumPost }); if (this.SummaryDataGridView.SummaryRowsBottom.Count > 0) { this.SummaryDataGridView.SummaryRowsBottom.Clear(); } this.SummaryDataGridView.SummaryRowsBottom.Add(summaryRowItem);[Flags]public enum MyType : short{ None = 0, NseFO = 1, BseFO = 2, NseCM = 4, BseCM = 8, NseCD = 16, Use = 32,}private void Form1_Load( object sender, EventArgs e ){ //DataColumn dt =new DataColumn("Value",typeof (Test)); //dt.DataType = typeof (Test); //dttemp.Columns.Add(dt); dttemp1.Columns.Add("ID",typeof(int)); dttemp1.Columns.Add( "Value", typeof( int ) ); //DataColumn dt = dttemp.Columns["Value"]; //dt.DataType = typeof (Test); ////dttemp.Columns.Add(dt); dttemp1.Rows.Add(0, 0); dttemp1.Rows.Add( 1, 1 ); dttemp1.Rows.Add( 2, 2 ); dttemp1.Rows.Add( 3, 3 ); dttemp1.Rows.Add( 4, 4 ); dttemp1.Rows.Add( 5, 5 ); temp2 = dttemp1.Clone(); DataColumn dcolumn = temp2.Columns["Value"]; dcolumn.DataType = typeof( ExchangeType ); DataTable dtfinal = temp2.Clone(); foreach( DataRow row in dttemp1.Rows ) { temp2.Rows.Add( row.ItemArray ); } DataView filter = new DataView(temp2); dataGridView1.DataSource = filter; c1Flex1Grid.DataSource = filter; radGridView2.DataSource = filter;}
calendar.CurrentViewColumn = colForCurrentDate;calendar.CurrentViewRow = rowForCurrentDate;Public Class frmTree2
Private cmdTemp As New OracleCommand
Private dvTemp As DataView
Private dtTemp As New DataTable
Private daTemp As OracleDataAdapter
Private Sub frmTree2_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
With cmdTemp
.CommandType = CommandType.StoredProcedure
.Connection = db.oraCn
.CommandText = "badgernet.web_read_util.group_tree_dept"
.Parameters.Clear()
.Parameters.Add("out_rs", OracleDbType.RefCursor, DBNull.Value, ParameterDirection.Output)
End With
daTemp = New OracleDataAdapter(cmdTemp)
dtTemp.Clear()
daTemp.Fill(dtTemp)
Me.RadTreeView1.DataSource = dtTemp
Me.RadTreeView1.DisplayMember = "group_name"
Me.RadTreeView1.ParentIDMember = "p_id"
Me.RadTreeView1.DataMember = "g_id"
Me.RadTreeView1.ValueMember = "id"
End Sub
End Class
