.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Convert IList to datatable Error "Only a single enumeration is supported by this IEnumerable."

Posted By:      Posted Date: October 13, 2010    Points: 0   Category :WCF


I am working in WCF Data service, in client side i am returning result as IEnumerable as below.

IEnumerable<MTSR> SearchResult = context1.Execute<MTSR>(new Uri(url));

i am converting this enumerable to datatable as below.

public static DataTable ToDataTable<T>(IList<T> data)

            PropertyDescriptorCollection props =
            DataTable table = new DataTable();
            for (int i = 0; i < props.Count; i++)
                PropertyDescriptor prop = props[i];
                table.Columns.Add(prop.Name, prop.PropertyType);
            object[] values = new object[props

View Complete Post

More Related Resource Links

How to convert DataTable objects to IList without using For Each Loop


DataTable result = GetDataSetByQuery(query).Tables[0]
IList<string> li=new IList<string>();

Can we implement through LINQ ?

Convert .docx to web page - "the converter cannot complete the task because an internal error occurr


I'm trying to convert docx files to webpages to be published in to a library elsewhere on our sharepoint site. At first I was having no problem, the files were converting, however more recent files have returned the error: the converter cannot complete the task because an internal error occurred

I've tried writing, uploading and converting a simple docx file, and this works which has led me to believe that the problem is something in the docx files that i'm trying to convert. So i tried using word07 to clean the documents up by clicking Office button>prepare>inspect document then removing all the metadata, custom xml etc from the files resave, upload and convert, but still no joy.

I'd simply rewrite the document but the problem is that there are a lot of them.

Any ideas what's going wrong?


Expose DataTable from WCF service, all Generic lists convert to arrays

I added a method to a .Net 3.5 WCF web service that returns a DataTable.  Other methods in the web service return Generic lists and/or take Generic lists as parameters.  When I update my reference to the altered web service from my client application all generic lists used as parameters or return types from all methods in the web service are converted to arrays.  In my service reference settings I have selected "System.Collections.Generic.List."  Apparently this setting has no effect when a web service returns a DataTable? Is there any way to prevent this from occuring? Steps to reproduce: Create a web service with methods that return Generic lists and/or take Generic lists as parameters. In a client application reference the web service and select "System.Collections.Generic.List" as the collection type.  Verify that return types/parameter types are generic lists. Add a method to the web service that returns a DataTable.  In a client application update the service reference. Note that all Generic lists (either as return types or method parameters) have changed to arrays.  This occurs even though the collection type service reference setting remains as "System.Collections.Generic.List".  Tom Regan

Cannot Implicitly Convert Type Ilist to List

Hi All, In the below code i get the Following Error, Cannot implicitly convert type 'System.Collections.Generic.List<Nous.nSpeckEnterprise.GetEnterpriseComponent_Result>' to 'System.Collections.Generic.IList<Nous.nSpeckEnterprise.Component>'. An explicit conversion exists (are you missing a cast?)   <br/> NSTTT_CRRISQ_TESTEntities entities = new NSTTT_CRRISQ_TESTEntities();<br/> IList<Component> Components = new List<Component>();<br/> var c = entities.GetEnterpriseComponent(componentId).ToList();<br/> <strong>Components = c;<br/> </strong> return Components;   Can anyone help me how to do teh cast.......Thanks  

error: cannot implicitly convert type 'string' to 'int?'

Hey guys,I am trying yo build the following class for which i get an error on the line this.id = e.id as cannot implicitly convert type 'string' to 'int?'. can anybody help me with it??many many Thanks,Chetan.using System;using System.Collections;using System.Collections.Generic;using System.Linq;using System.Data.Linq;using System.Text;using System.Runtime.Serialization;using HsInternet.Data.DAL;namespace HsInternet.Data.BLL{    public class Baby    {        public int id { get; set; }        public string name { get; set; }        public string parents { get; set; }        public int gender { get; set; }        public string weight { get; set; }        public string length { get; set; }        public DateTime date { get; set; }        public DateTime time { get; set; }        public string image { get; set; }        public string ipa { get; set; }        public string ipb { get; set; }        public Baby()  &

Error on datafilling in DataTable on background worker

I have got some error while datafilling from DataTable to Datagridview on BackgroundWorker... I saw some where that "Should not fill datatable while its working in Backgroundworker"... How can I manage this situation? Is there any possible logic to do that? Help me Sir,

How can i convert my datatable into XML using C# 2.0?



I have a datatable in asp.net 2.0 and C# as Code behind. My question is how can i convert this datatable into XML and save it to my project directory. And How can i call it back from its location into any dataset, datatable, and how can i query this XML..?

Give example with code please...


WCF and ADO.NET entity framework - Convert IEnumerable to Datatable



We are using WCF and ADO.NET entity framework in our ASP.NET 4.0 application.  we are using Entity Framework in our WCF service to execute a storedprocedure and return the results.

        public List<Cs_MT> GetSearchResult(string emailId, string localTitle, string colorGrouping)
            MTEntities db = new MTEntities();
            var query = db.SearchResult(emailId, localTitle, colorGrouping);
            List<Cs_MT> searchList = query.ToList<Cs_MT>();
            return searchList;

We are calling the WCF service from our client application and get the results as IEnumerable

IEnumerable<GetSearchResult_ByEmail_Result> SearchResult = dsContext.Execute<GetSearchResult_ByEmail_Result>(new Uri(url)); 

I want to loop through the records and form

cannot convert strng to bool error



obj = new ArrayList();






if (country = india.ToString ())









cannot convert string to bool error in LINQ


hi guys,

this is my code:

DataClassesDataContext db = new DataClassesDataContext();
        item it = new item();

        var items = from p in db.items
                    where p.id = TextBox1.Text
                    select p;

        GridView1.DataSource = items;

an error message at line 5 says:

  Cannot implicitly convert type 'string' to 'bool'

the id attribute on the items table is of varchar(50) type. and the text box too is of string type.

so why does it says conversion between boolean and string problem?

thank you all.

Convert Document To Web Page Error


For site collection administrators and top level site designers the document conversion works correctly.  However, when a user who isn't one of these two roles tries to convert a word document to a web page they get the following error.  


An error was encountered performing this operation. You may re-try the operation, and you may need to clean up the half-created data first before re-trying. If the problem persists, please contact your system administrator.


I've tried giving the users designer permissions to their sites but they still get the error.  


Any ideas on how I can give users the ability to convert documents to web pages without making them site collection admins or designers of the top level site?



How to convert a DataTable to SPList



Is it possible to convert a datatable to SPList?


Error : Cannot convert method group 'ToString' to non-delegate type 'int'.

Ive gotten this error to my underlined line(bold): Cannot convert method group 'ToString' to non-delegate type 'int'. 
How do i Solve it??

 protected void GridView1_SelectedIndexChanged1(object sender, EventArgs e)

        Label2.Visible = true;
        SqlConnection conn = new SqlConnection("Data Source= EN12-2-20-PC02\\SQLEXPRESS;" + "Initial Catalog=ssms;Integrated Security=SSPI");

        DataSet ds = null;
        ds = new DataSet();
        int timestamp = 0;
        timestamp = GridView1.SelectedDataKey.Value.ToString;

        SqlDataAdapter da = null;
        string mySQL = null;
        mySQL = "SELECT timestamp from loginHistory where username = '" + lblShowUser.Text + "'";
        da = new SqlDataAdapter(mySQL, conn);
        da.Fill(ds, "loginHistory");
        DataSet dsSel = new DataSet();

        GridView1.DataSource = dsSel;

How to bind GridView and DropDownList controls using DataTable object

In .net framework 2.0, you can load a DataTable in memory by consuming a data source using a DataReader. In this version you will find the flexibility in accessing the DataReader means write access code once and use again and again using DataReader. To see the functionality of DataTable consider an example that is created using VS2005.

DataTable - Load from IDataReader - CreateDataReader - ReadXml WriteXml - Free ADO.NET Tutorials

The DataTable in ADO.NET 2.0 has been seriously beefed up and I absolutely love it. Not everything we consume deals with multiple resultsets and requires the ever popular DataSet. With the cool new features in the ADO.NET 2.0 DataTable, we can get many of the cool features in the DataSet without all the extra baggage and memory footprint particular to multiple resultsets.

Load DataTable from IDataReader

Convert English to Arabic number without changing any regional settings in .net

Well, most applications that I worked with was multilingual that supports English UI and Arabic UI.

And one of the major issue that we have faced is displaying Arabic numbers without the need of changing the regional settings of the PC.

So the code below will help you to display Arabic number without changing any regional settings.

IsapiModule Error 500 Issue


I am about exhausted trying to figure out this error:

HTTP Error 500.0 - Internal Server Error

Description: The page cannot be displayed because an internal server error has occurred.

Error Code: 0x8007007b

Notification: ExecuteRequestHandler

Module: IsapiModule

Requested URL: http://localhost:80/ReportServer

Physical Path: c:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\ReportServer

When I enable Failed Request Tracing Rules and view the log output I am supposing that the actual problem is in the 2nd call where there are 2 backslashes before the actual filename in the specified path:


CALL_ISAPI_EXTENSION DllName="C:\Windows\Microsoft.NET\Framework\v2.0.50727\\aspnet_isapi.dll"

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend