
i m using this method.maybe helpfull some new developers like me.
public void changeyourcolumnsname()
{string conn="Data Source=yourdatasource; User Id=youruserid; Password=yourpassword; Initial Catalog =yourdataname;";
using
(SqlConnection connection = new SqlConnection(conn))
{
connection.Open();
DataSet ds = new DataSet();
SqlDataAdapter adp = new SqlDataAdapter("select col1,col2,col3,col4 from yourtable",connection);
adp.Fill(ds, "yourtable");
this.radMultiColumnComboBox1.DataSource = ds.Tables[0];
FilterDescriptor descriptor =
new FilterDescriptor(this.radMultiColumnComboBox1.DisplayMember, FilterOperator.StartsWith, string.Empty);
this.radMultiColumnComboBox1.EditorControl.FilterDescriptors.Add(descriptor);
this.radMultiColumnComboBox1.DropDownStyle = RadDropDownStyle.DropDown;
this.radMultiColumnComboBox1.EditorControl.Columns[0].HeaderText = "mycolumns1";//change your col1
this.radMultiColumnComboBox1.EditorControl.Columns[1].HeaderText = "mycolumns2";//change your col2
this.radMultiColumnComboBox1.EditorControl.Columns[2].HeaderText = "mycolumns3";//change your col3
this.radMultiColumnComboBox1.EditorControl.Columns[3].HeaderText = "mycolumns4";//change your col4
connection.Close();
}
private
void yourform_Load(object sender, EventArgs e)
{
this.radMultiColumnComboBox1.AutoSizeDropDownToBestFit = true;
RadMultiColumnComboBoxElement multiColumnComboElement =
this.radMultiColumnComboBox1.MultiColumnComboBoxElement;
multiColumnComboElement.DropDownSizingMode = SizingMode.UpDownAndRightBottom;
multiColumnComboElement.DropDownMinSize =
new Size(420, 300);
multiColumnComboElement.EditorControl.MasterGridViewTemplate.AutoGenerateColumns =
false;
this.radMultiColumnComboBox1.AutoFilter = true;
changeyourcolumnsname();
}
private void TemplateRelations(){ GridViewTemplate template = new GridViewTemplate(); template.Caption = "Tracking Info"; template.DataSource = trackingInfos; gvTrackingInfo.Templates.Add(template); template.AllowRowResize = false; template.ShowColumnHeaders = false; template.ShowRowHeaderColumn = false; template.Columns[0].Width = 800; template.Rows[0].Height = 500; for (int i = 1; i < template.Columns.Count; i++) { template.Columns[i].IsVisible = false; } GridViewRelation relation = new GridViewRelation(this.gvTrackingInfo.MasterTemplate, template); relation.ParentColumnNames.Add("TrackingNumber"); relation.ChildColumnNames.Add("TrackingNumber"); this.gvTrackingInfo.Relations.Add(relation);}private void gvTrackingInfo_CellFormatting(object sender, CellFormattingEventArgs e){ TabContainer tabContainer = new TabContainer(); GridViewDataColumn column = e.CellElement.ColumnInfo as GridViewDataColumn; if (column != null && column.OwnerTemplate.Caption == "Tracking Info") { RadPanel panel = new RadPanel(); tabContainer.Height = 500; tabContainer.Width = 800; panel.Controls.Add(tabContainer); panel.TextAlignment = ContentAlignment.MiddleCenter; e.Row.Height = 500; e.Column.Width = 800; e.CellElement.Children.Add(new RadHostItem(panel)); } }[-------- Category A --------][-------- Cat B --------][-------- Category C --------][--- Col 1 ---][--- Col 2 ---][------- Col 3 --------][--- Col 4 ---][--- Col 5 ---]