Intersoft Community - DataBind

Webgrid databinding causing blank screen

zeeshaamir13 — Tue, 16 Feb 2016 20:14:29 GMT

Hey,

I have a page where there is only 1 webgrid. When the page loads I get a blank white screen. This only happens sometimes, but when it happens the logs show the following exception:

DATETIME: (hidden)

USERNAME: (hidden)

CLIENTID: (hidden)

TARGETNAME: APPLICATION_ERROR: ProcessRequest

METHODNAME: Application_Error

MESSAGE: Exception of type 'System.Web.HttpUnhandledException' was thrown.Object reference not set to an instance of an object.

STACKTRACE FROM PARENT: at System.Web.UI.Page.HandleError(Exception e)

at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

at System.Web.UI.Page.ProcessRequest()

at System.Web.UI.Page.ProcessRequest(HttpContext context)

at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()

at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

at ?. ?. ?(WebGridTable ? )

at ?. ?.? (DataView , String ? , String )

at ISNet.WebUI.WebGrid.WebGrid.DataBind()

at ISNet.WebUI.WebGrid.WebGrid.OnInitializeDataSource(Object dataSource)

at ISNet.WebUI.WebGrid.WebGrid.OnLoad(EventArgs e)

at System.Web.UI.Control.LoadRecursive()

at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

STACKTRACE: at tfSW.processcontrol.LogError(String Message, String Stacktrace, String Target, String Method, String clientid)

SOURCE: tfSW

INNER STACKTRACE:

I checked the data to make sure there might be something there but that looks fine. The weird thing is I only get this error sometimes. Any help would be greatly appreciated. Thanks.

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

WebCombo ClientSide databind

sinan.biondic@gmail.com — Fri, 01 Mar 2013 04:47:44 GMT

I have following code:

function success(msg) {
    var combo = ISGetObject('cmbGodina');
    var rows = combo.GetRows();
//    if(rows.length > 0){
//        for(var i = 0; i < rows.length; ++i){
//            rows.Remove(rows[i], true);
//        }
//    }

//    combo.UpdateUI();
    var dataTable = new ISDataTable();
    var idColumn = new ISDataColumn(dataTable);
    var naziv = new ISDataColumn(dataTable);
    var datumDo = new ISDataColumn(dataTable);
    var xsltFile = new ISDataColumn(dataTable);
    var procFile = new ISDataColumn(dataTable);
    dataTable.Name = dataTable.TableName = "Root";
    idColumn.Name = idColumn.ColumnName = "IdObrasca";
    naziv.Name = naziv.ColumnName = "Naziv";
    datumDo.Name = datumDo.ColumnName = "DatumDo";
    xsltFile.Name = xsltFile.ColumnName = "XsltFile";
    procFile.Name = procFile.ColumnName = "ProcFile";
    dataTable.Columns.Add(idColumn);
    dataTable.Columns.Add(naziv);
    dataTable.Columns.Add(datumDo);
    dataTable.Columns.Add(xsltFile);
    dataTable.Columns.Add(procFile);
    $(msg).find('Table').each(function (i, row) {
        $(row).find('Field').text();
        var dataRow = dataTable.NewRow();
        dataRow.Cells.GetNamedItem("IdObrasca").Value = $(row).find('IdObrasca').text();
        dataRow.Cells.GetNamedItem("Naziv").Value = $(row).find('Naziv').text();
        dataRow.Cells.GetNamedItem("DatumDo").Value = $(row).find('DatumDo').text();
        dataRow.Cells.GetNamedItem("XsltFile").Value = $(row).find('XsltFile').text();
        dataRow.Cells.GetNamedItem("ProcFile").Value = $(row).find('ProcFile').text();
        dataTable.Rows.Add(dataRow);
    });
    combo.SetDataSource(dataTable);    
    combo.DataBind();
    combo.Render();    
}

msg is xml returned by webmethod on serverside. Everything works well, but I can't clear webcombo data before i bind it to another source. the commented lines of code, when uncommented, produce error "Unable to get value of the property 'rowIndex': object is null or undefined"

this is my combo:

<iswebcombo:WebCombo ID="cmbGodina" runat="server" AllowWildCardSearch="false" Width="200" 
                        Height="20" DataValueField="IdObrasca"
                        ViewStateStorage="None" BindingOperationMode="ClientBinding" DataTextField="Naziv">
                        <LayoutSettings ComboMode="MultipleColumns" EnableAnimation="False" AlwaysShowAllRowsOnDropdown="true" 
                            EntryMode="AutoComplete" StatusBoxPosition="Top" StatusBoxVisible="false">
                            <ClientSideEvents  OnAfterItemSelected="cmbGodina_OnAfterItemSelected" />
                        </LayoutSettings>
                        <Columns>
                            <iswebcombo:WebComboColumn Name="Naziv" HeaderText="<%$GetString:{%00_pub_Name%}%>" BaseFieldName="Naziv" Width="200" />
                            <iswebcombo:WebComboColumn Name="DatumDo" Hidden="true" RenderOnHidden="true" BaseFieldName="DatumDo" />
                            <iswebcombo:WebComboColumn Name="XsltFile" Hidden="true" RenderOnHidden="true" BaseFieldName="XsltFile" />
                            <iswebcombo:WebComboColumn Name="ProcFile" Hidden="true" RenderOnHidden="true" BaseFieldName="ProcFile" />
                        </Columns>
                        <ClientBindingSettings DataSourceType="ClientDataSource" />
                    </iswebcombo:WebCombo>

Webcombo databind to WebMethod

sinan.biondic@gmail.com — Thu, 28 Feb 2013 08:43:15 GMT

I am trying to bind webcombo dynamically. In the page_load event on server side i don't have the information needed to load webcombo data, i have it on client-side. I saw that it was possible to bind combo to webmethod in webservice, but is it possible to bind it to webmethod on .aspx page on which the combo itself is contained.

My problem is that i need to dynamically rebind webcombo on client depending on some input. So when users clicks on different menu options I have to load different data in combo. Is that even possible, and if yes, can someone please give me a working example. I am getting data from stored procedure in sql server. Is there a way, please help!

how to :binding data dynamically

qq397472251 — Thu, 26 Aug 2010 22:27:41 GMT

The page have a webgrid~~

but I have 3 Dataset,how to : bind these Dataset to webgrid dynamically (with the way "WebGrid1.DataBind()" ,not the way "e.DataSource = dataset1.DefaultView")

I bind by DataBind() cause export excel wrong and can not use VirtualLoadMode.and so many questions with the way("DataBind() " )...

but how can i bind many datasouce dynamically ????

such as:

     protected void Button9_Click(object sender, EventArgs e)
        {
            webgrid2.DataSource = myds();//second dataset
            webgrid2.DataBind();
            webgrid2.RebindDataSource();

        }
protected void Page_Load(object sender, EventArgs e)
        {
           if (!IsPostBack)
            {
                webgrid2.DataSource = mytb();//first dataset
                webgrid2.DataBind();
                webgrid2.RebindDataSource();
            }
        }

With this way cause wrong "Unable to communicate with server.",It seems that webgrid can not use

" DataBind()"