Questions on UI for WinForms Forum

7 answers

202 views

disable / remove inline editor?

Hi,

like the title it says. is there a property / way to disable the inline editor? Cant find such an option.

greetz

Scheduler and Reminder

answered on 22 Jun 2011

1 answer

175 views

Issue binding to DataSet with two Tables

Hello,
I have a dataset containing two tables. One of the tables is the Customer table and the other one is the customer Purchases table. They have a one to many relationship; each customer can have more than one purchases.
I can't get the RadTreeView to dispay anything related to the Customer or Purchases. They only thing the TreeView displays is the following: System.Data.DataViewManagerListTypeDescriptor. That looks like an error message!?
What am I doing wrong?
I've been struggling with this for an entire day; trying anythign under the sun.
I am using the newest RadTreeView control.

My datbase tables look as follows:

Customer table
====================
ID (autoincrement unique ID)
CustomerName

Purchases table
=============
PurchasesID (autoincrement unique ID)
Customer_ID (foreign key to ID in Customer table)

In the tree view, the customer's purchases should show up underneath each customer's name.
Here is my code:

private void frmMain_Load(object sender, EventArgs e)

{

DataSet ds = new DataSet();

DataRelation relation;

string connectionString = "server=MYSQLSERVER;database=MyStore;uid=FakeUserID;pwd=FakePassword";

SqlConnection mySqlConnection = new SqlConnection(connectionString);

string strCustomer_Query = "Select * from Customer";

string strPurchases_Query = "Select * from Purchases";

try

{

SqlCommand sql_Customer = new SqlCommand(strCustomer_Query, mySqlConnection);

SqlDataAdapter da = new SqlDataAdapter(sql_Customer);

da.Fill(ds, "Customer");

da.SelectCommand.CommandText = strPurchases_Query;

da.Fill(ds, "Purchases");

// Add the relation. Maybe this is not needed because we use the RelationBindings of the RadTreeView

DataColumn parentCol = ds.Tables["Customer"].Columns["ID"];

DataColumn childCol = ds.Tables["Purchases"].Columns["Customer_ID"];

relation = new DataRelation("Customer_Purchases", parentCol, childCol);

ds.Relations.Add(relation);

treeView1.ShowLines = true;

treeView1.RelationBindings.Add(new RelationBinding(ds, "CustomerName", "Customer_ID", "PurchaseID", "ID"));

treeView1.DataSource = ds;

treeView1.DisplayMember = "CustomerName";

treeView1.ValueMember = "ID";

treeView1.ParentMember = "ID";

treeView1.ChildMember = "PurchaseID";

treeView1.ExpandAll();

}

Please help.
Thank you!

Treeview

answered on 22 Jun 2011

1 answer

126 views

How to locate the node needed?

Hello,Telerik
   Really I meet trouble when I use Radtreeview on winform .
   My business is the order including products,and product belongs to one category,category is tree-structure.
   In the product Adding-Form,I select the category from the Category-tree is OK.
But When I want to modify the product detail information,How can I locate the current product Category-ID among the Category Tree..
such as

             ProductDAO productDao = new ProductDAO();
            Product product = productDao.GetProductDetailByProductId(productId);
            tbxProductName.Text = product.ProductName;
            tbxProductNote.Text = product.Remark;
            tbxProductPrice.Value = product.Price.Value;
            tbxProductQuantity.Value = (decimal)product.ProductCount.Value;
            tbxUnit.Text = product.Unit;
            ProductCategory proCategory = productDao.GetCategoryByCategoryId(product.ProductCategoryID.Value);
            GotoSelectNode(proCategory.CategoryName);
My Category Tree is :

private void InitPvProductCategoryTree()
{
ProductDAO proDao = new ProductDAO();

            List<ProductCategory> categorys = proDao.GetAllCategoryList("");
            tbxCategroy.DisplayMember = "CategoryName";
            this.tbxCategroy.ValueMember = "ProductCategoryID";
            this.tbxCategroy.ParentIDMember = "ParentID";
            this.tbxCategroy.DataSource = categorys;

// this.tbxCategroy.DataMember = "Nodes";

}

How to Implement the method of GotoSelectNode?
My Telerik version is 2010 q3

Thanks .Hope your reply.

Treeview

answered on 22 Jun 2011

4 answers

178 views

[Solved] Copy data from RadGridComboBoxColumn

Hi, I'm currently implementing Copy to Excel functionality and it works great for all but Combo/MultiCombo columns.

I'm trying to implement it in a generic way so I don't want to cast the data source of the combo and find the value from there. Is there a simple way to reach the Displayed data?

Thanks!

private string ConvertDataToString(bool onlySelectedRows)

{

StringBuilder sbTextData = new StringBuilder();

// Copy columns header

foreach (GridViewColumn col in this.radGridView.Columns)

{

sbTextData.Append(col.HeaderText.Replace("\n", " ") + "\t");

}

sbTextData.Append("\n");

// Convert only selected rows

if (onlySelectedRows)

{

foreach (GridViewRowInfo row in this.radGridView.SelectedRows)

{

int i = 0;

while (i < row.Cells.Count)

{

if (i > 0)

{

sbTextData.Append("\t");

}

if (row.Cells[i].ColumnInfo is GridViewComboBoxColumn)

{

// Obtain displayed data

}

else if (row.Cells[i].Value == null)

{

sbTextData.Append(string.Empty);

}

else

{

sbTextData.Append(row.Cells[i].Value.ToString());

}

i++;

}

sbTextData.Append("\n");

}

else

{

foreach (GridViewRowInfo row in this.radGridView.Rows)

{

int i = 0;

while (i < row.Cells.Count)

{

if (i > 0)

{

sbTextData.Append("\t");

}

if (row.Cells[i].Value == null)

{

sbTextData.Append(string.Empty);

}

else

{

sbTextData.Append(row.Cells[i].Value.ToString());

}

i++;

}

sbTextData.Append("\n");

}

return sbTextData.ToString();

}

GridView

answered on 21 Jun 2011

1 answer

321 views

[Solved] Autocomplete logic with 'Contains' instead of 'Starts with' on GridViewComboBoxColumn

Hi, I'm looking for a way to modify the AutoComplete mechanism to filter using 'Contains' instead of 'Starts with' when the user types.

I've seen this functionality is available on the ASP.NET and WPF controls, but haven't found a way to use it or implement it my own way with the WinForms controls.

Thanks!

GridView

answered on 21 Jun 2011

2 answers

174 views

GridViewComboBoxColumn as a list of values

Hi, I would like to have a ComboBox column in my grid that would be used as a list of values that the user can select, modify or use a new one.

I mapped the ValueMember to a string property of my custom object and set the DropDownStyle to DropDown. It gets saved properly, but I cannot edit the value nor add a 'custom' one.

I can't find a property that let me do that, am I doing something wrong or that functionality is not present?

Also, I would like to be able to add new lines, as it is possible in the GridViewTextBoxColumn but it doesn't seem possible in the ComboBoxColumn.

Thanks!

GridView

answered on 21 Jun 2011

1 answer

134 views

How to implement customize column in telerik winform?

Hello,Telerik.
I want to show list of orders in RadGridView .One order includes columns of orderId,orderName,productId ,etc.
en.How can I show productName (in another list or table in DB,include productId ,productName,etc) in RadGridView with orders ?
Can I customize one virual column of showing productName through some methods?
thanks.Hope your reply.

GridView

answered on 21 Jun 2011

2 answers

392 views

RadPageView didn't release the previous page selection.

Hi!
Im using VB.NET and had created a RadPageView with 2 page.

1st page call = A
2nd page call = B

When first time load A is an default selected page.
When i click on page B it will do checking either file is exist.
if not exist than msgbox will popup and use code to select back the page A

Display page of A is correct but the B button is still in selected mode.
Mean i can see 2 page is selected.

My viewmode for the RadPageVIew is STACK

Hope to get the reply soon.

Thank you!

Regards
Johnny

PageView

answered on 21 Jun 2011

1 answer

180 views

Changing cell backColor problem

hi
i am developing an online trading application using telerik winfroms products and i have a very annoying scenario;
i am using rad Gridview to represent the marked data, when some updates comes from the server i have to update the data in the grid with this feed and change the cell back color based on that data, if the new value is greater than the old value i have to change the cell back color to green and if the new value is less than the old value i have to change the cell back color to red, The problem is i can't change the cell back Color in any method in my form and when i use the CellFormatting event i can't know the old value to make the compare and i can't store this old value in a global variable because its a muti threading application and the updates come so fast.
any ideas?
thank you

GridView

answered on 21 Jun 2011

4 answers

348 views

Scroll to child row

I have a hierarchic GridView and I want to scroll to the selected row after a new databind of the control.
If I do

this.radGridView1.TableElement.ScrollToRow(this.radGridView1.CurrentRow);

no problem if the current row is a parent row but if the current row is a child row the GridView scroll to the end.
How to scroll to a selected child row?
Thanks

GridView

answered on 21 Jun 2011