Bind WebCombo with a DataTable as the DataSource

siemiatkowski@softwarestudio.com.pl — Wed, 11 Sep 2013 01:09:59 GMT

I found this site with example:

http://www.intersoftpt.com/Support/WebCombo/KB/Various-WebCombo-Samples/

WebCombo is bounded programmatically during runtime with a DataTable as the DataSource. The ComboMode configuration, DataTextField and DataValueField are all configured in InitializeLayout event.
Download Sample

but link download sample on this site not running correctly.

Opps...

We are sorry, but the page you are looking for cannot be found or has been removed from Intersoft Solutions web site.

Does anyone have an example program to connect a DataTable to WebCombo ?

I wrote a code that gives me control to the form, but when you try to display a list of records from a DataTable I get an error - the list of folders and files an application.

ISNet.WebUI.WebCombo.WebCombo wc = new ISNet.WebUI.WebCombo.WebCombo();
wc.ID = "1";
wc.DataTextField = "tekst";
wc.DataValueField = "wartosc";
wc.DataSource = datatable;
wc.DataBind();
wc.LayoutSettings.AlwaysShowAllRowsOnDropdown = true;
            wc.LayoutSettings.StatusBoxVisible = false;

In attach files screens,

error occurs when you want to display a list of records

Remove column defined in aspx markup, from server-side

sinan.biondic@gmail.com — Tue, 16 Apr 2013 16:03:03 GMT

Hi,

I am trying to implement webgrid but the problem exists when I'm binding it to datasource. I have a stored procedure that returns some data.However, I don't know how many columns will be returned in that procedure, but I know the names of all columns that can be returned. So what I wanted to do, is to define all possible columns in aspx page, and in server-side PrepareDataBinding method remove columns from webgrid's column collection that don't have their match in datasource datatable that I'm binding it to.

This doesn't really work as I get an error stating that columne "XYZ" which is defined in aspx can't be found in datasource, although it was removed (I checked with debugger) in PrepareDataBinding event handler.

I presume this then is not possible, or am I wrong? The reason I am not creating columns from codebehind is simply that I would have to check datasource for every column to see if it exists and then create that column dynamically and add it to the column collection of webgrid. We did that in old version of our application and that PrepareDataBinding method has over 1600 lines of code, so I am looking for a better way of doing this. Please help me for the love of god!

This is my PrepareDataBinding method (column named "Check" is rowchecker column so i don't want it removed):

Dim dt As DataTable = CType(e.DataSource, DataTable)
 Dim grid As WebGrid = CType(sender, WebGrid)
 Dim colName As String
 For Each col As WebGridColumn In grid.RootTable.Columns
 colName = col.DataMember
 If Not colName = "Check" AndAlso Not dt.Columns.Contains(colName) Then
 grid.RootTable.Columns.Remove(col)
 End If
 Next

Intersoft Community - datatable

Bind WebCombo with a DataTable as the DataSource

Opps...

Remove column defined in aspx markup, from server-side