Questions on UI for WinForms Forum

11 answers

183 views

[Solved] Heirarchy '+' does not expand and does not show me grid below it

i am using the code given below to add a grid template .in this controls are
dgrdsubcategory -> RAD GRID
category is the table from database it returns

Please Reply at earliest

dgrdSubCategory.AutoGenerateHierarchy = true;

SqlDataAdapter sdaCatid = null;

DataSet dsCatid = new DataSet();

DataSet dsGrid = DBFunctions.FillRadDataGirdReturnDS("category where parentcatid IN (select catid from category where catname='" + TV1.SelectedNode.Text + "')", dgrdSubCategory);

for (int i = 0; i < dsGrid.Tables[0].Rows.Count; i++)

{

DataRow drow = dsGrid.Tables[0].Rows[i];

sdaCatid = FillDataset("category where parentcatid='" + drow["catid"] + "'");

sdaCatid.Fill(dsCatid);

}

GridViewTemplate template = new GridViewTemplate();

template.DataSource = dsCatid.Tables[0];

//i get values in the template variable

dgrdSubCategory.MasterGridViewTemplate.ChildGridViewTemplates.Add(template);

GridViewRelation relation = new GridViewRelation(dgrdSubCategory.MasterTemplate);

relation.ChildTemplate = template;

relation.RelationName = "SubCategory";

relation.ParentColumnNames.Add("catid");

relation.ChildColumnNames.Add("catid");

dgrdSubCategory.Relations.Add(relation);

radGrid1.DataSource = template;



///But though i have done this i dont get the corresponding result.

//It shows a "+" sign but nothing comes under it when clicked on "+"



public static SqlDataAdapter FillDataset(string strTableName)  { 

ds = new SqlDataAdapter();

sda=new SqlDataAdapter();

 conn = new SqlConnection();

conn.ConnectionString = ConfigurationSettings.AppSettings["conString"];

string strCmd = "select * from " + strTableName;

sqlcommand sqlCmd = new SqlCommand(strCmd, conn);

                sda = new SqlDataAdapter(sqlCmd);

                //sda.Fill(ds);

                //dgrdv.DataSource = ds.Tables[0];            

}
            catch (Exception excep)
            {
                MessageBox.Show("" + excep.Message + "  Stack Trace:" + excep.StackTrace, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
            return sda;
        }
lic static SqlDataAdapter FillDataset(string strTableName)
        {
            SqlDataAdapter ds = new SqlDataAdapter();
            SqlDataAdapter sda=new SqlDataAdapter();
            try
            {
                SqlConnection conn = new SqlConnection();
                conn.ConnectionString = ConfigurationSettings.AppSettings["conString"];
                string strCmd = "select * from " + strTableName;
                SqlCommand sqlCmd = new SqlCommand(strCmd, conn);
                sda = new SqlDataAdapter(sqlCmd);
                //sda.Fill(ds);
                //dgrdv.DataSource = ds.Tables[0];



            }
            catch (Exception excep)
            {
                MessageBox.Show("" + excep.Message + "  Stack Trace:" + excep.StackTrace, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
            return sda;
        }

dgrdSubCategory.AutoGenerateHierarchy = true;

SqlDataAdapter sdaCatid = null;

DataSet dsCatid = new DataSet();

DataSet dsGrid = DBFunctions.FillRadDataGirdReturnDS("category where parentcatid IN (select catid from category where catname='" + TV1.SelectedNode.Text + "')", dgrdSubCategory);

for (int i = 0; i < dsGrid.Tables[0].Rows.Count; i++)

{

DataRow drow = dsGrid.Tables[0].Rows[i];

sdaCatid = FillDataset("category where parentcatid='" + drow["catid"] + "'");

sdaCatid.Fill(dsCatid);

}

int count = dsCatid.Tables[0].Rows.Count;

GridViewTemplate template = new GridViewTemplate();

template.DataSource = dsCatid.Tables[0];

dgrdSubCategory.MasterGridViewTemplate.ChildGridViewTemplates.Add(template);

GridViewRelation relation = new GridViewRelation(dgrdSubCategory.MasterTemplate);

relation.ChildTemplate = template;

relation.RelationName = "SubCategory";

relation.ParentColumnNames.Add("catid");

relation.ChildColumnNames.Add("catid");

dgrdSubCategory.Relations.Add(relation);

radGrid1.DataSource = template;

dgrdSubCategory.AutoGenerateHierarchy = true;

SqlDataAdapter sdaCatid = null;

DataSet dsCatid = new DataSet();

DataSet dsGrid = DBFunctions.FillRadDataGirdReturnDS("category where parentcatid IN (select catid from category where catname='" + TV1.SelectedNode.Text + "')", dgrdSubCategory);

for (int i = 0; i < dsGrid.Tables[0].Rows.Count; i++)

{

DataRow drow = dsGrid.Tables[0].Rows[i];

sdaCatid = FillDataset("category where parentcatid='" + drow["catid"] + "'");

sdaCatid.Fill(dsCatid);

}

int count = dsCatid.Tables[0].Rows.Count;

GridViewTemplate template = new GridViewTemplate();

template.DataSource = dsCatid.Tables[0];

dgrdSubCategory.MasterGridViewTemplate.ChildGridViewTemplates.Add(template);

GridViewRelation relation = new GridViewRelation(dgrdSubCategory.MasterTemplate);

relation.ChildTemplate = template;

relation.RelationName = "SubCategory";

relation.ParentColumnNames.Add("catid");

relation.ChildColumnNames.Add("catid");

dgrdSubCategory.Relations.Add(relation);

radGrid1.DataSource = template;

dgrdSubCategory.AutoGenerateHierarchy = true;

SqlDataAdapter sdaCatid = null;

DataSet dsCatid = new DataSet();

DataSet dsGrid = DBFunctions.FillRadDataGirdReturnDS("category where parentcatid IN (select catid from category where catname='" + TV1.SelectedNode.Text + "')", dgrdSubCategory);

for (int i = 0; i < dsGrid.Tables[0].Rows.Count; i++)

{

DataRow drow = dsGrid.Tables[0].Rows[i];

sdaCatid = FillDataset("category where parentcatid='" + drow["catid"] + "'");

sdaCatid.Fill(dsCatid);

}

int count = dsCatid.Tables[0].Rows.Count;

GridViewTemplate template = new GridViewTemplate();

template.DataSource = dsCatid.Tables[0];

dgrdSubCategory.MasterGridViewTemplate.ChildGridViewTemplates.Add(template);

GridViewRelation relation = new GridViewRelation(dgrdSubCategory.MasterTemplate);

relation.ChildTemplate = template;

relation.RelationName = "SubCategory";

relation.ParentColumnNames.Add("catid");

relation.ChildColumnNames.Add("catid");

dgrdSubCategory.Relations.Add(relation);

radGrid1.DataSource = template;

dgrdSubCategory.AutoGenerateHierarchy = true;

SqlDataAdapter sdaCatid = null;

DataSet dsCatid = new DataSet();

DataSet dsGrid = DBFunctions.FillRadDataGirdReturnDS("category where parentcatid IN (select catid from category where catname='" + TV1.SelectedNode.Text + "')", dgrdSubCategory);

for (int i = 0; i < dsGrid.Tables[0].Rows.Count; i++)

{

DataRow drow = dsGrid.Tables[0].Rows[i];

sdaCatid = FillDataset("category where parentcatid='" + drow["catid"] + "'");

sdaCatid.Fill(dsCatid);

}

int count = dsCatid.Tables[0].Rows.Count;

GridViewTemplate template = new GridViewTemplate();

template.DataSource = dsCatid.Tables[0];

dgrdSubCategory.MasterGridViewTemplate.ChildGridViewTemplates.Add(template);

GridViewRelation relation = new GridViewRelation(dgrdSubCategory.MasterTemplate);

relation.ChildTemplate = template;

relation.RelationName = "SubCategory";

relation.ParentColumnNames.Add("catid");

relation.ChildColumnNames.Add("catid");

dgrdSubCategory.Relations.Add(relation);

radGrid1.DataSource = template;

dgrdSubCategory.AutoGenerateHierarchy = true;

SqlDataAdapter sdaCatid = null;

DataSet dsCatid = new DataSet();

DataSet dsGrid = DBFunctions.FillRadDataGirdReturnDS("category where parentcatid IN (select catid from category where catname='" + TV1.SelectedNode.Text + "')", dgrdSubCategory);

for (int i = 0; i < dsGrid.Tables[0].Rows.Count; i++)

{

DataRow drow = dsGrid.Tables[0].Rows[i];

sdaCatid = FillDataset("category where parentcatid='" + drow["catid"] + "'");

sdaCatid.Fill(dsCatid);

}

int count = dsCatid.Tables[0].Rows.Count;

GridViewTemplate template = new GridViewTemplate();

template.DataSource = dsCatid.Tables[0];

dgrdSubCategory.MasterGridViewTemplate.ChildGridViewTemplates.Add(template);

GridViewRelation relation = new GridViewRelation(dgrdSubCategory.MasterTemplate);

relation.ChildTemplate = template;

relation.RelationName = "SubCategory";

relation.ParentColumnNames.Add("catid");

relation.ChildColumnNames.Add("catid");

dgrdSubCategory.Relations.Add(relation);

radGrid1.DataSource = template;

dgrdSubCategory.AutoGenerateHierarchy = true;

SqlDataAdapter sdaCatid = null;

DataSet dsCatid = new DataSet();

DataSet dsGrid = DBFunctions.FillRadDataGirdReturnDS("category where parentcatid IN (select catid from category where catname='" + TV1.SelectedNode.Text + "')", dgrdSubCategory);

for (int i = 0; i < dsGrid.Tables[0].Rows.Count; i++)

{

DataRow drow = dsGrid.Tables[0].Rows[i];

sdaCatid = FillDataset("category where parentcatid='" + drow["catid"] + "'");

sdaCatid.Fill(dsCatid);

}

int count = dsCatid.Tables[0].Rows.Count;

GridViewTemplate template = new GridViewTemplate();

template.DataSource = dsCatid.Tables[0];

dgrdSubCategory.MasterGridViewTemplate.ChildGridViewTemplates.Add(template);

GridViewRelation relation = new GridViewRelation(dgrdSubCategory.MasterTemplate);

relation.ChildTemplate = template;

relation.RelationName = "SubCategory";

relation.ParentColumnNames.Add("catid");

relation.ChildColumnNames.Add("catid");

dgrdSubCategory.Relations.Add(relation);

radGrid1.DataSource = template;

GridView

answered on 19 Nov 2010

4 answers

139 views

Want different node name from path generated

Hi,

I have a RadTreeView with a list of nodes, each of which should have a count after them.

Root (10)
-- Cars (20)
---- Ford (12)
---- Chrysler (2)
---- GM (30)

I realize I can use the tag to store a "value" for the node independent of the display format - I'm already doing that. However, when I export the data in the table, I make use of the convenient "Path" property to flatten out the hierarchy. Is there a way to generate the Path from the Tag property rather than from the Text property?

How would you go about exporting this to a list that looks like this?:

Root
Root/Cars
Root/Cars/Ford
Root/Cars/Chrysler
Root/Cars/GM

I'd rather not write the code to walk the tree and construct the paths myself - but it's the most practical solution I can think of.

Treeview

answered on 19 Nov 2010

1 answer

216 views

wrap text in RAD tree view

can i wrap text in RAD tree View control

Treeview

answered on 19 Nov 2010

6 answers

219 views

[Solved] RadGridView loses format when it is updated.

Hi, in my program I have a RadGridView. Some of the cells are formatted with different backgroundcolor or they are disabled. The first time I bind the grid with data read from a table of a database it shows correct but If I update the grid it loses the format (All the cells are white and enabled) .

The cells are formatted according to this approach http://www.telerik.com/community/forums/winforms/gridview/createcell-event-cellelement-is-always-null.aspx (First it sets a tag for each cell in DataBindingComplete and subsequently depending on this value it sets backcolor and enabled properties for the cell.)

Here is the code (Cheers to Emanuel Varga for it):

void radGridView1_CellFormatting(object sender, CellFormattingEventArgs e)

{

if (e.CellElement.RowInfo.Cells[0].Tag != null && e.CellElement.RowInfo.Cells[0].Tag.Equals(true))

{

e.CellElement.BackColor = Color.Red;

e.CellElement.DrawFill = true;

}

else

{

e.CellElement.ResetValue(LightVisualElement.BackColorProperty, ValueResetFlags.Local);

e.CellElement.ResetValue(LightVisualElement.DrawFillProperty, ValueResetFlags.Local);

}

void radGridView1_DataBindingComplete(object sender, GridViewBindingCompleteEventArgs e)

{

foreach (var row in radGridView1.Rows)

{

if (row.Index % 2 == 0)

{

row.Cells[0].Tag = true;

}

Thanks for the answers.

GridView

answered on 19 Nov 2010

4 answers

239 views

[Solved] PageView How to change Close Button ToolTip

Hi,

I would like to change tooltip value which is ('Close Page') on PageView's close button because my application is in French.
I searched but I didn't find how to do it ?

Could you help me please ?

Thanks

best regards.

Fred

PageView

answered on 19 Nov 2010

2 answers

215 views

Hiding GroupPanel

Hi

I tried to hide the GroupPanel and for that I set the ShowGroupPanel property to fasle but nothing change.

I'm using version Q2 2010

Can someone help me with that ?

Thank u,

GridView

answered on 19 Nov 2010

7 answers

651 views

[Solved] people picker / contact selector

In a current project we need a people picker (validator - against AD preferably), like the one eg. Sharepoint but can't seem to find one anywhere. Does Telerik provide something like it or does anyone else know of such control/dialog?

TextBox

answered on 19 Nov 2010

2 answers

389 views

Raddropdownbutton multi select checkbox column

HI,

could you please give some more explanantion about your previous reply....am new to telerik . i have created and loaded the raddropdownbutton with checkbox columns, i have written code as below

public partial class DropDownButton : Telerik.WinControls.UI.RadForm

{

RadGridView grid;

RadHostItem hostItem;

string str = string.Empty;

Workaround.childtemplate.GridMenuItem item = new Workaround.childtemplate.GridMenuItem();

public DropDownButton()

{

InitializeComponent();

}

private void DropDownButton_Load(object sender, EventArgs e)

{

SqlConnection con = new SqlConnection("Data Source=ISDTP0026;Initial Catalog=LibraryManagement;Integrated Security=True");

con.Open();

DataSet ds = new DataSet();

SqlDataAdapter adp = new SqlDataAdapter("select CallNumber,Author from Books", con);

adp.Fill(ds);

item.Grid.DataSource = ds.Tables[0].DefaultView;

GridViewCheckBoxColumn chk = new GridViewCheckBoxColumn();

chk.DataType = typeof(bool);

chk.HeaderText = "";

chk.ReadOnly = false;

item.Grid.Columns.Insert(0, chk);

item.Grid.Columns[0].HeaderText = "Select";

item.Grid.Columns[1].ReadOnly = true;

item.Grid.Columns[2].ReadOnly = true;

item.Grid.ReadOnly = false;

item.Grid.ShowGroupPanel = false;

item.Grid.AutoSizeRows = true;

item.Grid.SelectionMode = GridViewSelectionMode.FullRowSelect;

item.Grid.MultiSelect = true;

item.Grid.SelectionMode = GridViewSelectionMode.FullRowSelect;

item.Grid.MultiSelect = true;

item.Grid.MasterGridViewTemplate.AllowAddNewRow = false;

item.Grid.MasterGridViewTemplate.AllowDeleteRow = false;

item.Grid.MasterGridViewTemplate.AllowEditRow = true;

item.Grid.MasterGridViewTemplate.ShowRowHeaderColumn = false;

item.Grid.MasterGridViewTemplate.AutoSizeColumnsMode = Telerik.WinControls.UI.GridViewAutoSizeColumnsMode.Fill;

item.Grid.MasterGridViewTemplate.BestFitColumns();

item.Grid.Size = new Size(400, 300);

radDropDownButton1.Items.Add(item);

}

private void radDropDownButton1_DropDownClosed(object sender, EventArgs e)

{

// here only i need to store the selected value

foreach (GridViewRowInfo rowInfo in item.Grid.Rows)

{

for (int row = 0; row < item.Grid.Rows.Count; row++)

{

if (item.Grid.Rows[row].IsSelected)

{

string str = item.Grid.Rows[row].Cells[0].Value.ToString();

}

}

while dropdown closed event , how to get the selected rows and values....???

Please guide me it very urgent.... thanks in advance...

Thanks

Dev.

DropDownList

answered on 19 Nov 2010

2 answers

472 views

Is there anyway I can disable theming?

As I've reported before, the initial load time of my MDI Application is unacceptable. I searched around and found out that most of the initialization occurs in relation to themes. Is there a way I can disable themes for the entire application?

Thanks

EB

General Discussions

answered on 18 Nov 2010

2 answers

108 views

[Solved] How to bind screen tips with images on a databind radgridview

Hello,

I have a RadGridView that is bind from a datatable. How do I turn on screen tips with images assign to the rows when user hover mouse over a row? Of course I would have to determine which images to use by the column and row index. But how do I assign a pop up screen tips with a image? My images are in a folder in my local drive.

Thanks.

GridView

answered on 18 Nov 2010