Intersoft Community - WebCombo - Show data from Multiple column when user selects a record

Show data from Multiple column when user selects a record

Glayaar — Tue, 30 Mar 2010 06:05:13 GMT

Could you provide us with a running sample for what you are trying to do, or provide us with a snippet code for the event handler where you are trying to change the WebCombo data source.

This will allow us to replicate the scenario you are facing more accurately.

Show data from Multiple column when user selects a record

huzzy143 — Tue, 30 Mar 2010 02:15:26 GMT

Hi,
The AutoComplete feature worked like a charm.

Regarding the missing WebCombo text, in such scenario you will need to fill the virtual column (in this case FullName) as you set the value to the WebCombo. The InitializeRow server side event will be invoked when you show the WebCombo dropdown, in your scenario the InitializeRow will not be triggered.

Can you please provide a sample or a proper code to illustrate how would i do this thing?

I am just getting a DataTable consisting of 1 row which is filetered on the Value in DTO object, and attaching this DataTable to WebCombo. I even add an extra column in DataTable for FullName and give its Value but nothing is shown on client side and TextBox of WebCombo remains empty.

Thanks,

Huzefa

Thanks,

Huzefa

Show data from Multiple column when user selects a record

Glayaar — Sun, 28 Mar 2010 21:54:45 GMT

In order to automatically set the WebCombo value to the shown dropdown item you will need to use EntryMode AutoComplete instead of InstantLookup.

Regarding the missing WebCombo text, in such scenario you will need to fill the virtual column (in this case FullName) as you set the value to the WebCombo. The InitializeRow server side event will be invoked when you show the WebCombo dropdown, in your scenario the InitializeRow will not be triggered.

Other suggestion regarding your scenario would be modifying the select query from the database. Instead of SELECT UserID, FirstName, LastName FROM [Users], please use SELECT UserID, FirstName, LastName, FirstName + ' ' + LastName AS FullName FROM [Users]

Show data from Multiple column when user selects a record

huzzy143 — Sun, 28 Mar 2010 04:10:28 GMT

Hi,

In order to allow the instant lookup feature to work you will need to use AdditionalSearchField property in order to allow WebCOmbo to search in the FirstName and LastName field, for example.

How to set Multiple AdditionalSearchFields?

I have set the FirstName as AdditionalSearchField but when i type in a Name and press Tab, then the Filtered record is just 1 record but it doesn't get set, instead the DropDown result box opens up and i have to explicitly select a record.

What i want is after user Press Tab key and after filter if the number of records returned is just 1 then automatically set the Value and Text of that record. How can i achieve this?

On the server side, you will need to set the Value property in order to set the default choice in WebCombo, as detailed on the article How-to: Set initial value from server side in WebCombo in the WebCombo documentation.

I am not using any DataSource control instead i am Binding Data on InitializeDataSource Method.

I am checking if Action!="LoadData" and Value is set to something and Text is empty, then go to database filter the record on Value and get 1 record. After getting this one record i attach it to DataSource property of WebCombo. The Issue is i am adding a temporary column as you suggested and setting its text and value on InitializeRow event, but this event doesn't get called at all. And the text is not set. The WebCombo TextBox comes with empty text. Am i missing somehting?

Basically i want a LoadOnDemand functionality but i don't wanna use ISDataSource control or ObjectDataSource Control. Instead i manually call database and get a DataTable and bind this DataTable to DataSource of webCombo.

What would be the best approach for this?

Show data from Multiple column when user selects a record

Glayaar — Fri, 26 Mar 2010 02:58:18 GMT

The instant lookpup feature will not work if it is set to a hidden column. In order to allow the instant lookup feature to work you will need to use AdditionalSearchField property in order to allow WebCOmbo to search in the FirstName and LastName field, for example.

Our WebCombo documentation already have an article regarding AdditionalSearchField on the article titled Additional Search Field and How-to: Use AdditionalSearchField to search a query text on other column besides DataTextField column

Unfortunately both classic paging and filter on a specific column feature has not been supported in the current version of WebCombo.

On the server side, you will need to set the Value property in order to set the default choice in WebCombo, as detailed on the article How-to: Set initial value from server side in WebCombo in the WebCombo documentation. In the client side you could set the choice using the text by executing the SetTextBoxValue function, as detailed on the article How-to: Get/Set the TextBox value in the WebCombo documentation

Show data from Multiple column when user selects a record

huzzy143 — Thu, 25 Mar 2010 09:17:13 GMT

Hi Glenn,

Thanks for this solutions, it worked like a charm.

Few questions i want to ask you,

1) I want this combo to have Instant Lookup functionality as provided in your samples. But after i apply your above solution the instant lookup thing doesn't work. Can you provide a solution to get it proper on some real column.

2) How can i have more than 1 AdditionalFilterColumn in combo?

3) How can i have paging in combo instead of More button?

4) I want something like filter bar on top of each column so that after the dropdown is open user can filter on any additional column he wishes to. Can i do this in WebCombo? I need it please provide a way.

5) Once the user have selected a value and have posted the selection to server. Now i want to display the user his choice back. I have the user selected Id field value and want to set its Text to webCombo how can i do this? As Text property of WebCombo doesn't have a Setter. How can i achieve this?

Thanks,

Huzefa

Show data from Multiple column when user selects a record

Glayaar — Mon, 22 Mar 2010 23:39:08 GMT

For your scenario, you could add the new column to the datasource during IntializeDataSource server side event

protected void Combo1_InitializeDataSource(object sender, ISNet.WebUI.WebCombo.DataSourceEventArgs e)
{
    DataTable dtData = new DataTable();
    dtData.Columns.AddRange(new DataColumn[]{
        new DataColumn("UserID"),
        new DataColumn("FirstName"),
        new DataColumn("LastName"),
        new DataColumn("Age"),
        new DataColumn("Gender")
    });

    dtData.Rows.Add(new object[] { "1", "Tom", "Blanks", "50", "Male"});
    dtData.Rows.Add(new object[] { "2", "Peter", "Schuler", "30", "Male" });
    dtData.Rows.Add(new object[] { "3", "Kareena", "Kapoor", "24", "Female" });
    dtData.Rows.Add(new object[] { "4", "John", "Doe", "40", "Male" });

    dtData.Columns.Add(new DataColumn("FullName"));

    dtData.AcceptChanges();

    e.DataSource = dtData;
}

In order to fill the FullName data, you could use the InitializeRow server side event handler

protected void Combo1_InitializeRow(object sender, RowEventArgs e)
{
    WebComboCell fName = e.Row.Cells.GetNamedItem("FirstName");
    WebComboCell lName = e.Row.Cells.GetNamedItem("LastName");
    WebComboCell fullName = e.Row.Cells.GetNamedItem("FullName");

    fullName.Value = String.Join(" ", new string[] { fName.Text, lName.Text });
    fullName.Text = String.Join(" ", new string[] { fName.Text, lName.Text });
}

Regarding my earlier post to create the column programmatically, in order to render the hidden correctly, you will need to use the InitializeLayout server side event instead of PrepareDataBinding.

Show data from Multiple column when user selects a record

huzzy143 — Mon, 22 Mar 2010 03:50:51 GMT

If i have 50,000 rows and i dyanmically loop through datasource and add an extra column then it would be a big performance bottleneck.

Can't i just add temporray column to those records which are currently shown to user.

Like for first 15 rows i create a temporary column and display to user, then when user clicks for more then i create a temporray record for remaining 15 rows and so on...

Please suggest me a proper way if the number of records are more than 50,000.

Thanks,

Huzefa

Show data from Multiple column when user selects a record

Glayaar — Mon, 22 Mar 2010 02:48:45 GMT

Unfortunately, for the scenario to work without any issue you will need to use the temporary column in the datasource technique.

IF you would like to create the column dynamically, you will need to use the PrepareDataBinding server side event handler. Here is the snippet:

protected void Combo1_PrepareDataBinding(object sender, ISNet.WebUI.WebCombo.DataSourceEventArgs e)
{
    WebComboColumn fullName = new WebComboColumn();
    fullName.BaseFieldName = "FullName";
    fullName.HeaderText = "Full name";
    fullName.Name = "FullName";
    fullName.Hidden = true;
    fullName.RenderOnHidden = true;
    Combo1.Columns.Add(fullName);

    WebComboColumn firstName = new WebComboColumn();
    firstName.BaseFieldName = "FirstName";
    firstName.HeaderText = "First Name";
    firstName.Name = "FirstName";
    firstName.Width = Unit.Pixel(150);
    Combo1.Columns.Add(firstName);

    WebComboColumn lastName = new WebComboColumn();
    lastName.BaseFieldName = "LastName";
    lastName.HeaderText = "Last Name";
    lastName.Name = "LastName";
    lastName.Width = Unit.Pixel(150);
    Combo1.Columns.Add(lastName);

    WebComboColumn age = new WebComboColumn();
    age.BaseFieldName = "Age";
    age.HeaderText = "Age";
    age.Name = "Age";
    age.Width = Unit.Pixel(50);
    Combo1.Columns.Add(age);

    WebComboColumn gender = new WebComboColumn();
    gender.BaseFieldName = "Gender";
    gender.HeaderText = "Gender";
    gender.Name = "Gender";
    gender.Width = Unit.Pixel(100);
    Combo1.Columns.Add(gender);
}

Templating has not been supported in the latest version of WebCombo. Currently integration between WebCombo and WebGrid is limited to WebCombo as an EditColumnType in the WebGrid.

Show data from Multiple column when user selects a record

huzzy143 — Sat, 20 Mar 2010 01:27:25 GMT

Thanks Glenn

But merging it into one column won't be a great idea in my case. Can't i set a Text on my own using javascript methods?

Can you also send me a example were columns for MultiColumn Mode are added dyanmically?
Also is Templatting being supported? Can i add a WebGrid to be shown when result/data is shown?

Thanks,
Huzefa

Show data from Multiple column when user selects a record

huzzy143 — Thu, 18 Mar 2010 02:02:24 GMT

Hi,

I have a multi column Web Combo, now i few columns like FirstName,Lastname,Age and Gender.

Now when user selects a particular record i want to show that records FirstName + LastName to the user as its TextField.

e.g. FirstName LastName Age Gender

Tom Blanks 50 Male

Peter Schuler 30 Male

Kareena Kapoor 24 Female

Now i select the Second record then the text Shown on Form to user should = > Peter Schuler not just Peter.

How can i achieve this?

Thanks,