ASP.NET

Unable To Create Excel Sheet At Runtime In my Application.

28-Apr-11 8:34

I did find on their site that the only way to rip a pdf into a string was low level. The had no high level functions to do so. Thats not to say that it still wouldn't be a little easier with pdfsharp instead of ITextSharp, since that one does not have a high level way to do it either from what I can find.

I do appreciate the info and will continue to look into it.

Programming is a race between programmers trying to build bigger and better idiot proof programs, and the universe trying to build bigger and better idiots, so far... the universe is winning.

Re: iTextsharp vs pdfbox

Pete O'Hanlon28-Apr-11 8:36

Pete O'Hanlon

28-Apr-11 8:36

It doesn't look too bad. Basically, you'll read the document in and then use the ReadDocument method to return a Document object. This Document contains all of the information about the PDF. Then, you iterate over the Sections in the Document and you can extract the Text object from each Section. That's it basically.

Forgive your enemies - it messes with their heads

My blog | My articles | MoXAML PowerToys | Mole 2010 - debugging made easier - my favourite utility

Sanket.Patil28-Apr-11 2:37

Sanket.Patil

28-Apr-11 2:37

Hi All,

I am developing a web application. In that I have a web page that imports the data from EXCEL SHEET To Database. While doing this I have set some validation over the EXCEL Data. If the data is incorrect i need to write it in a new excel file which is created at run time. I have written the code to create new excel file with some data. But While Creating The Excel File I am Getting an error which i am unable to solve.

So, Please Help me to solve my problem.
I am using VS 2008 with c#.
The Error is :
Microsoft Office Excel cannot open or save any more documents because there is not enough available memory or disk space.

• To make more memory available, close workbooks or programs you no longer need.

• To free disk space, delete files you no longer need from the disk you are saving to.

The Code I have Written is :

Excel.Application WRExcel = null;
            Excel.Workbooks WRwbs = null;


            Excel._Workbook WRwb = null;
            Excel.Sheets WRss = null;

            Excel._Worksheet WRws = null;
            object objOpt = System.Reflection.Missing.Value;

            if (System.IO.File.Exists("C:\\Excel1.xls"))
            {
                //Delete The Existing Excel Sheet
                System.IO.File.Delete("C:\\Excel1.xls");
            }
            //create Excel spreadsheet

            WRExcel = new Excel.Application();

            WRwb = WRExcel.Workbooks.Add(objOpt); // My Error Occurs Here

            WRss = (Excel.Sheets)WRwb.Worksheets;

            WRws = (Excel._Worksheet)(WRss.get_Item(1));

            //create Excel column headings

            WRws.Cells[1, 1] = "Part Number.";

            WRws.Cells[1, 2] = "Kit Part.";

            WRws.Cells[1, 3] = "Description";

            WRws.Cells[1, 4] = "Reason For Reject";


            WRws.Cells[2, 1] = RowNo.Trim();

            WRws.Cells[2, 2] = ColumnNo.Trim();

            WRws.Cells[2, 3] = ErrorMsg.Trim();

            WRws.Cells[2, 4] = Filename;
            
            //save workbook

            WRwb.SaveAs("C:\\Excel1.xls", objOpt, objOpt, objOpt, objOpt, Opt,                 Excel.XlSaveAsAccessMode.xlNoChange, objOpt, objOpt, objOpt, objOpt, objOpt);

            //close workbook

            WRwbs.Close();

Please Help me to Solve My Problem.

Thanks & Regards
Sanket Patil

Re: Unable To Create Excel Sheet At Runtime In my Application.

Prasanta_Prince28-Apr-11 3:02

Prasanta_Prince

28-Apr-11 3:02

http://forums.asp.net/t/1038105.aspx/1[^]

Creating a formatted MS-Excel sheet using ASP[^]

You can have a look on these.

Scorm content viewer

nachavle27-Apr-11 23:05

nachavle

27-Apr-11 23:05

I working on Asp.net3.0.
I want to play scorm course from my web application.
Is there any way to view from application.

Problem with cascading DropDownLists in a databound DetailsView

kbalias27-Apr-11 21:30

kbalias

27-Apr-11 21:30

Hi
I am trying to develop a website using ASP.NET 4.0 and Visual Web Developer 2010 Express. I am struggling with cascading DropDownLists in a DetailsView when the DetailsView is bound to a SqlDataSource.

I have tried the logic outside the DetailsView and the cascading DropDownLists work fine.

The markup for the DropDownLists outside the DetailsView is as follows:

<asp:DropDownList ID="ddlFirms" runat="server" AutoPostBack="True" 
    AppendDataBoundItems="True" DataSourceID="SqlDataSource_Firms1" DataTextField="Firm" 
    DataValueField="FirmID" 
    onselectedindexchanged="ddlFirms_SelectedIndexChanged">
    <asp:ListItem Value="">- select -</asp:ListItem>
</asp:DropDownList>
<asp:SqlDataSource ID="SqlDataSource_Firms1" runat="server" 
    ConnectionString="<%$ ConnectionStrings:MyConnectionString1 %>" 
    SelectCommand="SELECT * FROM [Firms] ORDER BY [Firm]"></asp:SqlDataSource>


<asp:DropDownList ID="ddlClinics" runat="server" 
    AppendDataBoundItems="True" DataSourceID="SqlDataSource_Clinics1" DataTextField="Clinic" 
    DataValueField="ClinicID">
    <asp:ListItem Value="">- select -</asp:ListItem>
</asp:DropDownList>
<asp:SqlDataSource ID="SqlDataSource_Clinics1" runat="server" 
    ConnectionString="<%$ ConnectionStrings:MyConnectionString1 %>" 
    SelectCommand="SELECT * FROM [Clinics] WHERE ([FirmID] = @FirmID) ORDER BY [Clinic]">
    <SelectParameters>
        <asp:ControlParameter ControlID="ddlFirms" Name="FirmID" 
            PropertyName="SelectedValue" Type="Int32" />
    </SelectParameters>
</asp:SqlDataSource>

And the code-behind:

protected void ddlFirms_SelectedIndexChanged(object sender, EventArgs e)
{
    //this is to clear the list in ddlClinics before it is repopulated with the relevant list for the selected
    //item in ddlFirms
    ddlClinics.Items.Clear();
    //without this line the initial value was not added
    ddlClinics.Items.Add("- select -");
}

This works fine. When a listItem is selected in the ddlFirms, only the relevant listItems for that firm is populated in ddlClinics.

When I try it in the DetailsView it is not so straight-forward. The problem is that if I try to do the logic exactly as for when the DropDownLists which are not in a DetailsView, it gives me the error: "has a SelectedValue which is invalid because it does not exist in the list of items." When I remove the line ddlClinics.Items.Clear(); that causes the error, the ListItems are just added to the Clinics DropDownList in the DetailsView each time a ListItem is selected in the Firms DropDownList and not replaced with only the relevant ListItems for the selected Firm.

My markup for the DetailsView:

<asp:SqlDataSource ID="SqlDataSource_RTTest" runat="server" 
    ConnectionString="<%$ ConnectionStrings:MyConnectionString1 %>" 
    SelectCommand="SELECT * FROM [RTNumbers] WHERE ([RTID] = @RTID)">
    <SelectParameters>
        <asp:ControlParameter ControlID="HiddenField1" Name="RTID" PropertyName="Value" 
            Type="Int32" />
    </SelectParameters>
</asp:SqlDataSource>
<asp:HiddenField ID="HiddenField1" runat="server" />


<asp:DetailsView ID="DetailsView2" runat="server" 
    AutoGenerateInsertButton="True" AutoGenerateRows="False" DataKeyNames="RTID" 
    DataSourceID="SqlDataSource_RTTest" Height="50px" Width="125px">
    <EmptyDataTemplate>
        <asp:LinkButton ID="FormViewInsert" runat="server" 
            onclick="DetailsView2_Click">Insert a new RT record</asp:LinkButton>
    </EmptyDataTemplate>
    <Fields>
        <asp:TemplateField HeaderText="Firm" SortExpression="FirmID">
            <InsertItemTemplate>
                <asp:DropDownList ID="ddlFirms_DetailsView" runat="server" AutoPostBack="True"
                    AppendDataBoundItems="True" DataSourceID="SqlDataSource_Firms2" 
                    DataTextField="Firm" DataValueField="FirmID" 
                    SelectedValue='<%# DataBinder.Eval(Container.DataItem,"FirmID")%>' Enabled="True"
                        OnSelectedIndexChanged="ddlFirms_DetailsView_SelectedIndexChanged">
                    <asp:ListItem Value="">- select -</asp:ListItem>
                </asp:DropDownList> 
                <asp:SqlDataSource ID="SqlDataSource_Firms2" runat="server" 
                    ConnectionString="<%$ ConnectionStrings:MyConnectionString1 %>" 
                    SelectCommand="SELECT * FROM [Firms] ORDER BY [Firm]">
                </asp:SqlDataSource>

            </InsertItemTemplate>
            <ItemTemplate>
                <asp:Label ID="Label3" runat="server" Text='<%# Bind("FirmID") %>'></asp:Label>
            </ItemTemplate>
        </asp:TemplateField>
        <asp:TemplateField HeaderText="Clinic" SortExpression="ClinicID">
            <InsertItemTemplate>
                <asp:DropDownList ID="ddlClinics_DetailsView " runat="server"
                    AppendDataBoundItems="True" DataSourceID="SqlDataSource_Clinics2" 
                    DataTextField="Clinic" DataValueField="ClinicID" 
                    SelectedValue='<%# DataBinder.Eval(Container.DataItem,"ClinicID")%>' 
                    Enabled="True" AutoPostBack="False">
                    <asp:ListItem Value="">- select -</asp:ListItem>
                </asp:DropDownList> 
                <asp:SqlDataSource ID="SqlDataSource_Clinics2" runat="server" 
                    ConnectionString="<%$ ConnectionStrings:MyConnectionString1 %>" 
                            
                    SelectCommand="SELECT * FROM [Clinics] WHERE ([FirmID] = @FirmID) ORDER BY [Clinic]">
                    <SelectParameters>
                        <asp:ControlParameter ControlID="ddlFirms2" Name="FirmID" 
                            PropertyName="SelectedValue" Type="Int32" />
                    </SelectParameters>
                </asp:SqlDataSource>

            </InsertItemTemplate>
            <ItemTemplate>
                <asp:Label ID="Label4" runat="server" Text='<%# Bind("ClinicID") %>'></asp:Label>
            </ItemTemplate>
        </asp:TemplateField>
    </Fields>
</asp:DetailsView>

And the code-behind:

protected void ddlFirms_DetailsView_SelectedIndexChanged(object sender, EventArgs e)
{
    DropDownList ddlClinics = (DropDownList)DetailsView2.FindControl("ddlClinics_DetailsView");

    //this line causes the following error: "has a SelectedValue which is invalid because it does not exist in the list of items."
    ddlClinics.Items.Clear();

    ddlClinics.Items.Add("- select -");
}

If I leave out the ddlFirms_DetailsView_SelectedIndexChanged() event handler then whenever I select a listItem in the ddlFirms_DetailsView for the first time then the correct relevant listItems for that firm is populated in ddlClinics_DetailsView.
However when I select another listItem in ddlFirms_DetailsView the relevant listItems for the new selection is just added to ddlClinics_DetailsView (in other words it also still have the listItems for the previously selected item in ddlFirms_DetailsView as well).

I am a bit stuck here.

Regards.

Kobus

Re: Problem with cascading DropDownLists in a databound DetailsView

Ali Al Omairi(Abu AlHassan)28-Apr-11 0:45

Ali Al Omairi(Abu AlHassan)

28-Apr-11 0:45

Sir, i think that you need to add an update panel so the content of the dropdown list could be changed.

100 Rose | [Rose]

Help people,so poeple can help you.

ObjectDataSource for DevExpress ASPxGtridView with enabled paging, sorting, grouping, external filters

trongood27-Apr-11 21:15

trongood

27-Apr-11 21:15

The class is described below allows the use of grouping, sorting, pagind, external filters with DevExpress ASPxGridView, but using data access method as standart ASP.NET ObjectDataSource

Initialization of data binding in ASPxGridView looks like this:

protected override void OnInit(EventArgs e)
{
    base.OnInit(e);

    if (!IsPostBack)
    {
        DXExtensions.Data.DXObjectDataSource dxOdsAddress = new DXExtensions.Data.DXObjectDataSource();
        dxOdsAddress.PageSize = gvAddress.SettingsPager.PageSize;
        dxOdsAddress.KeyFeildName = gvAddress.KeyFieldName;
        dxOdsAddress.DataType = typeof(DomainModel.AddressEntities.Address);
        dxOdsAddress.Request_DataSource += new EventHandler<DXExtensions.Data.DXObjectDataSource.PagingEventArgs>(dxodsAddress_RequestDataSource);
        dxOdsAddress.Request_TotalRowsCount += new EventHandler(dxodsAddress_RequestTotalRowsCount);
        dxOdsAddress.Request_GroupInfo += new EventHandler<DXExtensions.Data.DXObjectDataSource.GroupingEventArgs>(dxodsAddress_RequestGroupInfo);
        Session["dxOdsAddress"] = dxOdsAddress;        
    }

    gvAddress.DataSource = Session["dxOdsAddress"] as DXExtensions.Data.DXObjectDataSource;
}

This class is based on the example described here: A possible implementation of IListServer interface to achieve Server Mode functionality
DXObjectDataSource class:

using System;
using System.Collections;
using System.Collections.Generic;
using System.ComponentModel;
using System.Linq;
using System.Text;
using System.Web;
using System.Web.UI;
using DevExpress.Data;

namespace DXExtensions.Data
{
    public class DXObjectDataSource : IListServer, ITypedList
    {
        #region New
                
        #region Exceptions

        public class DataSourceNotBindedException : Exception
        {
            public DataSourceNotBindedException()
                : base()
            {}
        }

        public class DataSourceSubcriberNotFoundException : Exception
        {
            public DataSourceSubcriberNotFoundException()
                : base()
            { }
        }

        public class TotalRowsCountNotBindedException : Exception 
        {
            public TotalRowsCountNotBindedException()
                : base()
            { }
        }

        public class TotalRowsCountSubscriberNotFoundException : Exception
        {
            public TotalRowsCountSubscriberNotFoundException()
                : base()
            { }
        }

        public class UnexpectedLogicWayException : Exception
        {
            public UnexpectedLogicWayException()
                : base()
            { }
        }

        #endregion

        #region PublicConnectors

        /// &lt;summary&gt;
        /// For paging with sorting
        /// &lt;/summary&gt;
        public class PagingEventArgs : EventArgs
        {
            private int _StartRowIndex;
            public int StartRowIndex
            {
                get
                {
                    return _StartRowIndex;
                }
                set
                {
                    _StartRowIndex = value;
                }
            }

            private int _RowsCount;
            public int RowsCount
            {
                get
                {
                    return _RowsCount;
                }
                set
                {
                    _RowsCount = value;
                }
            }

            private ICollection&lt;ServerModeOrderDescriptor&gt; _SortInfo;
            public ICollection&lt;ServerModeOrderDescriptor&gt; SortInfo
            {
                get
                {
                    return _SortInfo;
                }
                set
                {
                    _SortInfo = value;
                }
            }
        }

        /// &lt;summary&gt;
        /// For grouping with pagind and sorting
        /// &lt;/summary&gt;
        public class GroupingEventArgs : EventArgs
        {
            ListSourceGroupInfo _ParentGroupInfo;
            public ListSourceGroupInfo ParentGroupInfo
            {
                get
                {
                    return _ParentGroupInfo;
                }
                set
                {
                    _ParentGroupInfo = value;
                }
            }

            List&lt;ListSourceGroupInfo&gt; _GroupInfo;

            public List&lt;ListSourceGroupInfo&gt; GroupInfo
            {
                get
                {
                    return _GroupInfo;
                }
                set
                {
                    _GroupInfo = value;
                }
            }
        }

        /// &lt;summary&gt;
        /// Fires when data source needs a specific page from the database
        /// &lt;/summary&gt;
        public event EventHandler&lt;PagingEventArgs&gt; Request_DataSource;

        /// &lt;summary&gt;
        /// Fires when data source needs the number of rows using external filters
        /// &lt;/summary&gt;
        public event EventHandler Request_TotalRowsCount;

        /// &lt;summary&gt;
        /// Fires when data source needs group info
        /// &lt;/summary&gt;
        public event EventHandler&lt;GroupingEventArgs&gt; Request_GroupInfo;

        /// &lt;summary&gt;
        /// Used when external filters changed
        /// &lt;/summary&gt;
        public void RefreshForNewFilters()
        {
            _ActualizeDataSource_StartIndex = 0;
            _DataSource = null;
        } //надо избавиться от этого метода, но это проблематично пока используем внешние фильтры

        #endregion

        #region Propertyes
        
        private Type _DataType;
        /// &lt;summary&gt;
        /// The data type must be defined before binding
        /// &lt;/summary&gt;
        public Type DataType
        {
            get
            {
                return _DataType;
            }
            set
            {
                _DataType = value;
            }
        }

        private IList _DataSource;
        /// &lt;summary&gt;
        /// Stores range of rows
        /// &lt;/summary&gt;
        public IList DataSource
        {
            get
            {
                return _DataSource;
            }
            set
            {
                _DataSource = value;
            }
        }

        private Int32 _TotalRowsCount = -1;
        public Int32 TotalRowsCount
        {
            get
            {
                return _TotalRowsCount;
            }
            set
            {
                _TotalRowsCount = value;
            }
        }

        private Int32 _PageSize;
        /// &lt;summary&gt;
        /// The page size must be defined before binding
        /// &lt;/summary&gt;
        public Int32 PageSize
        {
            get
            {
                return _PageSize;
            }
            set
            {
                _PageSize = value;
            }
        }
        
        private string _KeyFeildName;
        /// &lt;summary&gt;
        /// The key field name must be defined before binding
        /// &lt;/summary&gt;
        public string KeyFeildName
        {
            get
            {
                return _KeyFeildName;
            }
            set
            {
                _KeyFeildName = value;
            }
        }

        /// &lt;summary&gt;
        /// Stores the previous collection sorting
        /// Need to understand that sort has changed
        /// &lt;/summary&gt;
        private ICollection&lt;ServerModeOrderDescriptor&gt; _SortInfo;

        #endregion

        /// &lt;summary&gt;
        /// Required not to send a query to the first page when it is not necessary
        /// &lt;/summary&gt;
        bool IsZeroIndexActual;

        /// &lt;summary&gt;
        /// Start row index for stored rows range
        /// &lt;/summary&gt;
        private int _ActualizeDataSource_StartIndex;

        /// &lt;summary&gt;
        /// Checks stored rows range and if necessary request a new range of rows from database using Request_DataSource event
        /// &lt;/summary&gt;
        /// &lt;param name="index"&gt;row index&lt;/param&gt;
        /// &lt;returns&gt;page size row index, not table row index&lt;/returns&gt;
        protected int ActualizeDataSource(int index)
        {
            bool isDataSourceActual = true;
            if (_DataSource == null)
            {                
                isDataSourceActual = false;                
            }
            else
            {
                if ((index == 0) &amp;&amp; (!IsZeroIndexActual))
                {
                    return 0;
                }
                else
                {
                    if ((index &gt;= _ActualizeDataSource_StartIndex + _PageSize) || ((index &lt; _ActualizeDataSource_StartIndex)))
                    {
                        isDataSourceActual = false;
                    }
                }
            }

            if (!isDataSourceActual)
            {
                _ActualizeDataSource_StartIndex = index;

                PagingEventArgs pea = new PagingEventArgs();
                pea.StartRowIndex = index;
                pea.RowsCount = _PageSize;
                pea.SortInfo = _SortInfo;                

                if (Request_DataSource != null)
                {
                    Request_DataSource(this, pea);
                    if (_DataSource == null)
                    {
                        throw new DataSourceNotBindedException();
                    }
                }
                else
                {
                    throw new DataSourceSubcriberNotFoundException();
                }
            }
            int ret = index - _ActualizeDataSource_StartIndex;
            if (ret &lt; 0)
            {
                ret = 0;
            }
            return ret;
        }

        #endregion

        #region IList Enabled

        object IList.this[int index]
        {
            get
            {
                int actualRecordIndex = ActualizeDataSource(index);

                if (_DataSource != null)
                {
                    return _DataSource[actualRecordIndex];
                }
                return null;
            }
            set
            {
                throw new NotImplementedException();
            }
        }

        #endregion

        #region ICollection Enabled

        int ICollection.Count
        {
            get
            {
                return _TotalRowsCount;
            }
        }

        #endregion

        #region ITypedList Enabled

        PropertyDescriptorCollection ITypedList.GetItemProperties(PropertyDescriptor[] listAccessors)
        {
            IsZeroIndexActual = false; //true in Aplly

            PropertyDescriptorCollection pdc = TypeDescriptor.GetProperties(_DataType);

            if (Request_TotalRowsCount != null)
            {
                Request_TotalRowsCount(this, new EventArgs());
                if (_TotalRowsCount &lt; 0)
                {
                    throw new TotalRowsCountNotBindedException();
                }
            }
            else
            {
                throw new TotalRowsCountSubscriberNotFoundException();
            }
            return pdc;
        }

        #endregion

        #region DevExpress.Data.IListServer Enabled

        void IListServer.Apply
            (
                DevExpress.Data.Filtering.CriteriaOperator filterCriteria,
                ICollection&lt;ServerModeOrderDescriptor&gt; sortInfo,
                int groupCount,
                ICollection&lt;ServerModeSummaryDescriptor&gt; groupSummaryInfo,
                ICollection&lt;ServerModeSummaryDescriptor&gt; totalSummaryInfo
            )
        {
            if ((_SortInfo != sortInfo)) //new sort collection
            {
                _ActualizeDataSource_StartIndex = 0;
                _DataSource = null;
                _SortInfo = sortInfo;
            }

            IsZeroIndexActual = true; //Now when you request the index 0 should search the data for the first page
        }

        object IListServer.GetRowKey(int index)
        {
            int actualRecordIndex = ActualizeDataSource(index);
                        
            if (_DataSource != null)
            {
                System.Reflection.PropertyInfo pi = _DataType.GetProperty(KeyFeildName);
                System.Reflection.MethodInfo mi = pi.GetGetMethod();
                object recordObject = _DataSource[actualRecordIndex];
                object ret = mi.Invoke(recordObject, null);
                return ret;
            }
            else
            {
                throw new UnexpectedLogicWayException();
            }
        }

        List&lt;ListSourceGroupInfo&gt; IListServer.GetGroupInfo(DevExpress.Data.ListSourceGroupInfo groupInfo)
        {
            GroupingEventArgs gea = new GroupingEventArgs();
            gea.ParentGroupInfo = groupInfo;
            if (Request_GroupInfo != null)
            {
                Request_GroupInfo(this, gea);
                return gea.GroupInfo;
            }
            else
            {
                throw new NotImplementedException();
            }
        }
                
        #endregion

        #region Disabled
        
        #region IList Disabled

        int IList.Add(object value)
        {
            throw new NotImplementedException();
        }

        void IList.Clear()
        {
            throw new NotImplementedException();
        }

        bool IList.Contains(object value)
        {
            throw new NotImplementedException();
        }

        int IList.IndexOf(object value)
        {
            throw new NotImplementedException();
        }

        void IList.Insert(int index, object value)
        {
            throw new NotImplementedException();
        }

        bool IList.IsFixedSize
        {
            get { throw new NotImplementedException(); }
        }

        bool IList.IsReadOnly
        {
            get { throw new NotImplementedException(); }
        }

        void IList.Remove(object value)
        {
            throw new NotImplementedException();
        }

        void IList.RemoveAt(int index)
        {
            throw new NotImplementedException();
        }

        #endregion

        #region ICollection Disabled

        void ICollection.CopyTo(Array array, int index)
        {
            throw new NotImplementedException();
        }

        bool ICollection.IsSynchronized
        {
            get { throw new NotImplementedException(); }
        }

        object ICollection.SyncRoot
        {
            get { throw new NotImplementedException(); }
        }

        #endregion

        #region IEnumerable Disabled

        IEnumerator IEnumerable.GetEnumerator()
        {
            throw new NotImplementedException();
        }

        #endregion

        #region ITypedList Disabled

        string ITypedList.GetListName(PropertyDescriptor[] listAccessors)
        {
            return "";
        }

        #endregion
        
        #region DevExpress.Data.IListServer Disabled

        /// &lt;summary&gt;
        /// disabled
        /// &lt;/summary&gt;
        event EventHandler&lt;ServerModeExceptionThrownEventArgs&gt; IListServer.ExceptionThrown
        {
            add { throw new NotImplementedException(); }
            remove { throw new NotImplementedException(); }
        }

        /// &lt;summary&gt;
        /// disabled
        /// &lt;/summary&gt;
        event EventHandler&lt;ServerModeInconsistencyDetectedEventArgs&gt; IListServer.InconsistencyDetected
        {
            add { throw new NotImplementedException(); }
            remove { throw new NotImplementedException(); }
        }

        /// &lt;summary&gt;
        /// disabled
        /// &lt;/summary&gt;
        IList IListServer.GetAllFilteredAndSortedRows()
        {
            throw new NotImplementedException();
        }

        /// &lt;summary&gt;
        /// disabled
        /// &lt;/summary&gt;
        int IListServer.GetRowIndexByKey(object key)
        {
            throw new NotImplementedException();
        }

        /// &lt;summary&gt;
        /// disabled
        /// &lt;/summary&gt;
        int IListServer.FindIncremental
            (
                DevExpress.Data.Filtering.CriteriaOperator expression,
                string value,
                int startIndex,
                bool searchUp,
                bool ignoreStartRow,
                bool allowLoop
            )
        {
            throw new NotImplementedException();
        }

        /// &lt;summary&gt;
        /// disabled
        /// &lt;/summary&gt;
        Dictionary&lt;object, object&gt; IListServer.GetTotalSummary()
        {
            throw new NotImplementedException();
        }

        /// &lt;summary&gt;
        /// disabled
        /// &lt;/summary&gt;
        object[] IListServer.GetUniqueColumnValues(DevExpress.Data.Filtering.CriteriaOperator expression, int maxCount,
        bool includeFilteredOut)
        {
            throw new NotImplementedException();
        }

        /// &lt;summary&gt;
        /// disabled
        /// &lt;/summary&gt;
        int IListServer.LocateByValue(DevExpress.Data.Filtering.CriteriaOperator expression, object value, int
            startIndex, bool searchUp)
        {
            throw new NotImplementedException();
        }

        /// &lt;summary&gt;
        /// disabled
        /// &lt;/summary&gt;
        void IListServer.Refresh()
        {
            throw new NotImplementedException();
        }

        #endregion

        #endregion
    }
}

Re: ObjectDataSource for DevExpress ASPxGtridView with enabled paging, sorting, grouping, external filters

Mehul Harry28-Apr-11 14:03

Mehul Harry

28-Apr-11 14:03

Thanks Trongood,

There are two examples, that Vest from DevExpress support team has made that help also:

http://www.devexpress.com/example=E2672 -- Bind a grid to a ObjectDataSource with EnablePaging

and the last version of the sample:

http://www.devexpress.com/example=E166 -- A possible implementation of IListServer interface to achieve Server Mode functionality

was changed to support Sorting feature using LINQ (because LINQ expressions are easier to understand).

Thanks.

-Mehul Harry

input validation

jashimu27-Apr-11 9:38

27-Apr-11 9:38

Hi all, I am still new to web base programming. I have a redio button list and I am currently setting autopostback to true. But it blink the page, when change optins, I don't want the trip to server when I am not doing anything with the server. I wanted to use javascript to do the work for me.

Since I have never used it before having very dificult to use it. Lets Say Yes and No two optins. if user slect No it should do something and same for Yes option.

please help.

gavindon27-Apr-11 9:49

27-Apr-11 9:49

you would set autopostback to false. that stops the server trip.
Put your "do something" code as follows

protected void RadioButtonList1_SelectedIndexChanged(object sender, EventArgs e)
       {
                //do something here
       }

Programming is a race between programmers trying to build bigger and better idiot proof programs, and the universe trying to build bigger and better idiots, so far... the universe is winning.

jashimu27-Apr-11 10:22

27-Apr-11 10:22

I alredy have something like this. but when I change my selection the page blink which I am trying to avoid. Just use javascript to do that so it will not go through server.

gavindon27-Apr-11 10:38

27-Apr-11 10:38

you said you had autopostback set to true. this must be set to false to stop the postback when you select a different button

Programming is a race between programmers trying to build bigger and better idiot proof programs, and the universe trying to build bigger and better idiots, so far... the universe is winning.

jashimu27-Apr-11 10:51

27-Apr-11 10:51

If I set autopost back to false then it is not catching the even when I change the selection from yes to No radio button.

Prasanta_Prince28-Apr-11 3:06

Prasanta_Prince

28-Apr-11 3:06

In case of Auto postback false selected index change will not fire.

jashimu28-Apr-11 10:32

28-Apr-11 10:32

this is exactly what is happening. it is not firing the event when I change No to Yes on radio button options

All I want is that when the option is changed show two textboxes or not.

thanks

Declarative vs Programmatic: opinions

m@dhu27-Apr-11 18:59

m@dhu

27-Apr-11 18:59

You can use a update panel for partial postback of the page.

jashimu wrote:
I wanted to use javascript to do the work for me

Check the link and change your code according to your requirement.
http://weblogs.asp.net/gurusarkar/archive/2010/10/14/get-radiobuttonlist-selectedvalue-in-javascript.aspx[^]

Brad Tumer27-Apr-11 8:55

Brad Tumer

27-Apr-11 8:55

I have an ongoing debate with a co-worker about the merit of using server controls or code-behind for data, and I thought I'd post here for other people's opinions. I use SqlDataSources bound to controls, whereas he puts labels on the page and does everything in the code. (Oh, and I use stored procedures and not text commands, which I feel suffices for a DAL in small apps, so let's skip that argument.) I like it because it seems cleaner, faster, more concise, and gives access to the control events so work can be done at the appropriate time. Which do you prefer and why?

Re: Declarative vs Programmatic: opinions

Not Active28-Apr-11 2:39

Not Active

28-Apr-11 2:39

Using controls such as SqlDataSource is faster in some respects, however, it does not suffice as a true DAL, not even with stored procs. (Its an argument you will loose 9 out of 10 time). This method binds the presentation to data much too strongly for me. You should be able to build the application so each layer is independent.

I would say you are both right to a certain extent. The co-worker who is building everything by hand is going too far. DataBinding and templates can be used quite effectively. Separating the presentation and data, such as in a MVC or MVVM pattern gives much more flexibility and code reuse.

I know the language. I've read a book. - _Madmatt

Re: Declarative vs Programmatic: opinions

Prasanta_Prince28-Apr-11 3:09

Prasanta_Prince

28-Apr-11 3:09

Good answer @mark.

Re: Declarative vs Programmatic: opinions

Renat Khabibulin4-May-11 17:09

Renat Khabibulin

4-May-11 17:09

Are this labels put on the form only once at the beggining of the page "lifecycle"? If yes - then declarative way would be better for traffic. Because each change of the page, which occurs in OnLoad() method is added to ViewState and travels to client with html page. If labels will be defined in .aspx then they will be created on Init() step and there will no additional ViewState data

pdfbox error

gavindon27-Apr-11 8:24