Write A Class For Retrieving IEnumerable Objects In EF And C#?
Mar 7, 2011
In my Code Behind I use several times this code below to bind and rebind (for refresh) e GridView after an insertion or other operations completed using EF objects.
Using a simple gridview.DataBind(); does not work because I call EF programmatically so I thought to use a Class to keep in memory this code that can create Objects for my GridView and call it how many time I need in my code avoiding redundancy.
IEnumerable<CmsContent> queryContents = myCurrentSlot.CmsContents.Where(x => x.IsPublished == true);
uxManageContents.DataSource = queryContents;
uxManageContents.DataBind();
Or do you know a batter way to Refresh the gridview after EF executing some commands? how to do it?
remember that I do use any data source web control for the gridview but i bind it programmatically.
View 1 Replies
Similar Messages:
Feb 25, 2010
I have been founding an effiecent way to retreive values returned by LINQ 2 SQL stored procdure on my presentaion layer. Am using following method rightnow:-
public List<String> MthInvitesBA()
{
List<String> lst = new List<string> { "" };
ISingleResult<USP_Actor_View_InvitesDetails1Result> invites = obj.USP_Actor_View_InvitesDetails1(p_UserName);
foreach (USP_Actor_View_InvitesDetails1Result c in invites)
{
lst = new List<string> { c.Invites_Used.ToString(), c.NoOfDoc.ToString(), c.Request_For_More_Invites.ToString() };
return lst;
}
return lst;
}
It works but at the cost of my performence due boxing unboxing on BA layer as well as on design layer. Now, I have one method which returns me 100 columns from table So in this way i have convert 100 coulmns value into type string then On design layer again have to type caste some values .Moreover, i could only access this list using index which is of type integer, which is very diffcult and tedious task to debug d code. i could effiecenlt retreive these values. Is it possible using IEnumerable? How to access Ienuemerable in design layer?
View 1 Replies
Mar 13, 2013
Nothing I find on the Internet is working.This is the closest I've gotten. It produces an output file without exceptioning but the output file has blank lines. But it's the correct number of blank lines.
Code:
public void WriteCSV<T>(IEnumerable<T> items, string path)
{
Type itemType = typeof(T);
var props = itemType.GetProperties(BindingFlags.Public | BindingFlags.Instance)
.OrderBy(p => p.Name);
[code]...
View 2 Replies
Feb 17, 2010
ERROR: Retrieving the COM class factory for component with CLSID {000209FF-0000-0000-C000-000000000046} failed due to the following error: 80070005
a. I had configured the DCOM on the server
b. If i run the APP on the server with any user: RUN!
c. If i run the APP using the Internet Explorer from any PC everything is fine until i try to call word
e. I have put all template (.dotx) on the server, on the PC and nothing WORD.
I am using office 2003.
View 2 Replies
Apr 9, 2010
I have an assembly that i have built with a linq to SQL item, a web reference and a class that brings it all together.I build the project and it all seems fine but when i reference the object from another project the web reference and linq objects are available but the class isnt.
View 2 Replies
Jan 11, 2011
I have an interesting problem with a WCF Service I am creating. As background fodder my solultion uses MVC 3 RC2 as the web interface. I am developing the solution as an N-Tier application using the Entity Framework 4.0 with POCO Self Tracking Entities, repository and unit of work approach. I am using the STE's more as an advanced POCO since STE do not seem to play well as of yet in the real world as they were meant to and since they do seem to give me better interfacing with the DB through my layers still. Additionally, I am incorporating WCF into the solution as the backend for the models based on info I am reading and the fact that I will need to also access these services via a windows service app on the client computers.
So, I have a datastore which includes my edm and the repositories. The POCO STEs are generated in a separate layer in what I have called my Domain Models. Within my domain area I also have a Core app holding my utilities. I am currently incorporating an additional domain element as a WCF service using the RESTful template. This WCF will be servicing both my MVC controllers and a Windows Service app on the client computers.
Now, on to the problem: Within this solution I have an Entity Set of People (or Person?). Within that Entity set I have a chain of inherited entities as follows Person->User->StaffMember->Provider where Provider is the resultant child. Within my WCF I have a ProviderService, a StaffMemberService and a UserService. In each of these Services one of my OperationContracts is a Get(string id) amongst others. the Get(String id) contract is the one that is causing me problems. Within that Get(String id) contract I do the following for the User:
[Code]....
and for the Provider:
[Code]....
Now, what has gotten me completely confused is that the Provider one works like a charm. But if I use the UserService to call the User of the same Id (Since User is a base class for Provider, this should work) I get an error saying it was a bad service call. (The ProviderService, as stated works and returns all the correct data). When I debug it, the UserService Get(String id) function actually works as expected up to and through the return statement (ie the user variable actually contains all the proper data that I would expect on the call). It is only after the return that I get the web page giving me that error and points me to the help page for the service. (I am using the browser to view the results at this point only). </P><P>I am assuming it has something to do with serialization? But why is it displaying the derived class with all expected data, which yes does include the data not being displayed as a user data, I am calling the data using the same UserId. I am not expecting someone to inspect my code, but to be a traffic cop and point me in the direction I need to look.
View 12 Replies
Jan 30, 2010
We can retrieve configuration sections from web.config in the following two ways:
Configuration config = WebConfigurationManager.OpenWebConfiguration("/");
AuthenticationSection authSection = (AuthenticationSection)
config.GetSection(@"system.web/authentication");
[code]...
View 1 Replies
Nov 25, 2010
I have created class in C# i need to use objects from this class to add them to a databse table.
the information come from textbox go into the object of the class than from this object i want to preform databse function.
View 2 Replies
Oct 3, 2010
I have a vb class that reads a single row of data from an SQL view. I want to add a property to it that will expose the value of a new bit field. But whatever I do my class always returns the value "false".What am I doing wrong?
Public ReadOnly Property IsPublished() As Boolean
Get
Return valPublished
End Get
End Property
Here's the relevant line from my datareader: Me.valPublished = Convert.ToBoolean(theObjectReader("Authorised"))Authorised is my bit field. I have tried it with and without the "ConvertToBoolean" statement.When I response write the value of the property for rows where this field is true, it always shows false.
View 4 Replies
Jan 20, 2010
I've create a custom attribute for my web pages... In the base page class I've created I'm trying to pull if that attribute has been set. Unfortunately it does not come back as part of the GetCustomAttributes function. Only if I explicitly use the typeof(myclass) to create the class. I have a feeling it's due to how asp.net classes are generated.
[Code]....
View 1 Replies
Jun 1, 2010
I have a vb.net application which I'm trying to run in VS 2008. The application builds successfully, however, when I try to debug the windows application it throws the following error, "Retrieving the COM class factory for component with CLSID {794D671E-F0F0-11D2-BEB0-009027438003} failed due to the following error: 80040154." I've been searching for a solution for a few days now with no luck. I've tried to register the referenced DLLs (w/regasm command), messed around with the configuration manager, etc. Also, please note that the application ran successfully in Windows XP, but it no longer seems to work since I've upgraded my OS to Windows 7 (I've tried to run the application in x64 and x84 platforms w/no luck). Also, I'm referencing the following DLLs:
INTEROP.ASPEMAILIB.DLLINTEROP.SCRIPTING.DLLINTEROPS.MSXML2.DLL
Is it possible that some of these DLLs aren't supported in Windows 7?
View 3 Replies
Feb 3, 2011
When I used the (way #1) below I could retrieve search result from my DB
Way #1:
[Code]....
But When I use( way#2) "separating my code to Presentation layer and data access layer ( using SQL HELPER CLASS )"
Way # 2
Presentation layer: protected void btn_Search_Advance_Click(object sender, EventArgs e)
[Code]....
data access layer:
[Code]....
I keep getting this error: Procedure or function 'SP_Search' expects parameter '@SEARCHTYPE', which was not supplied.
View 6 Replies
Jan 22, 2010
I am developing an application in ASP.NET 3.5. i am exporting data to excel file using some interops dll's. earlier i have developed the applicaion in Windows 2003 Server. at that time i could able to export the data to excel file. but recently i have upgraded my pc to Vista version.it is working fine in my localhost. when i deploy the application in IIS iam getting this error. like "Retrieving the COM class factory for component with CLSID {00024500-0000-0000-C000-000000000046} failed due to the following error: 80070005.". can any one let me know the resolution for this error.
View 1 Replies
Jan 16, 2014
I am using below code to find find no of slides in .ppt,.pptx and .pot file .
Microsoft.Office.Interop.PowerPoint.Application pptApplication = new Microsoft.Office.Interop.PowerPoint.Application();
Microsoft.Office.Interop.PowerPoint.Presentation pptPresentation = pptApplication.Presentations.Open(path, MsoTriState.msoFalse, MsoTriState.msoFalse, MsoTriState.msoFalse);
count=pptPresentation.Slides.Count;
It is working file in my system , but online it is showing error :
Retrieving the COM class factory for component with CLSID {91493441-5A91-11CF-8700-00AA0060263B} failed due to the following error: 80040154 Class not registered (Exception from HRESULT: 0x80040154 (REGDB_E_CLASSNOTREG)).
View 1 Replies
Oct 29, 2010
I am using Interface for Respositary.where these can be best used.Also googling to understand these.
What do mean by concret class and domain objects?
View 4 Replies
Jul 30, 2010
I am facing one problem that when i try to access a page in the website, i am getting the following error,
Retrieving the COM class factory for component with CLSID {58A02778-16FC-423D-91AC-4619BD71257F} failed due to the following error: 80040154.
Description:
An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Runtime.InteropServices.COMException: Retrieving the COM class factory for component with CLSID {58A02778-16FC-423D-91AC-4619BD71257F} failed due to the following error: 80040154.
Source Error:
[Code]....
Source File:
d:IEL_HELPDESKIEL-HelpDeskIELHelpDeskl_ticket_approval.aspx.cs
Line: 23 Stack Trace:
[Code]....
I went to that particular class file which is in the form of dll and in codebehind page of that class , builded the application, but it is not showing any compile time errors, but i put a break point it fails.
View 2 Replies
May 28, 2010
In page behind classes I am using a private and shared object and variables (list or just client or simplay int id) to temporary hold data coming from database or class library. This object is used temporarily to catch data and than to return, pass to some function or binding a control.1st: Can this approach harm any way ? I couldn't analyze it but a thought was using such shared variables may replace data in it when multiple users may be sending request at a time?
[code]...
View 2 Replies
Aug 27, 2010
Retrieving the COM class factory for component with CLSID
{11BD5260-15B6-412D-80DB-12BB60B8FE50} failed due to the following error: 80070005. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.UnauthorizedAccessException: Retrieving the COM class factory for component with CLSID {11BD5260-15B6-412D-80DB-12BB60B8FE50} failed due to the following error: 80070005.
ASP.NET is not authorized to access the requested resource. Consider granting access rights to the resource to the ASP.NET request identity. ASP.NET has a base process identity (typically {MACHINE}ASPNET on IIS 5 or Network Service on IIS 6) that is used if the application is not impersonating. If the application is impersonating via <identity impersonate="true"/>, the identity will be the anonymous user (typically IUSR_MACHINENAME) or the authenticated request user.
To grant ASP.NET access to a file, right-click the file in Explorer, choose "Properties" and select the Security tab. Click "Add" to add the appropriate user or group. Highlight the ASP.NET account, and check the boxes for the desired access.
View 3 Replies
Feb 15, 2011
[Code]....
While trying execute the above code in server, I am getting COM class factory error, as mentioned below
System.Runtime.InteropServices.COMException (0x80040154): Retrieving the COM class factory for component with CLSID {91493441-5A91-11CF-8700-00AA0060263B} failed due to the following error: 80040154.
My system configuration is Windows Server 2008 64bit. The solution for this issue is mentioned in [URL] As part of solution mention in above link, I cannot find the Microsoft Excel Application in the DCOM Config item. Does anyone know how to fix this issue? Or is there any alternative approach to fix this?
View 6 Replies
Jun 23, 2010
My Crystal Reports works perfectly when I have it on my local host, once I upload it to the server I get the error listed below. I ran the following MSI on the dedicated server: CRRedist2008_x86.msi.. If it is a permission issue, I am using Plesk Panel so there is no ASPNET user, it is different users, what user and what specific folder do I have to give permissions to? Retrieving the COM class factory for component with CLSID {5FF57840-5172-4482-9CA3-541C7878AE0F} failed due to the following error: 80070005.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.UnauthorizedAccessException: Retrieving the COM class factory for component with CLSID {5FF57840-5172-4482-9CA3-541C7878AE0F} failed due to the following error: 80070005.
ASP.NET is not authorized to access the requested resource. Consider granting access rights to the resource to the ASP.NET request identity. ASP.NET has a base process identity (typically {MACHINE}ASPNET on IIS 5 or Network Service on IIS 6) that is used if the application is not impersonating. If the application is impersonating via <identity impersonate="true"/>, the identity will be the anonymous user (typically IUSR_MACHINENAME) or the authenticated request user. To grant ASP.NET access to a file, right-click the file in Explorer, choose "Properties" and select the Security tab. Click "Add" to add the appropriate user or group. Highlight the ASP.NET account, and check the boxes for the desired access.
View 3 Replies
Feb 9, 2011
I am using Excel interop (Excel 2003) for excel import and export in my asp.net(2.0) application. When i deploy it in the server and when i try to import, i am getting the following error Retrieving the COM class factory for component with CLSID {00024500-0000-0000-C000-000000000046} failed due to the following error: 8000401a
View 1 Replies
Jul 6, 2010
I am facing below error
"Retrieving the COM class factory for component with CLSID {00024500-0000-0000-C000-000000000046} failed due to the following error: 80070005."
"at WebApplication1._Default.GenerateExcel(String xmlString) in E:\TestWebApp\WebApplication1\WebApplication1\Default.aspx.cs:line 110
at WebApplication1._Default.Page_Load(Object sender, EventArgs e) in E:\TestWebApp\WebApplication1\WebApplication1\Default.aspx.cs:line 30
at System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e)
at System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e)
at System.Web.UI.Control.OnLoad(EventArgs e)
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)"
View 1 Replies
May 7, 2015
Retrieving the COM class factory for component with CLSID {4DB2E2BB-78E6-4AEA-BEFB-FDAAB610FD1B} failed due to the following error: 80070005 Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED)).
View 1 Replies
Apr 19, 2010
can you give some information about how to write a class that return mor than one value
for ex. i want to create a class getSettings("UserName") that return the language and theme for that user.
View 2 Replies
Dec 1, 2010
We are getting an error when ASP.Net tries to connect to Crystal reports Server.
I am running this in my local PC. The code is developed in .net Framework 3.5. The application is showing the following error.
Retrieving the COM class factory for component with CLSID {E063B04A-CB8B-460E-99D0-F7D8FA2FAAA2} failed due to the following error: 80040154
I am running the .net Framework 3.5 code in my system. AND asp.net version is 2.0
View 1 Replies