Intersoft Community - WebGrid Enterprise - Suggestion on binding WebValueList during adding a new row

Suggestion on binding WebValueList during adding a new row

yudi — Mon, 23 Nov 2015 02:04:21 GMT

Glad to know that OnExitEditMode/OnAfterItemSelected helps.

Should you need further assistance or run into any problems regarding our controls, feel free to post it into our forum. We would be happy to assist you again.

Suggestion on binding WebValueList during adding a new row

sjain — Fri, 20 Nov 2015 14:49:21 GMT

Thanks Yudi ! It works perfectally ! Sorry for delay in replying.

regards
SJain

Suggestion on binding WebValueList during adding a new row

yudi — Wed, 11 Nov 2015 04:08:29 GMT

On Selection of ProductName need to autofeel 10 and some custom Text in QuantityPerUnit new row's cell.

You can try to use these approaches for such scenario.

First option: to use OnExitEditMode of WebGrid.

OnExitEditMode client-side event of WebGrid specifies the client side (JavaScript) function that will be invoked when edit mode is being ended. Add following snippet code in OnExitEditMode will auto fill string to QuantityPerUnit cell.

function WebGrid1_OnExitEditMode(controlId, tblName, editObject)
{
    var WebGrid1 = ISGetObject(controlId);
    var editObjValue = editObject.element.Value;
            
    if (editObject.element.Name == "WebComboProducts" && editObjValue == "1")
    {
        var selObj = WebGrid1.GetSelectedObject();
        var cell = selObj.ToRowObject().GetCells();
                
        cell.GetNamedItem("QuantityPerUnit").SetText("10 and some custom text", true);
        cell.GetNamedItem("QuantityPerUnit").SetValue("10 and some custom text");
    }

    return true;
}

Another option is to use OnAfterItemSelected client-side event of WebCombo, in this case is the WebComboProducts.

OnAfterItemSelected client-side event of WebCombo specifies the client side (JavaScript) function that will be invoked after an item is selected. The following is the example on how to set text and value of QuantityPerUnit cell in WebGrid after an item of ProductsCombo is selected.

function WebComboProducts_OnAfterItemSelected(controlId)
{
    var combo = ISGetObject(controlId);
    var grid = ISGetObject("WebGrid1");
    var row = grid.GetSelectedObject().GetRowObject();

    if (combo.Text == "Chai")
    {
        var cells = row.GetCells();
        var cellQuantityPerUnit = cells.GetNamedItem("QuantityPerUnit");

        cellQuantityPerUnit.SetText("10 and some custom text", true);
        cellQuantityPerUnit.SetText("10 and some custom text");
    }

    return true;
}

Hope this help.

Suggestion on binding WebValueList during adding a new row

sjain — Mon, 09 Nov 2015 08:44:15 GMT

Hi Yudi,
Sorry for delay reply. Thanks for detail explanation behind reasons of reported issues. The solution and explantions worked as expected.
There was a pending request for suggestion for using webrid event for autofill a textBox column on selection of webcombo's option during new row addition. Requested on 28th Oct's post as

On Selection of ProductName need to autofeel 10 and some custom Text in QuantityPerUnit new row's cell.

Is it possible to remove an product name from webcombo temporary once it added to new row. If row addition is cancelled then it should be put back in optionlist.

thanks and regards

Sjain

Suggestion on binding WebValueList during adding a new row

yudi — Mon, 02 Nov 2015 03:44:32 GMT

Thank you for the sent sample.

I’m currently investigating the sample and will get back to you as soon as possible.

Edited on November 2, 2015 6:35 AM
Reason: Update solution

If I try to select SupplierId first then ProductName shows empty rows.

The ProductName combo shows empty rows because it was filtered by a white space. Please allow me to show where the "white space" is.

View Webcomboexpbasic.aspx sample file in IE 11 browser.
After the page rendered, move the cursor to the textbox of WebComboSuppliers.
A white-space is appearing in the textbox of WebComboSuppliers.
Within the textbox, you should be able to move the cursor to the left/right. It indicates that there is a white-space in the textbox.
Try to delete the white-space and WebCombo should shows their items without problems.
Select "SupplierID" equals to 1.
Move the cursor to the textbox of WebComboProducts.
White-space also appear in the textbox of WebComboProducts. Try to repeat step #3 to #5.

By default, WebCombo will filter its items based on the character typed or entered in the texbox. The result will be shown in the ResultBoxWindow of WebCombo.

It shows empty rows because there is a white-space in the textbox. "Starts with" empty-space is applied to the WebCombo items. It shows empty rows because the filter results is null. No rows match after the filter applied, in this case is "Starts with" empty-space.

Please follow the steps below in order to resolve this white-space problem:

Open Webcomboexpbasic.aspx.cs in Visual Studio or text editor.
Find/go to the WebGrid1_PrepareDataBinding event declaration.
Removes the line which assigns SupplierID and ProductName column with Custom ColumnType.
Save the changes and the white-space problem should be resolves now.

After the changes, the code will look like following snippet code:

protected void WebGrid1_PrepareDataBinding(object sender, ISNet.WebUI.WebGrid.DataSourceEventArgs e)
{
    //WebGrid grid = (WebGrid)sender;
    if (!IsPostBack)
    {
        //WebGrid1.ClearCachedDataSource();
        WebGrid1.RetrieveStructure();
        if (WebGrid1.RootTable.Columns.Exists("SupplierID"))
        {
            WebGrid1.RootTable.Columns.GetNamedItem("SupplierID").EditType = EditType.WebComboNET;
            WebGrid1.RootTable.Columns.GetNamedItem("SupplierID").WebComboID = "WebComboSuppliers";
            WebGrid1.RootTable.Columns.GetNamedItem("SupplierID").FilterEditType = FilterEditType.TextBox;
            WebGrid1.RootTable.Columns.GetNamedItem("SupplierID").DefaultText = string.Empty;
            WebGrid1.RootTable.Columns.GetNamedItem("SupplierID").DefaultValue = string.Empty;
            //WebComboSuppliers.Visible = true;
        }
        if (WebGrid1.RootTable.Columns.Exists("ProductName"))
        {
            WebGrid1.RootTable.Columns.GetNamedItem("ProductName").EditType = EditType.WebComboNET;
            WebGrid1.RootTable.Columns.GetNamedItem("ProductName").WebComboID = "WebComboProducts";
            WebGrid1.RootTable.Columns.GetNamedItem("ProductName").FilterEditType = FilterEditType.TextBox;
            WebGrid1.RootTable.Columns.GetNamedItem("ProductName").DefaultText = string.Empty;
            WebGrid1.RootTable.Columns.GetNamedItem("ProductName").DefaultValue = string.Empty;
            //WebComboSuppliers.Visible = true;
        }
        WebGrid1.RootTable.Columns.GetNamedItem("ProductID").Visible = false;
    }
}

Please feel free to let me know if you have different result.

Once the selection from both combo is done then I can only change data after deleting the text inside otherwise in list only selected text is shown.

This is not bug. By default, WebCombo will show only one value after you input a text such as Maria. However, you can show all rows on dropdown by enabling AlwaysShowAllRowsOnDropdown property of WebCombo. This property Determines whether or not to display all rows when dropdown arrow is clicked.

To always show all rows on dropdown combo

Open WebCombo Designer - Advanced Settings - LayoutSettings.
Set AlwaysShowAllRowsOnDropdown to True.

Hope this helps.

Suggestion on binding WebValueList during adding a new row

sjain — Wed, 28 Oct 2015 09:27:55 GMT

Hi Yudi,
            I create a sample. Please look on it.
            I created 3 datatable to bind webgrid and 2 webcombos.
            ProductName combo is bind on basis of SupplierId combo.
            Problems in sample are

First I have to click on ProductName new row column and then select SupplieId from webcombo then onlyProductName combo shows filter data. If I try to select SupplierId first then ProductName shows empty rows.
Once the selection from both combo is done then I can only change data after deleting the text inside otherwise in list only selected text is shown.

Requests are

On Selection of ProductName need to autofeel 10 and some custom Text in QuantityPerUnit new row's cell.
On selection of SupplierId ProductName combo must be empty. Currently It is showing earlier selected value.

Please modiy the sample such a way that all data-bound features would be available. Hope the sample would be able to explain the problem we are facing.

thanks and regards

Sjain

Suggestion on binding WebValueList during adding a new row

yudi — Tue, 27 Oct 2015 09:39:45 GMT

I was using "OnInitializeDataSource" and "OnPrepareDataBinding" events for declartive columns in aspx page. Once I removed both events and bind grid on page load , it starts working. I believe that I can bind grid on "OnInitializeDataSource" event by using columns setting in event also.

Before we go further with the link WebCombo as WebGrid's editor questions, I'd like to straighten out few things first. Yes, you are correct. You can bind grid on OnInitializeDataSource event. Removing data source assignment from OnInitializeDataSource to Page_Load event similar to manually populate WebGrid row (instead of binding it to a data source) means that the Grid is operating in unbound mode. Please note that when WebGrid is operating in unbound mode, all data-bound features – such as sorting, grouping, exporting, etc – should not be enabled.

BindtoTraditionalDataSource sample of WebGrid shows the usage of OnInitializeDataSource and OnPrepareDataBinding server-side event. Hope this helps.

Suggestion on binding WebValueList during adding a new row

sjain — Mon, 26 Oct 2015 15:26:25 GMT

Hi Yudi,
I got success to bind using your given sample. (LinkWebComboIntegratedIntoWebGridSample.zip)

I was using "OnInitializeDataSource" and "OnPrepareDataBinding" events for declartive columns in aspx page. Once I removed both events and bind grid on page load , it starts working. I believe that I can bind grid on "OnInitializeDataSource" event by using columns setting in event also. Thanks for your help.

1) One thing I noticed that once I select any Product (taking example of your sample Product-supplier case) then I can not change it."

2) I also want to add some data in another textBox column on basis of selected Product for example if Product "Chai" is selected then in column of description "Chai From China" would be add. Which event is available for this purpose and how !

3) Is any way that I could clear Product TextBox when user select different Supplier so that he/she can be force to select new Product. Currently old added product is displaying in row. Also, If I change supplierId which do not have any Products then already selected Product does not remove from textBox although it shows "No records found.

4) Currently I am referring Webgrid 8 documentation available as CHM file. Is any new version available and if so then from where I can download it ?

All mentioned request are for during adding new row and before storing those data temporary in webgrid before batch update.

thanks and regards
Sjain

Suggestion on binding WebValueList during adding a new row

yudi — Mon, 26 Oct 2015 03:05:17 GMT

I modified the WebCombo part of Supplier-Product WebCombo (from my previous sample) based on the following information:

not using ISDataSource
an XML file (App_Data/Suppliers.xml) exist which have all distinct SupplierID and CompanyName (of Supplier)
SuppliersCombo is binded using Suppliers.xml file reading from code-behind by utilizing OnInitializeDataSource
On selection of particular Supplier, products information related with the Supplier are shown in ProductsCombo

Please have the modified WebCombo sample evaluated on your end and let me know whether it helps or not.

Suggestion on binding WebValueList during adding a new row

sjain — Fri, 23 Oct 2015 15:42:52 GMT

Hi Yudi,
This sample does not work in our scenario. We are not using ISDataSource .
Allow me to explain scenario.
Suppose Grid is binded by Products table .
A XML file exists which have all distinct Supplier Id and Supplier Name . Supplier Combo of grid is binded using this xml file reading from codebehind.

On selection of particular Supplier; some data will fetch from different database which have all information of Products realted with supplier.

In my case filtering is not working. It shows all the Products.

thanks and regards

Suggestion on binding WebValueList during adding a new row

sjain — Wed, 21 Oct 2015 11:05:17 GMT

Hi,

We have to bind a WebValueList (say B) from different list during adding a new row on change of another WebValueList (say A). Which clientSide event should be used for this and if possible please provide some sample .

For Example :-

WebValueList A has three values ABC, DEF and GHI

If WebValueList A's selected value is ABC then Fruit should populated , for DEF the list of Vegitables etc and for GHI the list of grain.

thanks