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

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

Good way to do a Many-to-Many relationship?

Posted By:      Posted Date: August 21, 2010    Points: 0   Category :ASP.Net

I've used the automatic  Many-to-Many generation as described here: http://msdn.microsoft.com/en-us/library/dd742359.aspx

But that doesn't seem to allow a quantity to be attached to orders (in the example it would be courses). I have many customers and many products, I would like a customer to be able to order more than one product. Right now I get a grid of checkboxes. I would like instead a field where I could enter a number. 

Is this possible?

View Complete Post

More Related Resource Links

An Entity Relationship Diagram Example

An Entity Relationship Diagram conveys a lot of information with a very concise notation. The important part to keep in mind is to limit what you're reading using the following technique:

Choose two entities (e.g. Company and Employee)
Pick one that you're interested in (e.g. how a single Company relates to employees)
Read the notation on the second entity (e.g. the crow's feet with the O above it next to the Employee entity).

{ End Bracket }: What Makes A Good Software Tester?


In this month's installment, James McCaffrey talks about the qualities and skills he looks for when searching for great software testers.

Dr. James McCaffrey

MSDN Magazine December 2008

{ End Bracket }: What Makes Good Code Good?


When MSDN Magazine asked me to write a page on something I care about, I said, "You mean, like abolishing taxes, car phones, and SUVs?" Alas, they meant something to do with programming. Well! After pondering, I realized that something I care about is writing good code.

Paul DiLascia

MSDN Magazine July 2004

Command Management: Use Design Patterns to Simplify the Relationship Between Menus and Form Elements


In Windows Forms applications, similar commands, such as those in a menu and their counterparts on a toolbar, are not automatically related. They don't fire the same event or run the same handler routine. Yet code that allows the same or similar user commands to fire the same code simplifies development.This article describes the principles of command management and why it's important to have functional commands that are not exclusive to any one UI element. In order to provide an MFC-like command management infrastructure, a design pattern is developed and applied as a series of C# classes.

Michael Foster and Gilberto Araya

MSDN Magazine October 2002

Is DD as good as it looks?



I only just came across DD, and am impressed with what I see at first glance.

However, having been stung in the past by new MS technologies that look like they will save time, I am interested to know if DD is really as good as it looks. Sure, I had a working site up in minutes, and I can see how to do some configuration, but are there any issues people have found further down the road?

Basically, is it as good as it looks? Thanks for any comments.

What is a good example Dynamic Data application?


I'm giving a demonstration of Dynamic Data to a bunch of geeks in two weeks time. I'm looking for a simpe, but comprehensive data model to build the application on. I basically just want to register the model and demonstrate the application, as built (scaffolded) without any customisation, to start with, demonstrating list and detail/edit/insert views, and how table relations are handled.

I'd like to avoid one of the standards, i.e. the Customer->Order-OrderItem models, and try something that would be of interest to geeks. Maybe a Srum project tracker, an or a bug tracker, something like that.

Any suggestions please?

This was originally asked by myself on StackOverflow at: http://stackoverflow.com/questions/3536803/what-is-a-good-example-dynamic-data-application

Good html design software



I've been using visual studio for ages and find it quite cumbersome to produce snappy aspx pages.

I'm wondering if anyone recommends from a developers perspective a nice product to handle the graphical html generation?


Good news for those of you who get "Unable to make the session state request to the session state se


Dear all,

Due to the known problem of session variables getting lost if using InProc-server during frequent changes in development, I had to choose between SQL and ASP.NET State server, so I opted for the second. Initially, all fine, but after using it for a few days, I started to get this error:

 Server Error in '/cv2' Application.
Unable to make the session state request to the session state server. Please ensure that the ASP.NET State service is started and that the client and server ports are the same.  If the server is on a remote machine, please ensure that it accepts remote requests by checking the value of HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\aspnet_state\Parameters\AllowRemoteConnection.  If the server is on the local machine, and if the before mentioned registry value does not exist or is set to 0, then the state server connection string must use either 'localhost' or '' as the server name.
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.Web.HttpException: Unable to make the session state request to the session state server. Please ensure that the ASP.NET State service is started and that the clie

Download the "Good, Better, Best" White Paper for SharePoint 2010

This paper shows how two products, Microsoft Office and Microsoft SharePoint, contribute to the powerful architectural design of the Microsoft Business Productivity Infrastructure (BPI).

Is CTP4 good enough to be used in production code



Can we use CTP4 in production code?

When will it be included in .net framework 4.0?

i need a good function that will validate an email adress

i need a function that will check whether a string input is a valid email adress or not thnx a lot

Relationship between a dimension - two fact tables

I have 3 fact tables and about 10 dimensions. I want to relate both "Fact_Pop1" and "Fact_pop2" to Dim_AgeGroup. But Fact_pop1 has single age group and Fact_pop2 has no single age group (5 years age group). I spent about a day on this but I could't solve it.   Fact_Pop1 Age        Race_key            Gender_key      Geography_key              Pop_size 10           White                    M                                            CA                          10000    10           White                    F        

Is it a good practice to use DataContract attributes on business entities

Hi Folks, Currently I am developing a framwork for travel industry and finally my framework will expose its operations in the form of WCF Service. I was wondering if it is a good idea to decorate your entities and class with DataContract attributes. I know this is required if you want your classes/fields to be serialized/deseralized.  However, by Adding these attributes mean you are making your entities service specific which I believe not a good idea. Service and domain specific entities should be seperate. One solution to this would be to make DTOs and decorate them with these attributes and this make sense as core purpose of these DTOs is serialization and deserialization. What can be other options....? Please share your thoughts. Thanks, Naeem

How good is SQL Server Express?

I'm thinking of using SQL Server Express for hosting a bunch of my web applications. How secure is Express and will it handle some basic web applications? I'm guessing that total number of users per day (accessing my web applications) are probably less than a thousand. Last thing, what are the limitations of Express? It's free, correct?

How to return the results of a 1 to Many Relationship

A co-worker of mine just came back from a SQL Server Reporting Services class (we are using SQL Server 2005). In that class they were told that if they had a one to many relationship that they would have to flatten the results into one row of the resultset in order to show the 'many' portion of the relationship.  For example, my company has two tables: Jobs Notes/Memo's For each Job we can have 0 or more Notes/Memo's. According to my co-worker the Report Server must have each of the Notes/Memo's in one row of the resultset.  That we therefore have to flatten the list of Notes into Note1, Note2, Note3...etc fields.  Is this correct?  How would I handle a situation where I didn't know how many Notes there were? Thanks so much.

Any good Approval-type workflow tutorials for VS 2010?

Greetings.  I'm looking for some good tutorials (or books) on creating SharePoint 2010 Approval workflows in Visual Studio 2010.  I've spent a few hours digging through the search results on bing/google, but almost all of the examples (including content from Microsoft) show a very simple workflow in Visual Studio 2010 that doesn't contain approval steps.  I am looking for a more comprehensive tutorial on how to build a workflow that contains approval steps and evaluates the column values (i.e. evaluate a list column  if(Total Cost > 10000)) to determine branching.  InfoPath integration is a bonus but not required.  Anyone have any good links with solid tutorials?  Thanks in advance.
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