Hello, I have the following code at the bottom which should load data automatically into the RadListView at form load. However, the text is not visible in the RadListView. I can see the exact number of rows being returned from the SQL database into the RadListView. why is the text not visible?
Thank you for your help in advance! :)
private void MemberUC_Load(object sender, EventArgs e)
{
//fill main panel
this.Dock = DockStyle.Fill;
using (SqlConnection con = new SqlConnection(*connection string string goes here*))
{
con.Open();
cmd = new SqlCommand("SELECT FirstName, MiddleName, LastName, MemberType FROM dbo.MemberInformation");
cmd.Connection = con;
dr = cmd.ExecuteReader();
while (dr.Read())
{
ListViewItem item = new ListViewItem();
item.SubItems.Add(dr["FirstName"].ToString());
item.SubItems.Add(dr["MiddleName"].ToString());
item.SubItems.Add(dr["LastName"].ToString());
item.SubItems.Add(dr["MemberType"].ToString());
memberDetailsLV.Items.Add(item);
}
}
}
Is there any maximum number of GridViewColumnGroup that you can assign to a RadGrid? I can add 23 groups (each contain subgroup) but when I add the 24 group I get :
"An unhandled exception of type 'System.NullReferenceException' occurred in Telerik.WinControls.GridView.dll
Additional information: Object reference not set to an instance of an object."
I use the DLL from 2014. Any advice is helpful. I thank you much for your help and time.
My function is
[QOUTE][ColumnGroupsViewDefinition view = new ColumnGroupsViewDefinition();
// Group Header
view.ColumnGroups.Add(new GridViewColumnGroup(""));
view.ColumnGroups[0].Rows.Add(new GridViewColumnGroupRow());
view.ColumnGroups[0].Rows[0].Columns.Add(dg_validare_antecalcul.Columns["pk_pr_cip"]);
view.ColumnGroups[0].Rows[0].Columns.Add(dg_validare_antecalcul.Columns["Bifa"]);
view.ColumnGroups[0].Rows[0].Columns.Add(dg_validare_antecalcul.Columns["Cip"]);
view.ColumnGroups[0].Rows[0].Columns.Add(dg_validare_antecalcul.Columns["Program"]);
view.ColumnGroups[0].Rows[0].Columns.Add(dg_validare_antecalcul.Columns["Reper"]);
view.ColumnGroups[0].Rows[0].Columns.Add(dg_validare_antecalcul.Columns["Denumire Reper"]);
view.ColumnGroups[0].ShowHeader = false;
// CSTA
GridViewColumnGroup oGroup = new GridViewColumnGroup();
oGroup.Text = "CSTA";
GridViewColumnGroup oSubGroup = new GridViewColumnGroup();
oSubGroup.Text = "Pret de vanzare unitar";
oSubGroup.Rows.Add(new GridViewColumnGroupRow());
oSubGroup.Rows[0].Columns.Add(dg_validare_antecalcul.Columns["CSTA_unitar"]);
oSubGroup.Rows[0].Columns.Add(dg_validare_antecalcul.Columns["CSTA_cip"]);
dg_validare_antecalcul.Columns["CSTA_unitar"].HeaderText = "UNITAR";
dg_validare_antecalcul.Columns["CSTA_cip"].HeaderText = "CIP";
oGroup.Groups.Add(oSubGroup);
view.ColumnGroups.Add(oGroup);
// cost complet
oGroup = new GridViewColumnGroup();
oGroup.Text = "";
oSubGroup = new GridViewColumnGroup();
oSubGroup.Text = "COST COMPLET";
oSubGroup.Rows.Add(new GridViewColumnGroupRow());
oSubGroup.Rows[0].Columns.Add(dg_validare_antecalcul.Columns["cost_complet_unitar"]);
oSubGroup.Rows[0].Columns.Add(dg_validare_antecalcul.Columns["cost_complet_cip"]);
dg_validare_antecalcul.Columns["cost_complet_unitar"].HeaderText = "UNITAR";
dg_validare_antecalcul.Columns["cost_complet_cip"].HeaderText = "CIP";
oGroup.Groups.Add(oSubGroup);
oGroup.ShowHeader = false;
view.ColumnGroups.Add(oGroup);
// CSTB
oGroup = new GridViewColumnGroup();
oGroup.Text = "CSTB";
oSubGroup = new GridViewColumnGroup();
oSubGroup.Text = "Profit";
oSubGroup.Rows.Add(new GridViewColumnGroupRow());
oSubGroup.Rows[0].Columns.Add(dg_validare_antecalcul.Columns["CSTB_unitar"]);
oSubGroup.Rows[0].Columns.Add(dg_validare_antecalcul.Columns["CSTB_cip"]);
dg_validare_antecalcul.Columns["CSTB_unitar"].HeaderText = "UNITAR";
dg_validare_antecalcul.Columns["CSTB_cip"].HeaderText = "CIP";
oGroup.Groups.Add(oSubGroup);
view.ColumnGroups.Add(oGroup);
// CSTC
oGroup = new GridViewColumnGroup();
oGroup.Text = "CSTC";
oSubGroup = new GridViewColumnGroup();
oSubGroup.Text = "Ch. generale de administratie";
oSubGroup.Rows.Add(new GridViewColumnGroupRow());
oSubGroup.Rows[0].Columns.Add(dg_validare_antecalcul.Columns["CSTC_unitar"]);
oSubGroup.Rows[0].Columns.Add(dg_validare_antecalcul.Columns["CSTC_cip"]);
dg_validare_antecalcul.Columns["CSTC_unitar"].HeaderText = "UNITAR";
dg_validare_antecalcul.Columns["CSTC_cip"].HeaderText = "CIP";
oGroup.Groups.Add(oSubGroup);
view.ColumnGroups.Add(oGroup);
// CSTD
oGroup = new GridViewColumnGroup();
oGroup.Text = "CSTD";
oSubGroup = new GridViewColumnGroup();
oSubGroup.Text = "Costuri desfacere";
oSubGroup.Rows.Add(new GridViewColumnGroupRow());
oSubGroup.Rows[0].Columns.Add(dg_validare_antecalcul.Columns["CSTD_unitar"]);
oSubGroup.Rows[0].Columns.Add(dg_validare_antecalcul.Columns["CSTD_cip"]);
dg_validare_antecalcul.Columns["CSTD_unitar"].HeaderText = "UNITAR";
dg_validare_antecalcul.Columns["CSTD_cip"].HeaderText = "CIP";
oGroup.Groups.Add(oSubGroup);
view.ColumnGroups.Add(oGroup);
// CSTE
oGroup = new GridViewColumnGroup();
oGroup.Text = "CSTE";
oSubGroup = new GridViewColumnGroup();
oSubGroup.Text = "Cost de productie antecalculat-total";
oSubGroup.Rows.Add(new GridViewColumnGroupRow());
oSubGroup.Rows[0].Columns.Add(dg_validare_antecalcul.Columns["CSTE_unitar"]);
oSubGroup.Rows[0].Columns.Add(dg_validare_antecalcul.Columns["CSTE_cip"]);
dg_validare_antecalcul.Columns["CSTE_unitar"].HeaderText = "UNITAR";
dg_validare_antecalcul.Columns["CSTE_cip"].HeaderText = "CIP";
oGroup.Groups.Add(oSubGroup);
view.ColumnGroups.Add(oGroup);
// CSTF
oGroup = new GridViewColumnGroup();
oGroup.Text = "CSTF";
oSubGroup = new GridViewColumnGroup();
oSubGroup.Text = "Ch. indirecte af. Diviziei strategice";
oSubGroup.Rows.Add(new GridViewColumnGroupRow());
oSubGroup.Rows[0].Columns.Add(dg_validare_antecalcul.Columns["CSTF_unitar"]);
oSubGroup.Rows[0].Columns.Add(dg_validare_antecalcul.Columns["CSTF_cip"]);
dg_validare_antecalcul.Columns["CSTF_unitar"].HeaderText = "UNITAR";
dg_validare_antecalcul.Columns["CSTF_cip"].HeaderText = "CIP";
oGroup.Groups.Add(oSubGroup);
view.ColumnGroups.Add(oGroup);
// CSTG
oGroup = new GridViewColumnGroup();
oGroup.Text = "CSTG";
oSubGroup = new GridViewColumnGroup();
oSubGroup.Text = "Ch. indirecte af. Diviziei conducatoare";
oSubGroup.Rows.Add(new GridViewColumnGroupRow());
oSubGroup.Rows[0].Columns.Add(dg_validare_antecalcul.Columns["CSTG_unitar"]);
oSubGroup.Rows[0].Columns.Add(dg_validare_antecalcul.Columns["CSTG_cip"]);
dg_validare_antecalcul.Columns["CSTG_unitar"].HeaderText = "UNITAR";
dg_validare_antecalcul.Columns["CSTG_cip"].HeaderText = "CIP";
oGroup.Groups.Add(oSubGroup);
view.ColumnGroups.Add(oGroup);
// CSTH
oGroup = new GridViewColumnGroup();
oGroup.Text = "CSTH";
oSubGroup = new GridViewColumnGroup();
oSubGroup.Text = "Cost de productie antecalculat-propriu";
oSubGroup.Rows.Add(new GridViewColumnGroupRow());
oSubGroup.Rows[0].Columns.Add(dg_validare_antecalcul.Columns["CSTH_unitar"]);
oSubGroup.Rows[0].Columns.Add(dg_validare_antecalcul.Columns["CSTH_cip"]);
dg_validare_antecalcul.Columns["CSTH_unitar"].HeaderText = "UNITAR";
dg_validare_antecalcul.Columns["CSTH_cip"].HeaderText = "CIP";
oGroup.Groups.Add(oSubGroup);
view.ColumnGroups.Add(oGroup);
// CSTI
oGroup = new GridViewColumnGroup();
oGroup.Text = "CSTI";
oSubGroup = new GridViewColumnGroup();
oSubGroup.Text = "Ch. indirecte de sectie";
oSubGroup.Rows.Add(new GridViewColumnGroupRow());
oSubGroup.Rows[0].Columns.Add(dg_validare_antecalcul.Columns["CSTI_unitar"]);
oSubGroup.Rows[0].Columns.Add(dg_validare_antecalcul.Columns["CSTI_cip"]);
dg_validare_antecalcul.Columns["CSTI_unitar"].HeaderText = "UNITAR";
dg_validare_antecalcul.Columns["CSTI_cip"].HeaderText = "CIP";
oGroup.Groups.Add(oSubGroup);
view.ColumnGroups.Add(oGroup);
// CSTJ
oGroup = new GridViewColumnGroup();
oGroup.Text = "CSTJ";
oSubGroup = new GridViewColumnGroup();
oSubGroup.Text = "Materiale directe";
oSubGroup.Rows.Add(new GridViewColumnGroupRow());
oSubGroup.Rows[0].Columns.Add(dg_validare_antecalcul.Columns["CSTJ_unitar"]);
oSubGroup.Rows[0].Columns.Add(dg_validare_antecalcul.Columns["CSTJ_cip"]);
dg_validare_antecalcul.Columns["CSTJ_unitar"].HeaderText = "UNITAR";
dg_validare_antecalcul.Columns["CSTJ_cip"].HeaderText = "CIP";
oGroup.Groups.Add(oSubGroup);
view.ColumnGroups.Add(oGroup);
// CSTK
oGroup = new GridViewColumnGroup();
oGroup.Text = "CSTK";
oSubGroup = new GridViewColumnGroup();
oSubGroup.Text = "Nevoi proprii directe";
oSubGroup.Rows.Add(new GridViewColumnGroupRow());
oSubGroup.Rows[0].Columns.Add(dg_validare_antecalcul.Columns["CSTK_unitar"]);
oSubGroup.Rows[0].Columns.Add(dg_validare_antecalcul.Columns["CSTK_cip"]);
dg_validare_antecalcul.Columns["CSTK_unitar"].HeaderText = "UNITAR";
dg_validare_antecalcul.Columns["CSTK_cip"].HeaderText = "CIP";
oGroup.Groups.Add(oSubGroup);
view.ColumnGroups.Add(oGroup);
// CSTL
oGroup = new GridViewColumnGroup();
oGroup.Text = "CSTL";
oSubGroup = new GridViewColumnGroup();
oSubGroup.Text = "Chelt. cu scule";
oSubGroup.Rows.Add(new GridViewColumnGroupRow());
oSubGroup.Rows[0].Columns.Add(dg_validare_antecalcul.Columns["CSTL_unitar"]);
oSubGroup.Rows[0].Columns.Add(dg_validare_antecalcul.Columns["CSTL_cip"]);
dg_validare_antecalcul.Columns["CSTL_unitar"].HeaderText = "UNITAR";
dg_validare_antecalcul.Columns["CSTL_cip"].HeaderText = "CIP";
oGroup.Groups.Add(oSubGroup);
view.ColumnGroups.Add(oGroup);
// CSTM
oGroup = new GridViewColumnGroup();
oGroup.Text = "CSTM";
oSubGroup = new GridViewColumnGroup();
oSubGroup.Text = "Ch. transp-aprov.";
oSubGroup.Rows.Add(new GridViewColumnGroupRow());
oSubGroup.Rows[0].Columns.Add(dg_validare_antecalcul.Columns["CSTM_unitar"]);
oSubGroup.Rows[0].Columns.Add(dg_validare_antecalcul.Columns["CSTM_cip"]);
dg_validare_antecalcul.Columns["CSTM_unitar"].HeaderText = "UNITAR";
dg_validare_antecalcul.Columns["CSTM_cip"].HeaderText = "CIP";
oGroup.Groups.Add(oSubGroup);
view.ColumnGroups.Add(oGroup);
// CSTN
oGroup = new GridViewColumnGroup();
oGroup.Text = "CSTN";
oSubGroup = new GridViewColumnGroup();
oSubGroup.Text = "Manopera directa";
oSubGroup.Rows.Add(new GridViewColumnGroupRow());
oSubGroup.Rows[0].Columns.Add(dg_validare_antecalcul.Columns["CSTN_unitar"]);
oSubGroup.Rows[0].Columns.Add(dg_validare_antecalcul.Columns["CSTN_cip"]);
dg_validare_antecalcul.Columns["CSTN_unitar"].HeaderText = "UNITAR";
dg_validare_antecalcul.Columns["CSTN_cip"].HeaderText = "CIP";
oGroup.Groups.Add(oSubGroup);
view.ColumnGroups.Add(oGroup);
// CSTO
oGroup = new GridViewColumnGroup();
oGroup.Text = "CSTO";
oSubGroup = new GridViewColumnGroup();
oSubGroup.Text = "Indexare manop. directa ramasa";
oSubGroup.Rows.Add(new GridViewColumnGroupRow());
oSubGroup.Rows[0].Columns.Add(dg_validare_antecalcul.Columns["CSTO_unitar"]);
oSubGroup.Rows[0].Columns.Add(dg_validare_antecalcul.Columns["CSTO_cip"]);
dg_validare_antecalcul.Columns["CSTO_unitar"].HeaderText = "UNITAR";
dg_validare_antecalcul.Columns["CSTO_cip"].HeaderText = "CIP";
oGroup.Groups.Add(oSubGroup);
view.ColumnGroups.Add(oGroup);
// CSTP
oGroup = new GridViewColumnGroup();
oGroup.Text = "CSTP";
oSubGroup = new GridViewColumnGroup();
oSubGroup.Text = "Ch. salarii colaboratori";
oSubGroup.Rows.Add(new GridViewColumnGroupRow());
oSubGroup.Rows[0].Columns.Add(dg_validare_antecalcul.Columns["CSTP_unitar"]);
oSubGroup.Rows[0].Columns.Add(dg_validare_antecalcul.Columns["CSTP_cip"]);
dg_validare_antecalcul.Columns["CSTP_unitar"].HeaderText = "UNITAR";
dg_validare_antecalcul.Columns["CSTP_cip"].HeaderText = "CIP";
oGroup.Groups.Add(oSubGroup);
view.ColumnGroups.Add(oGroup);
// CSTQ
oGroup = new GridViewColumnGroup();
oGroup.Text = "CSTQ";
oSubGroup = new GridViewColumnGroup();
oSubGroup.Text = "C.A.S. si alte fonduri af.(manop. directe+sporuri)";
oSubGroup.Rows.Add(new GridViewColumnGroupRow());
oSubGroup.Rows[0].Columns.Add(dg_validare_antecalcul.Columns["CSTQ_unitar"]);
oSubGroup.Rows[0].Columns.Add(dg_validare_antecalcul.Columns["CSTQ_cip"]);
dg_validare_antecalcul.Columns["CSTQ_unitar"].HeaderText = "UNITAR";
dg_validare_antecalcul.Columns["CSTQ_cip"].HeaderText = "CIP";
oGroup.Groups.Add(oSubGroup);
view.ColumnGroups.Add(oGroup);
// CSTR
oGroup = new GridViewColumnGroup();
oGroup.Text = "CSTR";
oSubGroup = new GridViewColumnGroup();
oSubGroup.Text = "S.D.V. directe";
oSubGroup.Rows.Add(new GridViewColumnGroupRow());
oSubGroup.Rows[0].Columns.Add(dg_validare_antecalcul.Columns["CSTR_unitar"]);
oSubGroup.Rows[0].Columns.Add(dg_validare_antecalcul.Columns["CSTR_cip"]);
dg_validare_antecalcul.Columns["CSTR_unitar"].HeaderText = "UNITAR";
dg_validare_antecalcul.Columns["CSTR_cip"].HeaderText = "CIP";
oGroup.Groups.Add(oSubGroup);
view.ColumnGroups.Add(oGroup);
// CSTS
oGroup = new GridViewColumnGroup();
oGroup.Text = "CSTS";
oSubGroup = new GridViewColumnGroup();
oSubGroup.Text = "Alte costuri directe";
oSubGroup.Rows.Add(new GridViewColumnGroupRow());
oSubGroup.Rows[0].Columns.Add(dg_validare_antecalcul.Columns["CSTS_unitar"]);
oSubGroup.Rows[0].Columns.Add(dg_validare_antecalcul.Columns["CSTS_cip"]);
dg_validare_antecalcul.Columns["CSTS_unitar"].HeaderText = "UNITAR";
dg_validare_antecalcul.Columns["CSTS_cip"].HeaderText = "CIP";
oGroup.Groups.Add(oSubGroup);
view.ColumnGroups.Add(oGroup);
// CSTT
oGroup = new GridViewColumnGroup();
oGroup.Text = "CSTT";
oSubGroup = new GridViewColumnGroup();
oSubGroup.Text = "Colaborari directe";
oSubGroup.Rows.Add(new GridViewColumnGroupRow());
oSubGroup.Rows[0].Columns.Add(dg_validare_antecalcul.Columns["CSTT_unitar"]);
oSubGroup.Rows[0].Columns.Add(dg_validare_antecalcul.Columns["CSTT_cip"]);
dg_validare_antecalcul.Columns["CSTT_unitar"].HeaderText = "UNITAR";
dg_validare_antecalcul.Columns["CSTT_cip"].HeaderText = "CIP";
oGroup.Groups.Add(oSubGroup);
view.ColumnGroups.Add(oGroup);
// CSTU
//GridViewColumnGroup oGroup1 = new GridViewColumnGroup();
//oGroup1.Text = "";
GridViewColumnGroup oGroupU = new GridViewColumnGroup();
oGroupU.Text = "CSTU";
oSubGroup = new GridViewColumnGroup();
oSubGroup.Text = "Utilitati directe";
oSubGroup.Rows.Add(new GridViewColumnGroupRow());
oSubGroup.Rows[0].Columns.Add(dg_validare_antecalcul.Columns["CSTU_unitar"]);
oSubGroup.Rows[0].Columns.Add(dg_validare_antecalcul.Columns["CSTU_cip"]);
dg_validare_antecalcul.Columns["CSTU_unitar"].HeaderText = "UNITAR";
dg_validare_antecalcul.Columns["CSTU_cip"].HeaderText = "CIP";
oGroupU.Groups.Add(oSubGroup);
//oGroup1.Groups.Add(oGroupU);
view.ColumnGroups.Add(oGroupU);
// CSTV
GridViewColumnGroup oGroupV = new GridViewColumnGroup();
oGroupV.Text = "CSTV";
GridViewColumnGroup oSubGroupV = new GridViewColumnGroup();
oSubGroupV.Text = "Corectii";
oSubGroupV.Rows.Add(new GridViewColumnGroupRow());
oSubGroupV.Rows[0].Columns.Add(dg_validare_antecalcul.Columns["CSTV_unitar"]);
oSubGroupV.Rows[0].Columns.Add(dg_validare_antecalcul.Columns["CSTV_cip"]);
dg_validare_antecalcul.Columns["CSTV_unitar"].HeaderText = "UNITAR";
dg_validare_antecalcul.Columns["CSTV_cip"].HeaderText = "CIP";
oGroupV.Groups.Add(oSubGroupV);
//oGroup1.Groups.Add(oGroupV);
//oGroup1.ShowHeader = false;
//view.ColumnGroups.Add(oGroup1);
view.ColumnGroups.Add(oGroupV);
dg_validare_antecalcul.ViewDefinition = view;[/QUOTE]
Comment any of the of the grouping and fill grid works. With all the groups the fill grid gives error at the last line. In my opinion it is because telerik controls think that there too many groups.
Any help is appreciated and thank you for your time and effort.
In description column, the gridlines are displayed in 2 lines in grid's view row default size, I need it to be viewed in a single line.
Please check the attached image.
Thanks in Advance.
Hi,
some time ago I wrote a custom GridEditor using a TextBoxControlElement with AutoComplete = Suggest.
It works fine but now i need to change the auto complete logic using Contains instead of StartsWith.
I know how to do this in a DropDownList or in a DropDownListElement but can't find a way to get this behaviour in a TextBoxControl and don't want to change the TextBoxControlElement with a DropDownListElement hiding the arrow button.
How can I have a 'contains' AutoComplete in a TextBoxControls ?
Regards
Hello
In a hierarchical GridView I always get a expand button even if the entry has no sub entries. How can I hide it when it has no sub entries?
Thank you very much
Marco
Sorry if this is a bad question but I want to configure the grid lines in the RadGridView. This Post https://www.telerik.com/forums/change-color-of-the-grid---radgridview says I have to use Visual Style Builder and edit the theme.... Do I really have to dig into this massive thing?! Thats a total overload...? All I want is to configure the grid lines?
I'm trying to figure out how to create some padding inside the coordinate space of the chart. Things I have done:
Set categorical axis axisplotmode to OnTicksPadded
Increased Padding on Chart.View.Margins (this seems to be the padding between the chart itself and stuff outside the chart)
See the picture below for an example. Basically datapoints aren't fully displaying because the points are being cutoff because the last Y-axis Tick is literally at the same Y location as the top of the chart. I'd like to move it down a bit to give the datapoints some space. Essentially create extra space around the edges of the axes. I have one axes that's a categorical axis and one that's a linear axis.
Create BarSeries:
_barModel = new BarSeries
{
ValueMember = "Model",
CategoryMember = "N",
LegendTitle = "Model",
IsVisible = false
};
_radChartViewGss.Series.Add(_barModel);
Set data source (dataTable):
_radChartViewGss.DataSource = _table;
After this, changing the property _barModel.IsVisible = true does not lead to anything - the bar series is not visible.
Why???
Hi.
Probably an easy question, but trying for a while, searching in the doc and the forum, I could not find the solution.
When I use a legend in radchartview, it shows the items below each other (vertically). But I would like to show them next to each other (horizontally).
Among others, I tried:
this.radChartView2.ChartElement.LegendElement.TextOrientation = Orientation.Horizontal;
or
this.radChartView2.ChartElement.LegendElement.StackElement.TextOrientation = Orientation.Horizontal;
But it does not seem to work...
Thank you