CodeVerge.Net Beta


   Explore    Item Entry   Register  Login  
Microsoft News
Asp.Net Forums
IBM Software
Borland Forums
Adobe Forums
Novell Forums

ASP.NET Web Hosting – 3 Months Free!



Zone: > NEWSGROUP > Asp.Net Forum > visual_studio.visual_studio_2005 Tags:
Item Type: NewsGroup Date Entered: 2/15/2006 10:35:38 AM Date Modified: Subscribers: 0 Subscribe Alert
Rate It:
(NR, 0)
XPoints: N/A Replies: 2 Views: 46 Favorited: 0 Favorite
Can Reply:  No Members Can Edit: No Online: Yes
3 Items, 1 Pages 1 |< << Go >> >|
lumsen
Asp.Net User
Foreign key in Visual Studio2/15/2006 10:35:38 AM

0/0

I have created a database with two tables. I have defined a foreign key in both tables and now I want to create a relationship between those two tables. The relationship should be between the primary key of my language table, language_id, and a column in my message table, language_id.

I have tried to add a new database diagram and then add the relationship between the two tables but I only get a relationship to and from the same table...

Any tips for a visual studio newbie?

 

regards,

Lumsen

asptampabay
Asp.Net User
Re: Foreign key in Visual Studio2/15/2006 1:34:50 PM

0/0

In the foreign table (Message Table) set the column "language_id" to foreign key, then assign the key to table "Language Table" column "ID"
 
<lumsen> wrote in message news:[email protected]...

I have created a database with two tables. I have defined a foreign key in both tables and now I want to create a relationship between those two tables. The relationship should be between the primary key of my language table, language_id, and a column in my message table, language_id.

I have tried to add a new database diagram and then add the relationship between the two tables but I only get a relationship to and from the same table...

Any tips for a visual studio newbie?

 

regards,

Lumsen



http://forums.asp.net/1198641/ShowPost.aspx

lumsen
Asp.Net User
Re: Foreign key in Visual Studio2/15/2006 8:56:54 PM

0/0

thanks!

lumsen
3 Items, 1 Pages 1 |< << Go >> >|


Free Download:

Books:
Pro Visual Studio 2005 Team System Application Development: Application Design Authors: Steve Shrimpton, Pages: 768, Published: 2006
Mastering Web Development with Microsoft Visual Studio 2005 Authors: John Paul Mueller, Pages: 822, Published: 2005
Beginning Visual Basic 2005 Databases Authors: Thearon Willis, Pages: 736, Published: 2006
Mastering Visual Studio .NET Authors: Ian Griffiths, Jon Flanders, Chris Sells, Pages: 397, Published: 2003
Expert F# Authors: Don Syme, Adam Granicz, Antonio Cisternino, Pages: 609, Published: 2007
Sams Teach Yourself Visual Basic .NET Web Programming in 21 Days Authors: Peter Aitken, Phil Syme, Pages: 544, Published: 2001
Mastering ASP.NET with C# Authors: A. Russell Jones, Pages: 816, Published: 2002
SQL Server 2005 Bible Authors: Paul Nielsen, Pages: 1293, Published: 2006
Programming Microsoft Visual Basic .Net for Microsoft Access Databases Authors: Rick Dobson, Pages: 500, Published: 2003
Book of Visual Studio .NET: A Guide for Developers Authors: Robert B. Dunaway, Pages: 369, Published: 2002

Web:
MySQL :: MySQL 5.0 Reference Manual :: 19.3.3.1 Editing Tables When a foreign key is changed, the MySQL Visual Studio Plugin generates two queries: the first query drops the changed keys and the second one recreates the ...
Foreign Key Relationships Dialog Box In a foreign key relationship, foreign key constraints work in conjunction with primary key or unique ... For more information, see Visual Studio Settings. ...
Re: [Firebird-net-provider] Problem witch foreign key Nov 27, 2007 ... But for the rest, I can create the foreign key without any problem. The syntax is correct. ... Microsoft(R) Visual Studio 2005. ...
Foreign key in Visual Studio - ASP.NET Forums Re: Foreign key in Visual Studio. 02-15-2006, 8:34 AM. Contact ... Re: Foreign key in Visual Studio. 02-15-2006, 3:56 PM. Contact ...
MySQL :: foreign keys with visual studio 2008 designer foreign keys with visual studio 2008 designer. Posted by: Ivan Lukic (). Date: May 21, 2008 08:44AM. Hello, I use VS2008 in connection with a mysql server. ...
MySQL :: Re: foreign keys with visual studio 2008 designer Re: foreign keys with visual studio 2008 designer. Posted by: Pleb Mail (). Date : May 28, 2008 05:23AM. Hi Ivan, Not sure if this helps, but I work with ...
CodeProject: Filter a Datagrid using a Foreign Key Combobox - VS ... Mar 20, 2006 ... The following simple Winforms tutorial reveals the fastest way to create a Foreign Key Combobox Filter for a Datagrid in Visual Studio 2005. ...
Smart Client Data : Relation Dialog: Relation Only, or with ... Feb 13, 2006 ... This includes Windows Forms, Devices and Visual Studio Tools for Office. ... A foreign key constraint only with no relation is implemented ...
MSDN Visual Studio Team System - Database Professionals Data ... Data Generation for Foreign Keys. ... Is there any way to control the data generation for a foreign key column (other than removing the FK constraints)? ...
LINQ to SQL template for Visual Studio 2008 » DamienG Checks all associations based on a foreign key are not loaded before allowing change ... The template runtime built into Visual Studio 2008 is called T4 and ...

Videos:
These are keys These are keys Key may refer to: * Key (lock), a device used to open a lock * Key (company), a Japanese visual novel studio * Keying (v...




Search This Site:










huge wait when switching to design view.

mcts self paced training kit: microsoft.net framework 2.0 application development foundation (pro-developer)

when working with vista vs2005 the flickering from administrator poup is anoying

typed data set designer

vsts developer - testing question

building .net solutions via the command line (w/out visual studio installed)

vs2005 deployment

constantly messing up my "nice" html

iis vs built-in webserver problem

order of document tabs in vs 2005

vs with custom resource provider

no asix file in vs2005 ctp-feb ?

how to compile aspx's in vs2005

gacutil question

page doesnt update

version compare help

customize vs2005 toolbox

send email to different domain

customer webeventprovider dll error (cannot load type)

server error in '/' application.

asp.net licensing issue

dataset designer wont work

find (also "find and replace") not working in visual studio

help ! can i reuse dropdownlist in edititemtemplate

style quickly flash then closes...how to resolve that?

how to

problem when deploying web application project over vs2005 web site project

urgent!!! problem with wse 3.0 when invoke a web service in wse 2.0

how to dist between 'web forms' and 'html' controls in vs 2005 ide

unable to connect to the web server.

  Privacy | Contact Us
All Times Are GMT