Hi,

--------------------------------------------------

  This is the select function:

--------------------------------------------------

[WebMethod]
    public object GetMembershipTransactions(DataSourceSelectArguments selectArguments)
    {
        MembershipDataContext context = new MembershipDataContext();
        context.DeferredLoadingEnabled = false;
        context.ObjectTrackingEnabled = false;

        int nMembershipID = 0;
        Int32.TryParse(selectArguments.FilterExpression, out nMembershipID);

        var MembershipTransactions = from membershipTransaction in context.MembershipTransactions
                                     where membershipTransaction.MembershipID == nMembershipID
                                       select new
                                       {
                                           MembershipTransactionID  = membershipTransaction.MembershipTransactionID,
                                           Amount                   = membershipTransaction.Amount,
                                           MembershipID             = membershipTransaction.MembershipID,
                                           Note                     = membershipTransaction.Note,
                                           ProcessDate              = membershipTransaction.ProcessDate,
                                           Processed                = membershipTransaction.Processed,
                                           ReferenceNo              = membershipTransaction.ReferenceNo,
                                           TransactionDate          = membershipTransaction.TransactionDate,
                                           ChequeNo                 = GetChequeNo(membershipTransaction.MembershipChequeID),
                                           CreditCardNo             = GetCreditCardInfo(membershipTransaction.CreditCardID)
                                       };

        return MembershipTransactions.ToList();

        throw new InvalidOperationException("Unsupported operation type!");
    }

-----------------------------------------------------

And this is the grid configuration:

-----------------------------------------------------

<ISWebGrid:WebGrid ID="TransactionsWebGrid" runat="server"
                                                        DefaultStyleMode="Win7" Height="322px" UseDefaultStyle="True" Width="99%" BindingOperationMode="ClientBinding">
                                                        <LayoutSettings AllowColumnSizing="No" AllowContextMenu="False" AllowEdit="Yes" AllowSorting="Yes" AlwaysShowHelpButton="True"
                                                            ColumnSetHeaders="Default" EditOnClick="True" FilterBarVisible="False" InProgressUIBehavior="ChangeCursorToHourGlass"
                                                            RowHeaders="Default" ShowRefreshButton="False" AllowBatchUpdate="True" NewRowLostFocusAction="AlwaysUpdate" >
                                                            <BatchUpdateSettings AllowReviewChanges="True" />
                                                            <ClientSideEvents OnBatchUpdateSuccess="TransactionsWebGrid_OnBatchUpdateSuccess" />
                                                        </LayoutSettings>
                                                        <RootTable Caption="MembershipTransactions" DataKeyField="MembershipTransactionID" >
                                                            <Columns>
                                                                <ISWebGrid:WebGridColumn Caption="Date" DataMember="TransactionDate"
                                                                    EditType="NoEdit" Name="TransactionDate" Width="70px"
                                                                    DataFormatString="d" DataType="System.DateTime">
                                                                    <HeaderStyle Cursor="Hand" Font-Italic="True" Font-Underline="True" HorizontalAlign="Center" />
                                                                </ISWebGrid:WebGridColumn>
                                                               
                                                                <ISWebGrid:WebGridColumn Caption="Amount" DataMember="Amount" Name="Amount"
                                                                    EditType="NoEdit" Width="55px" DataType="System.Decimal">
                                                                    <HeaderStyle Cursor="Hand" Font-Italic="True" Font-Underline="True" HorizontalAlign="Center" />
                                                                </ISWebGrid:WebGridColumn>
                                                               
                                                                <ISWebGrid:WebGridColumn Caption="Cheque No" DataMember="ChequeNo" Name="ChequeNo"
                                                                    EditType="NoEdit" Width="125px" DataType="System.Decimal">
                                                                    <HeaderStyle Cursor="Hand" Font-Italic="True" Font-Underline="True" HorizontalAlign="Center" />
                                                                </ISWebGrid:WebGridColumn>
                                                               
                                                                <ISWebGrid:WebGridColumn Caption="Credit-Card No" DataMember="CreditCardNo" Name="CreditCardNo"
                                                                    EditType="NoEdit" Width="125px" DataType="System.Decimal">
                                                                    <HeaderStyle Cursor="Hand" Font-Italic="True" Font-Underline="True" HorizontalAlign="Center" />
                                                                </ISWebGrid:WebGridColumn>
                                                               
                                                                <ISWebGrid:WebGridColumn Caption="Processed" ColumnType="CheckBox"
                                                                    DataMember="Processed" DataType="System.Boolean" EditType="Checkbox"
                                                                    Name="Processed" Width="60px">
                                                                    <HeaderStyle Cursor="Hand" Font-Italic="True" Font-Underline="True" HorizontalAlign="Center" />
                                                                </ISWebGrid:WebGridColumn>
                                                               
                                                                <ISWebGrid:WebGridColumn Caption="Process Date" CustomEditorName="VistaCalendar"
                                                                    DataFormatString="d" DataMember="ProcessDate" DataType="System.DateTime"
                                                                    EditType="Custom" Name="ProcessDate" Width="70px">
                                                                    <HeaderStyle Cursor="Hand" Font-Italic="True" Font-Underline="True" HorizontalAlign="Center" />
                                                                </ISWebGrid:WebGridColumn>
                                                               
                                                                <ISWebGrid:WebGridColumn Caption="Reference" Name="ReferenceNo" Width="80px" DataMember="ReferenceNo">
                                                                    <HeaderStyle Cursor="Hand" Font-Italic="True" Font-Underline="True" HorizontalAlign="Center" />
                                                                </ISWebGrid:WebGridColumn>
                                                               
                                                                <ISWebGrid:WebGridColumn Caption="Note" DataMember="Note" Name="Note" Width="95px">
                                                                    <HeaderStyle Cursor="Hand" Font-Italic="True" Font-Underline="True" HorizontalAlign="Center" />
                                                                </ISWebGrid:WebGridColumn>
                                                            </Columns>
                                                        </RootTable>
                                                       
                                                        <ClientBindingSettings DataSourceType="WebService" ServiceUrl="../MembershipDataService.asmx"
                                                                               ItemTypeName="MembershipTransaction" DataLoadMode="AllData">
                                                            <ServiceMethods SelectMethod="GetMembershipTransactions" BatchUpdateMethod="BatchUpdateMembershipTransactions" />
                                                            <ServiceEvents Selecting="Selecting_MembershipTransactions"/>
                                                        </ClientBindingSettings>
                                                       
                                                    </ISWebGrid:WebGrid>

--------------------------------------------------

And this is the table code:

---------------------------------------------------

[Table(Name="dbo.MembershipTransaction")]
    public partial class MembershipTransaction : INotifyPropertyChanging, INotifyPropertyChanged
    {
       
        private static PropertyChangingEventArgs emptyChangingEventArgs = new PropertyChangingEventArgs(String.Empty);
       
        private int _MembershipTransactionID;
       
        private System.Nullable<int> _MembershipID;
       
        private System.Nullable<int> _TransactionTypeID;
       
        private System.Nullable<int> _CreditCardID;
       
        private System.Nullable<int> _MembershipChequeID;
       
        private System.Nullable<bool> _Processed;
       
        private System.Nullable<System.DateTime> _ProcessDate;
       
        private System.DateTime _TransactionDate;
       
        private System.Nullable<decimal> _Amount;
       
        private string _ReferenceNo;
       
        private string _Note;
       
    #region Extensibility Method Definitions
    partial void OnLoaded();
    partial void OnValidate(System.Data.Linq.ChangeAction action);
    partial void OnCreated();
    partial void OnMembershipTransactionIDChanging(int value);
    partial void OnMembershipTransactionIDChanged();
    partial void OnMembershipIDChanging(System.Nullable<int> value);
    partial void OnMembershipIDChanged();
    partial void OnTransactionTypeIDChanging(System.Nullable<int> value);
    partial void OnTransactionTypeIDChanged();
    partial void OnCreditCardIDChanging(System.Nullable<int> value);
    partial void OnCreditCardIDChanged();
    partial void OnMembershipChequeIDChanging(System.Nullable<int> value);
    partial void OnMembershipChequeIDChanged();
    partial void OnProcessedChanging(System.Nullable<bool> value);
    partial void OnProcessedChanged();
    partial void OnProcessDateChanging(System.Nullable<System.DateTime> value);
    partial void OnProcessDateChanged();
    partial void OnTransactionDateChanging(System.DateTime value);
    partial void OnTransactionDateChanged();
    partial void OnAmountChanging(System.Nullable<decimal> value);
    partial void OnAmountChanged();
    partial void OnReferenceNoChanging(string value);
    partial void OnReferenceNoChanged();
    partial void OnNoteChanging(string value);
    partial void OnNoteChanged();
    #endregion
       
        public MembershipTransaction()
        {
            OnCreated();
        }
       
        [Column(Storage="_MembershipTransactionID", DbType="Int NOT NULL IDENTITY", IsPrimaryKey=true, IsDbGenerated=true)]
        public int MembershipTransactionID
        {
            get
            {
                return this._MembershipTransactionID;
            }
            set
            {
                if ((this._MembershipTransactionID != value))
                {
                    this.OnMembershipTransactionIDChanging(value);
                    this.SendPropertyChanging();
                    this._MembershipTransactionID = value;
                    this.SendPropertyChanged("MembershipTransactionID");
                    this.OnMembershipTransactionIDChanged();
                }
            }
        }
       
        [Column(Storage="_MembershipID", DbType="Int")]
        public System.Nullable<int> MembershipID
        {
            get
            {
                return this._MembershipID;
            }
            set
            {
                if ((this._MembershipID != value))
                {
                    this.OnMembershipIDChanging(value);
                    this.SendPropertyChanging();
                    this._MembershipID = value;
                    this.SendPropertyChanged("MembershipID");
                    this.OnMembershipIDChanged();
                }
            }
        }
       
        [Column(Storage="_TransactionTypeID", DbType="Int")]
        public System.Nullable<int> TransactionTypeID
        {
            get
            {
                return this._TransactionTypeID;
            }
            set
            {
                if ((this._TransactionTypeID != value))
                {
                    this.OnTransactionTypeIDChanging(value);
                    this.SendPropertyChanging();
                    this._TransactionTypeID = value;
                    this.SendPropertyChanged("TransactionTypeID");
                    this.OnTransactionTypeIDChanged();
                }
            }
        }
       
        [Column(Storage="_CreditCardID", DbType="Int")]
        public System.Nullable<int> CreditCardID
        {
            get
            {
                return this._CreditCardID;
            }
            set
            {
                if ((this._CreditCardID != value))
                {
                    this.OnCreditCardIDChanging(value);
                    this.SendPropertyChanging();
                    this._CreditCardID = value;
                    this.SendPropertyChanged("CreditCardID");
                    this.OnCreditCardIDChanged();
                }
            }
        }
       
        [Column(Storage="_MembershipChequeID", DbType="Int")]
        public System.Nullable<int> MembershipChequeID
        {
            get
            {
                return this._MembershipChequeID;
            }
            set
            {
                if ((this._MembershipChequeID != value))
                {
                    this.OnMembershipChequeIDChanging(value);
                    this.SendPropertyChanging();
                    this._MembershipChequeID = value;
                    this.SendPropertyChanged("MembershipChequeID");
                    this.OnMembershipChequeIDChanged();
                }
            }
        }
       
        [Column(Storage="_Processed", DbType="Bit")]
        public System.Nullable<bool> Processed
        {
            get
            {
                return this._Processed;
            }
            set
            {
                if ((this._Processed != value))
                {
                    this.OnProcessedChanging(value);
                    this.SendPropertyChanging();
                    this._Processed = value;
                    this.SendPropertyChanged("Processed");
                    this.OnProcessedChanged();
                }
            }
        }
       
        [Column(Storage="_ProcessDate", DbType="DateTime")]
        public System.Nullable<System.DateTime> ProcessDate
        {
            get
            {
                return this._ProcessDate;
            }
            set
            {
                if ((this._ProcessDate != value))
                {
                    this.OnProcessDateChanging(value);
                    this.SendPropertyChanging();
                    this._ProcessDate = value;
                    this.SendPropertyChanged("ProcessDate");
                    this.OnProcessDateChanged();
                }
            }
        }
       
        [Column(Storage="_TransactionDate", DbType="DateTime NOT NULL")]
        public System.DateTime TransactionDate
        {
            get
            {
                return this._TransactionDate;
            }
            set
            {
                if ((this._TransactionDate != value))
                {
                    this.OnTransactionDateChanging(value);
                    this.SendPropertyChanging();
                    this._TransactionDate = value;
                    this.SendPropertyChanged("TransactionDate");
                    this.OnTransactionDateChanged();
                }
            }
        }
       
        [Column(Storage="_Amount", DbType="Decimal(18,2)")]
        public System.Nullable<decimal> Amount
        {
            get
            {
                return this._Amount;
            }
            set
            {
                if ((this._Amount != value))
                {
                    this.OnAmountChanging(value);
                    this.SendPropertyChanging();
                    this._Amount = value;
                    this.SendPropertyChanged("Amount");
                    this.OnAmountChanged();
                }
            }
        }
       
        [Column(Storage="_ReferenceNo", DbType="VarChar(50)")]
        public string ReferenceNo
        {
            get
            {
                return this._ReferenceNo;
            }
            set
            {
                if ((this._ReferenceNo != value))
                {
                    this.OnReferenceNoChanging(value);
                    this.SendPropertyChanging();
                    this._ReferenceNo = value;
                    this.SendPropertyChanged("ReferenceNo");
                    this.OnReferenceNoChanged();
                }
            }
        }
       
        [Column(Storage="_Note", DbType="VarChar(250)")]
        public string Note
        {
            get
            {
                return this._Note;
            }
            set
            {
                if ((this._Note != value))
                {
                    this.OnNoteChanging(value);
                    this.SendPropertyChanging();
                    this._Note = value;
                    this.SendPropertyChanged("Note");
                    this.OnNoteChanged();
                }
            }
        }
       
        public event PropertyChangingEventHandler PropertyChanging;
       
        public event PropertyChangedEventHandler PropertyChanged;
       
        protected virtual void SendPropertyChanging()
        {
            if ((this.PropertyChanging != null))
            {
                this.PropertyChanging(this, emptyChangingEventArgs);
            }
        }
       
        protected virtual void SendPropertyChanged(String propertyName)
        {
            if ((this.PropertyChanged != null))
            {
                this.PropertyChanged(this, new PropertyChangedEventArgs(propertyName));
            }
        }
    }

--------------------------------------------------------

Thanks,

Maged

Well, simplest fix is to set the grid to BindingOperationMode="ClientBinding"

That also will make everything work more smooth and fast.

I used OnBatchUpdateSuccess and that is enough… Sorry for the misreporting.

Ok, so you mean its a vs 2008 issue, okay I believe you!

Please let me know when there is a fix!