Services
Support
Store
©2015 Intersoft Solutions. All rights reserved.

User Profile & Activity

Attila Tello Member
Page
of 2
BatchUpdate (Deleting / Updating) and Review Problems
Posted: January 8, 2010 7:17 AM

Thank you. I'll wait for the solution...

BatchUpdate (Deleting / Updating) and Review Problems
Posted: January 7, 2010 6:14 AM

Table1
* Cod (int)
* Dhe (smalldatetime)
* Cz (int)
(other columns)

Table2
* Cod (int)
* Dhe (smalldatetime)
* Cz (int)
* Cd (int)
(other columns)


My WebGrid (modified example):

    <ISWebGrid:WebGrid ID="WebGrid1" runat="server" Height="393px" UseDefaultStyle="True" Width="100%" DefaultStyleMode="Elegant" ViewStateStorage="None" StateRestorationLevel="Low" onbatchupdate="WebGrid1_BatchUpdate" DataSourceID="ISDataSource1" DataMember="Table1" >
        <LayoutSettings Hierarchical="True" AllowAddNew="Yes" AllowColumnMove="Yes" AllowDelete="Yes"
            AllowEdit="Yes" AllowExport="Yes" AllowFilter="Yes" AllowGrouping="Yes" AllowSelectColumns="Yes"
            AllowSorting="Yes" AutoFilterSuggestion="True" GridLines="Vertical" GroupByBoxVisible="True"
            HeaderClickAction="SortMulti" HideColumnsWhenGrouped="Yes" NewRowLostFocusAction="AlwaysUpdate"
            PromptBeforeDelete="True" RowLostFocusAction="AlwaysUpdate" ShowFilterStatus="True"
            ResetNewRowValuesOnError="False" VerboseEditingInformation="True" PagingMode="ClassicPaging"
            PagingStyleUI="Slider" PagingSize="10" AllowBatchUpdate="True" SelectFirstCellOnAdd="true" AllowMultipleSelection="Yes"
            ColumnFooters="Yes" MarkDefaultValuesAsDirty="false">
            <BatchUpdateSettings AllowReviewChanges="True" NotifyOnLostFocus="True" />
        </LayoutSettings>
        <FlyPostBackSettings PostHiddenFields="false" PostInputControls="false" PostViewState="false" />
        <RootTable Caption="Table1" DataMember="Table1">
            <ChildTables>
                <ISWebGrid:WebGridTable Caption="Table2" DataMember="Table2">
                    <Columns>
                        <ISWebGrid:WebGridColumn Caption="Cod" DataMember="Cod" DataType="System.Int32" Name="Cod" />
                        <ISWebGrid:WebGridColumn Caption="Dhe" DataMember="Dhe" DataType="System.DateTime" Name="Dhe" />
                        <ISWebGrid:WebGridColumn Caption="Cz" DataMember="Cz" DataType="System.Int32" Name="Cz" />
                        <ISWebGrid:WebGridColumn Caption="Cd" DataMember="Cd" DataType="System.Int32" Name="Cd" />
                        <ISWebGrid:WebGridColumn Caption="Field1" DataMember="Field1" Name="Field1" />
                    </Columns>
                </ISWebGrid:WebGridTable>
            </ChildTables>
            <Columns>
                <ISWebGrid:WebGridColumn Caption="Cod" DataMember="Cod" DataType="System.Int32" Name="Cod" Width="100px" />
                <ISWebGrid:WebGridColumn Caption="Dhe" DataMember="Dhe" DataType="System.DateTime" Name="Dhe" Width="100px" />
                <ISWebGrid:WebGridColumn Caption="Cz" DataMember="Cz" DataType="System.Int32" Name="Cz" Width="100px" />
                <ISWebGrid:WebGridColumn Caption="Field1" DataMember="Field1" DataType="System.Boolean" Name="Field1" Width="100px" />
                <ISWebGrid:WebGridColumn Caption="Field2" DataMember="Field2" DataType="System.Boolean" Name="Field2" Width="100px" />
            </Columns>
        </RootTable>
    </ISWebGrid:WebGrid>


I have a dataset configured to work with stored procedures, but I had to change the "Dhe" in the TableAdapters from DateTime to String, because otherwise the relationship was not working right in webgrid (couldn't add child rows). I can't touch db structure. An example of a row from Table1 can be seen on previous screenshot...

Im downloading 2009/R2 now... My webgrid version is 7.0.7200.306, WebUI v3.0.5000.705 and ISDataSource v1.0.1500.210.

TIA

Edit: All components updated. Its odd, but I just change AllowBatchUpdate from "true" to "false" and webgrid works... but no batch updated support, of coure.

BatchUpdate (Deleting / Updating) and Review Problems
Posted: January 7, 2010 5:19 AM

Well... after hours trying to find a solution, no success achieved:

When I set BatchUpdate to false, it works as a charm. But when I set it to true, it cant Update / Delete. I can only Select and Insert with BatchUpdate.

I've checked my stored procedures manually and they're working fine (as confirmed when setting BatchUpdate to false). Please see attached image.


Haven't tried to solve 'Review' on WebDesktopWindow yet.

BatchUpdate (Deleting / Updating) and Review Problems
Posted: January 6, 2010 5:28 AM
I just found the problem might be on datetime format... Where '09-01-2010 10:00:00' should be '01-09-2010 10:00:00'... You are right, I had some problems with primary keys. Im trying to solve it now. The other problem (the 'review'), I haven't solved yet, but I verified that it works when outside the WebDesktopWindow (that's how I found the previous problem: It displayed the primary keys and what column was going to be updated). Any solutions for the Review inside WebDesktopWindow? Thank you!
JavaScript ColumnName WebGrid
Posted: October 29, 2009 5:45 AM

Thank you

 

Here is what I did:

function WebGrid1_OnEnterEditMode(controlId, tblName, editObject) {
            var WebGrid1 = ISGetObject(controlId);
            alert(wgGetColNameByCell(editObject.cellElement));
            return true;
}

More Info

 

BTW... I guess I've marked the wrong post as answer. Is it possible to unmark it? Ty

JavaScript ColumnName WebGrid
Posted: October 28, 2009 8:19 AM

Hello Handy,

Thank you for your reply, but unfortunally this code isn't working...

Im having trouble at cellIndex parameter, wich is getting undefined. By the way... i need to use the code as "OnEnterEditMode" (I suppose it would work just as same).


I've tried with "OnCellSelect" too, but it didn't even fired...

<ClientSideEvents OnCellSelect="WebGrid1_OnCellSelect" />
WebGrid and Internet Explorer 8 Javascript Error
Posted: October 2, 2009 4:11 AM

I didn't say "the same"; I said "could be related".

Yes, I think it could be related (or else I wouldn't reference it). Simply because it happens with IE8 (as far as I've tested) and before updating to SP1 the error was just the same as his.. now it is just the next sentence at the same function after his error; I did not analyze what code it has before the 'else'.

WebGrid and Internet Explorer 8 Javascript Error
Posted: October 1, 2009 4:24 AM

Yes, I understand it'll be difficult to see what exactly caused the error only based on the screenshot, but right now I dont have the time to make an working example of my non-working webgrid (well.. it works, but gives me this annoying js error)   based on Northwind database... Anyway, I thought it could be related to the problem posted here.

WebGrid fails with javascript error
Posted: October 1, 2009 4:07 AM

Hello... I must say there's something confusing some people: There is no add-on or hotfix. The SP1 comes integrated in the full installer, so you must download it all again. The problem is that when you go to "My Components" the title doesnt says "Intersoft WebUI Studio 2009 R1 SP1", so in my case I could only find it out trying to download the pack again. Just my 2 cents..

Webgrid and Top-Left corner textbox floating.
Posted: October 1, 2009 4:03 AM

Hello Gordon

errr... by "TIA" I meant "Thanks In Advance", but its ok; maybe your "automatic answer template" did it before you know it   - Just kidding.

Anyways... is it possible to keep track of development team work on this issue status? I mean, I have an second option that isn't as good as using my webgrid with popup extender, but I'll use it while hotfix doesn't come out (or until I find another way of avoid it...).

TIA,

Attila

All times are GMT -5. The time now is 12:04 AM.
Previous Next