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


Top 5 Contributors of the Month
david stephan
Santhakumar Munuswamy
Fauzul Azmi
Asad Ali
Post New Web Links

Problem with adding custom propety to a data class using Linq.

Posted By:      Posted Date: October 10, 2010    Points: 0   Category :ASP.Net
 

Hello,

I tried to add a custom property to the data model:


public partial class Department
    {
        public string ExtensionIdName
        {
            get
            {
                return Extension.ExtensionName;
            }
            set
            {
            }
        }
    }

It seems that it works, but when I bind the data to a ListView it shows all the properties except the property I added manualy (ExtensionIdName).

Am I missing something or is there something wrong?




View Complete Post


More Related Resource Links

Building a Custom Data Grid: Performing Ad Hoc Web Reporting with a VBScript 5.0 Class Object

  

A flexible, customizable grid for displaying data is a useful tool for ASP developers. It allows Web visitors to customize their view of your data. This article takes the data grid presented in "Ad Hoc Web Reporting with ADO 2.0" by John Papa and Charles Caison (MIND, December 1998) and adds handy features such as a finds feature that supports multiple finds and a mode for adding and editing records. This version also improves response time by allowing asynchronous record download and it componentizes the code so it can be used as a standalone VBScript class object that can be reused in other pages.

Randall Kindig

MSDN Magazine July 2000


Problem while retrieving data from a lookup column from sharepoint linq.

  
Hi I am working with sharepoint linq concept. When I am giving a query with lookup column It's working fine.  But when i am trying to retrieve the data from a look up column to spgridview. I was unable to get the output. Here is the above code which i have worked.   string strTitle = string.Empty; string strStatus=string.Empty; var context = new LinqSampleDataContext(SPContext.Current.Web.Url); EntityList<SharePoint2010ConceptsItem> Concept = context.GetList<SharePoint2010ConceptsItem>("SharePoint 2010 Concepts"); var query = from cs in Concept where cs.Status.Title.ToString()!="Completed" select new { cs.Title, cs.Id, //cs.Status }; sgvConcepts.DataSource =query; sgvConcepts.DataBind();   Any help me plz how to retrieve the data from a lockup column.bvnprasad

Problem with Retrieving data from lookup column using SharePoint 2010 Linq Concept

  
Hi I am working with sharepoint linq concept. When I am giving a query with lookup column It's working fine.  But when i am trying to retrieve the data from a look up column to spgridview. I was unable to get the output. Here is the above code which i have worked.   string strTitle = string.Empty; string strStatus=string.Empty; var context = new LinqSampleDataContext(SPContext.Current.Web.Url); EntityList<SharePoint2010ConceptsItem> Concept = context.GetList<SharePoint2010ConceptsItem>("SharePoint 2010 Concepts"); var query = from cs in Concept where cs.Status.Title.ToString()!="Completed" select new { cs.Title, cs.Id, //cs.Status }; sgvConcepts.DataSource =query; sgvConcepts.DataBind();   Any help me plz how to retrieve the data from a lockup column.bvnprasad

Sending Array of Custom Class over WCF Problem

  
I have been attempting to convert some service calls that returned a DataSet into something more lightweight. For instance, I am converting: [OperationContract] public DataSet GetCommittees(); into: [OperationContract] public List<VolunteerCommittee> GetCommittees(); where committee is defined as: [DataContract] public class VolunteerCommittee { [DataMember] public int Id { get; set; } [DataMember] public String Name { get; set; } } I copied the structure of the data contract and the operation contract right from an example in a book I bought on WCF. The author mentioned that the List<VolunteerCommittee> would get converted into an array over the wire, so the client's operation contract looks like: [OperationContract] public VolunteerCommittee[] GetCommittees(); My problem: When the service is called, an empty array is returned every time. When I put trace statements in, I see an array of 48 VolunteerCommittees leaving the server. I've done some reading on the problem and tried a number of suggestions, such as using the XmlSerializer attribute, including a certain namespace as a [return:] on the server's contract, changing the type of binding (it's using wsHttpBinding... I tried basicHttpBinding) and turning off MTOM in the behavior, but none of these changed the empty result of the call. At this point, I'm hoping someone can shine some light on

FormView custom data binding problem

  
Hi there,   I'm using VWD 2010 ASP.NET 4.0 and SQL Server 2008 Also I have login page with the ASP.NET configuration   one of my page has FormView with Update feature   Evryting works fine user login go to my FormView page and update the record.   Now I created a simple function   Protected Function GetUserName() As String        Return User.Identity.Name    End Function   and one of my coloumn call EditedBy   I replaced the Bind("EditedBy") field binding with   Custom binding GetUserName()   When user update it show the current user login name on the screen But it won't show in the table itself (it show null value when i do select statement)   I used to do this with ASP.NET 2.0 with no problem?   How do I fix that?   Thanks, Oded Dror  

LINQ: Problem in fetching data

  
Hi, i am developing something in LINQ, in this i am using some query for selecting data like this:var data = (from w in db2.TextSubCats where w.SubCatName.Trim()==reci_i.Recipe_cat.Trim() select w.SubCatName);but how could i fetch this data, i knows there is a solution by using foreach statement like this:foreach (var data_i in data){}my problem is this, if there no data returned by query then this foreach statment is just skipped.....so how could i get data returned by query in string so that i could perform my string manipulations... Thanks for your time.

Custom Webpart not working on "My Profile" page but works on all other pages. Linq Problem?

  
Hi, I created a publication site and in that site i created pages with specifique metadata (using a pagelayout with a custom content type)0. My webpart is getting data from those pages and displaying it. My webpart works on every page except on the "my profile" page(overview tab). I get the following error: Invalid Url: /TestSites/course I used the SPMETAL to create a class and i'm using this class to retrieve the data from the pages (with linq). The url i give to the entity is http://pcp/TestSites/course  this works fine on every site except on the my profile page. Can anybody help me? Here is the code i use to retrieve my data: EntitiesDataContext ctx = new EntitiesDataContext(courseSite); //Code below gets only the pages with a courses contentType. //EXCEPTION TRIGGERT ON THE FOLLOWING LINE IF IN PROFILE PAGE EntityList<Courses> course = ctx.GetList<Courses>("Pages"); //Writing the query to get the correct pages(with the course page layout only! var Query = from myCourse in course.ToList() where myCourse.CourseParticipants.Contains(myWeb.CurrentUser.LoginName) Select new{myTitle = myCourse.CourseTitle, myCompany = myCourse.Company, myPath = myCourse.Path, myName = myCourse.Name }; Thx.    

Unable to Create Object Variable for Linq Data Class

  

For some unknown reason I suddenly am unable to create an object variable for a Linq Data Class. If I create a new project and try the process again with the same database everything works as advertized.

The code I am using is Dim db As New RoggDataContext  which gives me an error on the object variable "db": Overload resolution failed because no accessibility 'NEW'  accepts this number of arguments.

I have looked inside every file in the Web Project like the web config to check the connection string, gobal, and designer.vb looking for any errors whit no JOY.  I also tried to create a new form and code behind with a button and received the same error.

This is mind blowing because as I already stated, I can create a new Web Site and the problem goes away.

Any help is appreciated!

 

Shawn




Custom Data Source Problem

  

I created a data model in BIDS, built a report from the data model in Report Builder 1.0, and saved to our report server.
When I run the report from the Report Manager it runs fine.

I am trying to modify the report for Data Driven Subscription.
When I setup a Custom Data Source and enter the same credentials that work fine in the Shared Data Source,
I get a very strange error:

An error occurred during client rendering.
An error has occurred during report processing.
Query execution failed for dataset 'dataSet'.
Incorrect syntax near '<'. The label 'xmlns' has already been declared. Label names must be unique within a query batch or stored procedure. The label 'xmlns' has already been declared. Label names must be unique within a query batch or stored procedure. The label 'xmlns' has already been declared. Label names must be unique within a query batch or stored procedure. The floating point value '6e2909' is out of the range of computer representation (8 bytes). The floating point value '6e2909' is out of the range of computer representation (8 bytes). The floating point value '22e84222201' is out of the range of computer representation (8 bytes). The floating point value '6e2909' is out of the range of computer representation (8 bytes). The label 'xsi' has already been declared. Label names must be unique within a quer

Generic list of custom class returns data in WCF service layer, but loses them in Presentation Layer

  

I'm reading this excellent article by John Papa in MSDN Data Points - http://msdn.microsoft.com/en-us/magazine/cc700340.aspx

This single article alone sheds great deal of light on EF, WCF, WPF, MVP architecture, Layered Architecture with these technologies and so much more.

I'm trying to experiment with the code that comes with the article as is.

When executing the application, the service layer returns a Generic List with three Customer objects to the presentation layer. However, in presentation layer, the Generic list arrives with zero objects in the list. In the context of this application, I provide 'd' as a search criteria and hit the search button; while stepping through, I can see it returns 3 rows from the database.

With my limited experience in WCF, I am unable to figure out why it is so. This article was written  for 3.5 SP1 Beta 1. Could something changed in the general release that is causing this?


-Perennial Newbie-

Adding data to table using linq to sql

  

Hi all, i am very new at this and are looking for some help. i have to tables, Question( Qid,question,answer,Cid ) and Category( Cid,category ), the primary keys are Qid and Cid, the Cid is a foreign key in Question, when i want to add a new question to Question i am choosing a category from a DropDownList controll, and if want to add a new category at the same time i have a TextBoks for it, i have create a Model, BLL and DAL classes, my problem is:

in the DAL class i want to add a new row to Question, but i need to check first if the object.category exsist in the table Category, if it does i want to get the Cid for it if it dosen't exist i want to create a new raw then get the Cid, this is my code: please finish my code with some explanaitions

public string add(Faq inFaq)
        {
            using (var db = new DBClassDataContext())
            {
                try
                {
                    var se = from Ca

Problem Adding Custom HTTP Module with Ajax(System.Web.Handlers.ScriptModule)

  

 Hi,

I have Created a custom Module for my application. It works fine when i am testing on a sample website.

But when i integrated the same with the original application it dosent works fine. Actully i am using Ajax control toolkit and it uses its own module for request processing.System.Web.Handlers.ScriptModule.

Hence my handlers section becomes something like this :

     <httpModules>
      <add name="ScriptModule" type="System.Web.Handlers.ScriptModule, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" />
      <add type="MyModule, MyModule,Version=1.0.0.0, Culture=neutral, PublicKeyToken=ba11cfdfb1d1111b" name="SiteMinderHttpModule" />
    </httpModules>

 Now i think my module working fine but because of it there is some hinderence caused in the Ajax request processing.I get the error sys is undefined.

I have created a class library Project and implemented the iHTTPModule interface and then registered the assembly in GAC and then accessing the assembly from there..

Is there any work around for this problem as my page is not rendering properly.

 

Please Help.

Kunal 


Problem with adding third party webparts and sharepoint webparts to the custom pages

  

Hi All,

 

 I have a problem with my custom webpart pages which are inside sitedefinition. I have a sitedefinition defined for creating sites and sitedefinition contains the master pages and .aspx pages. My pages have webpartzone defined to with the custom webparts added in it. From the browser, when I try to add third party webparts or sharepoint webparts or my custom webparts, it's failing with "Unable to add selected web part(s). The operation could not be completed because the Web Part was deleted by another user or is invalid." Does anyone have the same problem? Please help me. Why the pages are not allowing to add any other webparts to the page. Also I double checked my pages and webpartzones if I am blocking to add webparts via AllowCustomizations=false but I am not. If I create a site with the sitedefinition, isn't it possible to add webparts to the page manually? I haven't found any information about this. Any ideas please.

 

Thanks in advance,

 


Creating an Excel Spreadsheet and Adding Data to It Programmatically

  
The Interoperability services make it veryeasy to work with COM Capable Applications such as Word and Excel. Thisarticle reveals using Excel from a managed application. Excel is thespreadsheet component of Microsoft Office 2000. The majority of Excelprogrammatic functionality is exposed through Automation via the typelibrary Excel9.olb. The intention of this article is to express that amanaged application can interrelate with Excel as a COM server.

Linq - add data to database then email user the details

  

Hi all

I'm not sure how to structure the code for this but what I want to do is be able to add data to a database, and once this has completed successfully, then email the user to say the details have been added successfully to the database.

I need to:

1. Check that the relevant data has been added into the database then

2. Email the details of the relevant data when completed. 

 

Thanks in advance for your help,

Laura

 

 


The type 'System.Data.Linq.DataContext' is defined in an assembly that is not referenced. You must

  

Hi,

This is frustrating, and I don't know how to solve it.

I have a strange problem. I am adding a LinqDatasource object, and set the context:

        protected void LinqDataSource_ContextCreating(object sender, LinqDataSourceContextEventArgs e)
        {
            e.ObjectInstance = new KaruselaDataContext(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
        }


Then I get this error:
The type 'System.Data.Linq.DataContext' is defined in an assembly that is not referenced. You must add a reference to assembly 'System.Data.Linq, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'.

 

On web.config I already have this:
<add assembly="System.Data.Linq, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>

NOTE: The datacontext is in a different project (DLL proect) where I added a refernce to System.Data.Linq.

is there another way adding a refernce to a web project? or only though teh web.config?

Thanks.


MySql.Data assembly problem

  

Hi,

I added refernece MySql.Data to my project. My web.config looks like that:

<?xml version="1.0"?>
<configuration>
    <connectionStrings>
    </connectionStrings>
    <system.web>
        <compilation>
            <assemblies>
                <add assembly="MySql.Data, Version=6.1.4.0, Culture=neutral, PublicKeyToken=C5687FC88969C44D"/>
            </assemblies>
    </compilation></system.web></configuration>


But when in ServerExplorer I try "Add Connection..." I can't find "MySql Database" in the "Choose Data Source" dialog box?


What the problem can be?





Categories: 
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