Intersoft Community - WebGrid Enterprise - How do I set multiple values for an Unbound WebCombo in a WebGrid to show up in the DropDown?

How do I set multiple values for an Unbound WebCombo in a WebGrid to show up in the DropDown?

DJBadin — Wed, 15 May 2013 12:32:02 GMT

Hi,

How do I filter the List Items in the Unbound WebCombo?

I tried to use the WebCombo Client Side Method SetAdditionalFilters in the WebGrid ClientSideEvent OnEnterEditMode based on a value in the row but on the first time a row is selected it does not filter and on subsequent rows selected nothing is in the Drop Down List.

I modified the last code you supplied.

<ClientSideEvents
	OnEnterEditMode="WebGrid1_OnEnterEditMode"
/>

<script language="javascript" type="text/javascript">

	function WebGrid1_OnEnterEditMode(controlId, TableName, editObject)
	{
		var _WebGrid = ISGetObject(controlId);
		var _WebGridCell = editObject.ToCellObject();
		if (_WebGridCell.Name == "Roles")
		{
			var _WebCombo = editObject.element;
			var FilterValue_String ;
			var EmployeeID_String = _WebGridCell.Row.GetCell("EmployeeID").Value
			if (true)
			{
				switch (EmployeeID_String)
				{
					case "1":
						FilterValue_String = "1";
						break;
					default:
						FilterValue_String = "2";
				} 
				_WebCombo.SetAdditionalFilters("[RoleId] = " + FilterValue_String);
			}
			else
			{
				switch (EmployeeID_String)
				{
					case "1":
						FilterValue_String = "Research Staff";
						break;
					default:
						FilterValue_String = "Research Manager";
				}
				_WebCombo.SetAdditionalFilters("[RoleName] = " + "'" + FilterValue_String + "'");
			}
			_WebCombo.SetText(_WebGridCell.Text, true);
		}
		return true;
	}

</script>

Please see attached screenshots and code.

Thanks,

Doug

How do I set multiple values for an Unbound WebCombo in a WebGrid to show up in the DropDown?

Hans — Mon, 01 Apr 2013 21:45:56 GMT

Hello,

Thank you for your feedback.

So do you have resolve this “Unchecked Item” issue or not? If yes, please kindly marked one of my / your post as the answer.

Please forgive me for lack of understanding about your reply.

Thank you.

Regards,
Hans.

How do I set multiple values for an Unbound WebCombo in a WebGrid to show up in the DropDown?

DJBadin — Mon, 01 Apr 2013 17:17:12 GMT

Hi,

Thanks, you anticipated my next question. When I was doing testing, the example UsingWebComboNETwithMultipleSelection you provided, worked and mine did not. I had simplified mine to mimic UsingWebComboNETwithMultipleSelection and mine still had a problem. I was beginning to think it was database related.

My actual application uses varchar and it works okay when I just put in the BoundMode="ForceUnbound". My sample was just simplified and modified to use the Northwind.mdf so you could reproduce the problem. As chance would have it I picked a column of datatype nchar which ends up padding the Text with spaces as you explained.

Thanks,

Doug

How do I set multiple values for an Unbound WebCombo in a WebGrid to show up in the DropDown?

Hans — Mon, 01 Apr 2013 07:24:43 GMT

Hello,

Related to the “Unchecked Item” issue, after I investigate furthermore, it seems the issue occurs due to database value and data type itself.

I have tried to bind the unbound column to another table (Categories table). I set the DataValue to “CategoryID” and DataText to “CategoryName”.
The result is the “Unchecked Item” issue doesn’t occur, even without validation code that I wrote in my prior post.

It happens due to the differences between data type in RegionDescription and data type in CategoryName.
The data type of RegionDescription is “nchar” and data type of CategoryName is “nvarchar”.

As we know, ‘char’ data type is used for storing fix length character strings. ‘Char’ will add the spacebar to the blank space. Unlike the ‘varchar’ data type, it will not add the spacebar to the blank space (Char_VarChar.jpg)
However, in WebGrid’s InitializeRow server side event, we add the value text without blank space.
It will cause the “Unchecked Item” issue occur, due to the value in database and the value in WebCombo doesn’t match.

In my humble opinion, I suggest you to modify your database that using ‘char’ data type to use ‘varchar’ data type.
Because as far I know the ‘char’ data type will also cause an issue / problem, when you want to do some databases query.

I attached the modified sample that using Categories table as well.

Thank you.

Regards,
Hans.

How do I set multiple values for an Unbound WebCombo in a WebGrid to show up in the DropDown?

Hans — Mon, 01 Apr 2013 05:06:01 GMT

Hello,

Thank you for reply.

Perhaps you could you use this work around to fix this issue. I add some validation code in OnItemChecked client side event. Here’s how I implement the validation code:

function Regions_WebCombo_OnItemChecked(){
    var Regions_WebCombo = ISGetObject("Regions_WebCombo");
    var Values = Regions_WebCombo.GetMultipleValues();
    var Rows = Regions_WebCombo.GetRows();
    var rowsLenght = Rows.length;
    var selectedRow = Regions_WebCombo.GetSelectedRow();
    var selectedRowValue = selectedRow.dataValue;
    var selectedRowChecked = selectedRow.childNodes[0].childNodes[0].checked;
    if (Values)
    {
        var valuesLength = Values.length;
        for (var i = 0; i < valuesLength; i++)
        {
            var valueItem = Values[i];
            if (valueItem)
            {
                if (valueItem.Value == selectedRowValue && selectedRowChecked == true)
                {
                    Values.splice(i, 1);
                }
            }
        }
    }
    Regions_WebCombo.UpdateUI();
}
function Regions_WebCombo_OnShowDropDown(controlId)
{
    var Regions_WebCombo = ISGetObject("Regions_WebCombo");
    Regions_WebCombo.LayoutSettings.ClientSideEvents.OnItemChecked = "Regions_WebCombo_OnItemChecked";
}

I have modified your sample as well. Please kindly have review on the sample to see the result.

Thank you very much.

Regards,
Hans.

How do I set multiple values for an Unbound WebCombo in a WebGrid to show up in the DropDown?

DJBadin — Thu, 28 Mar 2013 18:14:03 GMT

Hi,

Per your instructions I got it to check intialized values by adding BoundMode="ForceUnbound" to WebCombo.LayoutSettings but that revealed a new problem.

<LayoutSettings
	ComboMode="SingleColumn"
	TextBoxMode="ReadOnly"
	BoundMode="ForceUnbound"
>

For the initialized values, when they are unchecked in the DropDown they are not removed from the TextBox. See attached screen shots.

For new checked items, they are added and removed as unchecked.

What else do I need to do?

Thanks,

Doug

How do I set multiple values for an Unbound WebCombo in a WebGrid to show up in the DropDown?

Hans — Thu, 28 Mar 2013 05:33:55 GMT

Hello,

Related with my prior post about WebGrid sample, UsingWebComboNETwithMultipleSelection.aspx, I have tried to modify this sample, so this sample more similar with your current scenario.

In this sample, I set the “Bound” property in last (4th) column (Roles column) to “false”.
Then I add a couple line of code in WebGrid’s InitializeRow server side, to add/set value in Roles column.

protected void WebGrid1_InitializeRow(object sender, ISNet.WebUI.WebGrid.RowEventArgs e){
    e.Row.Cells.GetNamedItem("Roles").Value = 1;
    e.Row.Cells.GetNamedItem("Roles").Text = "Research Staff";
}

And the result is the sample work fine on my end. Please kindly have a review on this modified sample as well.

To run the sample you just simple add/attach the page/file to WebGrid sample project.

Thank you very much.

Regards,

Hans.

How do I set multiple values for an Unbound WebCombo in a WebGrid to show up in the DropDown?

Hans — Thu, 28 Mar 2013 03:09:44 GMT

Hello,

Thank you very much for helping me by providing me detail information to run the sample.
Now I can run your sample on my local end.

I have a work around to achieve your scenario. I set BoundMode property in WebCombo to "ForceUnbound".
And I add this line of code in Page_Load server side event:

protected void Page_Load(object sender, EventArgs e){
    DataView view = Region_ISDataSource.Select() as DataView;
    Regions_WebCombo.PopulateUnboundData(view, true);
}

Please have kindly have review on the modified sample to see the result.

You also can see on WebGrid sample, UsingWebComboNETwithMultipleSelection.aspx. This sample have similar scenario with your current scenario.

Thank you.

Regards,

Hans.

How do I set multiple values for an Unbound WebCombo in a WebGrid to show up in the DropDown?

DJBadin — Wed, 27 Mar 2013 11:35:25 GMT

Hi,

I did not include my DataSets for the App_Code directory because I did not know the Web.config connectionString you would be using to connect to the Northwind Database.

I did not realize when I said in my first posting "A DataSet for the Tables Shippers and Region would need to be created." that you would not know how to create one or that your colleagues did not know how to either or would not help you. You should have let me know in your first reply.

I assumed someone at Intersoft would know how to create a DataSet because they are used in the Intersoft ASP.NET Samples Projects.

Since the Regions table is in the SQL Northwind.mdf and not in Northwind.mdb you will need to use the SQL Database. This can be identified by it's file extension of .mdf, not .mdb.

For instance, the Web.config in the WebGrid "C# Samples (Visual Studio 2010 Solution)" has the following SqlNorthwindConnectionString connectionString.

<add name="SqlNorthwindConnectionString" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Northwind.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True" providerName="System.Data.SqlClient"/>

Like the WebGrid "C# Samples (Visual Studio 2010 Solution)" you will have to have your Northwind.mdf and Northwind_log.ldf files in the App_Data Directory.

Next you need to create the DataSets in the App_Code directory.

Inspecting each ISDataSource.SchemaName you will find the names of the DataSet to use.

<ISDataSource:ISDataSource
	ID="Shippers_ISDataSource"
	runat="server"
	SchemaName="dsNorthwindShippers"

<ISDataSource:ISDataSource
	ID="Region_ISDataSource"
	runat="server"
	SchemaName="dsNorthwindRegion"

For my sample you need to create the following DataSets:

- dsNorthwindShippers
- dsNorthwindRegion

If you have problems following my instructions on how to create a DataSet there are many resources typing “visual studio create dataset” into Google which returns links to MSDN How Tos, YouTube Videos and other content.

- http://msdn.microsoft.com/en-us/library/04y282hb.aspx
- http://www.youtube.com/watch?v=3Pbj7pRcu4I

To create DataSet using Visual Studio 2010: (It is slightly different for Visual Studio 2012)

For dsNorthwindShippers:

- Select the App_Code directory in the Solution Explorer
- Right Click App_Code
- Select Add New Item
- Select DataSet
- Enter dsNorthwindShippers for the Name
- Click Add Button
- Go to Server Explorer
- Expand Data Connections
- Expand you Northwind Connection
- Expand Tables
- Drag Shippers onto the Dataset Designer
- Save

For dsNorthwindRegion:

- Select the App_Code directory in the Solution Explorer
- Right Click App_Code
- Select Add New Item
- Select DataSet
- Enter dsNorthwindRegion for the Name
- Click Add Button
- Go to Server Explorer
- Expand Data Connections
- Expand you Northwind Connection
- Expand Tables
- Drag Region onto the Dataset Designer
- Save

If you have problems implementing my instructions, you are really going to have to ask your boss for help and direction.

Doug

How do I set multiple values for an Unbound WebCombo in a WebGrid to show up in the DropDown?

Hans — Wed, 27 Mar 2013 06:28:48 GMT

Hello,

Thank you for your reply.

I am really sorry, but I can’t run sample on my end, due to I don’t have your app_code file.

Would you mind to provide the sample that I can run the sample properly?
So I can help you to investigate this issue further more.

Thank you very much.

Regards,
Hans.

How do I set multiple values for an Unbound WebCombo in a WebGrid to show up in the DropDown?

DJBadin — Mon, 25 Mar 2013 21:01:16 GMT

I have a WebGrid with a WebGridColumn of EditType="WebComboNET". It's WebCombo is unbound and has MultipleSelectionSettings is Enabled.

How do I set multiple values or even single values to show up in the DropDown?

I tried using the Server Side Webgrid IntializeRow Event to set the WebGridCell Text and Value, however when the DropDown is displayed, nothing is checked. With MultipleSelectionSettings not Enabled, the DropDown selects the value.

I have attached a sample using the Northwind Database. A DataSet for the Tables Shippers and Region would need to be created.

I have the latest versions of the Intersoft Controls.

I am using Visual Studio 2012

Thanks,

Doug