I have four tables test1, test2, test3, test4
they dont have any primary keys.
I have a patient entry table, which has patientID as primary key. if I want to retrieve tests information about a particular test then I have to add a pid as foreign key??
do i have to add a test_ID kinda field in all four tests tables????
how to do this in sql server management studio.
I am using SQL Server2005 with asp.net. I want validation at server side to restrict duplicate entries, Here i am using two tables companies and Branches. In Branches Table i had maintain a foreign key of CompanyId. In Branches the BranchName can be duplicate but not for the Particular CompanyId
View 2 Repliesi am using sql server 2005 as backend for developing webforms with asp.net using C#.i have two tables table1 and table2.
table1 has user_id(primary key,not null),user_name. and table2 has dept_id(primary key,not null),user_id(foreign key,not null),dept_location.
Firstly i created table1 and insert data in it.. later i created table2 with foreign key relationship with table1..In the add form design of table2 for entering data and insert into table2,i placed a dropdownlist which is binded with user_id from table1...dropdownlist's.datatextfield is equal to "user_name" and datavaluefield is equal to "user_id"..i have to select user_name from dropdownlist.... what i have to do is to insert data into table2... i used the simple sql insert statement as follows..
insert into table2 values(......); but it shows error :insert statement conflicted with the foreign key.
I have 2 tables Order and Order_Detailrder_dtl_id is the primary key Order_id is the foreign key that referrence Order_Id in Order Table
View 4 Replies[Code]....
add Image to Table when foreign keyed to aspnet_UserId
I have two tables with one common field. The field is the primary key in one table, and just a plain field in another. When I delete a record in the table where the common field is the primary key, I want to automaticaly delete a record in the other table that has the same data in the common field.
What is the most effecient method of doign this..triggers?
I have a requirement to have a multiline textbox that accepts any text from any language and stores this into the database for later use. I am using Linq with ASP .NET 3.5 with a SQL Server 2005 database.
View 2 RepliesI have two tables for storing language translations - tblEN and tblES. They have the same structure which is nvcEnglish and nvcLocal - both nVarChar fields.
In nvcLocal of the Spanish table, I enter the Spanish translations of words and phrases used within my app. Problem is, when I add a bunch of new records to the English table I also have to go in and repeat the data entry into the Spanish table. I am wondering if there is a way to import the newly added records into the Spanish table using Transact SQL?The plain language query would be something like:
If the data in tblEN.nvcEnglish does not exist in tblES.nvcEnglish then insert a new row into tblES with the values from tblEN
After moving application to shared hosting I cannot add service reference to .asmx and WCF services that used to work on dedicated server.The error in adding WCF service reference is:
There was an error downloading 'address ... Service.svc'.
The server committed a protocol violation. Section=ResponseHeader Detail=CR must be followed by LF
Metadata contains a reference that cannot be resolved: 'address ... Service.svc'.
The server committed a protocol violation. Section=ResponseHeader Detail=CR must be followed by LF
The server committed a protocol violation. Section=ResponseHeader Detail=CR must be followed by LF
If the service is defined in the current solution, try building the solution and adding the service reference again.asmx web reference:There was an error downloading 'address ... .asmx'.
The server committed a protocol violation. Section=ResponseHeader Detail=CR must be followed by LF
There was an error downloading 'address ... .asmx/$metadata'.The server committed a
I have 2 table Table A, Table B.
Table A - Parent Table
ID - Uniqueidentifier not null(PK)
Table B -Child Table
ID - uniqueidentifier null(FK, TableA)
I have a stored procedure to insert data into Table B, but when I tried to insert a null value into column ID of table B, this error came up:
The INSERT statement conflicted with the FOREIGN KEY constraint "FK_tableB_tableA". The conflict occurred in database "database name", table "table A", column 'ID'.
The statement has been terminated.
The insert statement in asp.net is like so:
sqlcommand.parameter.add(New Sqlparameter("ID", Nothing))
I am guessing adding nothing to the null value column is the problem, but i don't know how to fix it... The INSERT statement conflicted with the FOREIGN KEY constraint "FK_tableB_tableA". The conflict occurred in database "database name", table "table A", column 'ID'.
I have two tables - Student and Advert.
I want to do the following;
1. Student is logged into their account (session is authenticated)
2. StudentID is primary key for that table, it is a foreign key for table Advert
3. When student is logged in, they create advert
What I want is their student Id to be input into the advert table when this new advert is created. How is this possible?
When you use ASP.NET web site (instead of web application model) and add reference to an assembly from local folder, Visual Studio, it seems, understands that this local assembly is also in GAC and so does NOT copy this assembly to bin folder (as it does with non-GAC assemblies), but simply adds new record in web.config file.
Why such a behaviour? Is it possible to force copy to bin folder (I need this since .dll is not on target environment)? I can add assembly to bin folder as file and it will work, but in this case bin folder contents will be in source control, which is not good.
How i use primary key table & foreign key table data for retriving the data with each other.I had make both table i confuse how to use it.
View 1 RepliesI'm trying to insert a new EF object containing a reference to a related table via foreign key, and cannot get the reference stored in the new object. I have two tables in a SQL Server 2008 Database:
Component Templates
PartGroups
with a Foreign Key linking them thus: ComponentTemplates:ID [0..1<->*] PartGroups:ComponentTemplateID
I have imported these tables into a .NET web application project .edmx file (using a new ADO.NET Entity Data Model), and then created a Data Service which I then reference in a Silverlight 3.0 project. The objects are available as expected in the data context called by my Silverlight app and load correctly. Now, when I try to save a reference of ComponentTemplate into a newly created PartGroup, the PartGroup object is created in the database, but the value of ComponentTemplateID in the newly created table record is NULL.
[Code]....
(Note that _ctCtrl.ComponentTemplate is a confirmed non-NULL object reference to the parent object on which PartGroup is a child)
Is there a way to add a new column to the asp.net cache change notification (AspNet_SqlCacheTablesForChangeNotification)?
I wish I could do it so that generated trigger involve the new column. The minimum PollTime is 5 seconds (500 milliseconds) but this is not enough for us.
We have many customers working on the application and some times, some of them get logged out during operations.
We found that the problems come from the cache table (cacheId column).
I simply have a lot of data in two columns in an excel spreadsheet of data that I gathered. I want to copy and paste this (manually) into a table that I have created in my ASPNETDB in my ASP.NET web application. I thought it'd be as easy as copy the column, and hit paste in the "table data" view, but it's not (it only pastes one cell).
Is there a way for me to manually copy data from excel and paste it in a table in my SQL Server?
I have inherited a very old SQL Server Database for a live site, but have been asked to add a new table for invoice recording to it. Fairly easy to do for any new record added from now on, however I run into some issues with selecting older records.I need to find a way to select from 3 tables, see if a record exists in the new table and if not insert a new record to it.My stored procedue so far is (The new table is [Invoicing]:
[Code]....
Adding data into kartlar table (RehberID,KampanyaID,BrimID) is ok. But which Kart'ID created? I need to learn which Id created after adding data (RehberID,KampanyaID,BrimID) into Kartlar?
[code]...
How can I do that? I want to get data from Kartlar which data I added?
I have a app that records some jobs and those jobs can have notes attached therefore i connected the table with a foreign key, my notes to a Job.
in the details view of the job i allow the user to view the jobs by sending the id and fulling all the notes that match the id in the index view for the notes table. in the list of notes i have a action link to create a new note, here i sent also the id of the job to the create action of the control and try to insert that intot he note JobId to make the reference. I get this error and the note is not created. the note creats from code but not via the note controller creat action.
i get this - An error occurred while updating the entries. See the inner exception for details. below is the create action in the note controller
public ActionResult Create(int id)
{
// var newnote = db.Jobs.Include("StatusNotes").Single(j => j.JobId == id);[code]...
I have tables two tables, the "book" and the "author", a book can have many authors and vice versa, so there is an intermediate table called "book_author" with two columns as foreign key for those two primary keys
book_author
book_id
author_id
I'm trying to edit the book details and also its author using the entity date model, The controller class method
[Code]....
The HTML edit form
[Code]....
I can only update the book table, but not author that the book has or the book_author, I'm new to asp.net, I can't easily find a tutorial on this issue, I think the logic is to delete the author of the book first and then add the author for that book, but I don't know exactly about that linq and C# code. Can show me? I can only update the book table, but not author that the book has or the book_author, I'm new to asp.net, I can't easily find a tutorial on this issue, I think the logic is to delete the author of the book first and then add the author for that book, but I don't know exactly about that linq and C# code.
I have set up a ASP.net MVC application which uses the default forms authentication. It uses the ASPNETDB.mdf like shown here:
I then set up another database connection which is similar to the NerdDinner.mdf file above.
I have a post that belongs to a user. It has a UserId value which needs to be a foreign key to the information in ASPNETDB.mdf. When I go to add a foreign key, I can only see information with regards to the table I made. How do I go about doing this?
how i call a image field from another table? the image field in the same table is working fine but the one on the other table is not. I have created the foreign key and made the connection... What else do i need to do to call that field? Page Load:
[Code]....
int COMPANYID = 0;
[Code]....
I have these two tables in my diagram:
the 1st:
PAR_TipiDocumento with
idTipoDocumento PK
idClasseDocumento
[...]
the 2nd:
PAR_ClassiDocumento with
idClasseDocumento PK
[...]
and a foreing key FK_PAR_TipiDocumento_PAR_ClassiDocumento from PAR_TipiDocumento.idClasseDocumentoto PAR_ClassiDocumento.idClasseDocumento.
This is my .cs code for the metadata:
[MetadataType(typeof(PAR_TipiDocumento_Metadata))]
[DisplayName("Tipi Documento")]
public partial class PAR_TipiDocumento[code]....
The problem is that in the Dynamic Data generated pages I correctly see all the display names "Tipi Documento" except for the header row of the PAR_ClassiDocumento table where I have "PAR_TipiDocumentos" (the plural generated by LINQ to SQL). The values under this column are correctly rendered as links to the PAR_TipiDocumento table with the right display name ("View Tipi Documento").
How can I change the Display Name of that "PAR_TipiDocumentos"?
I want to insert AccountID a foreign key of HappyLand Table. I want AccountID of Happyland to be the same as the AccountInfoID of AccountInfo. I created a relationship between tables, but I still can't get it to insert the AccountID. I am inserting Data SQLDatasource3.Insert()
TABLE HapplyLand TABLE AccountInfo
ID INT primary key AcountID INT primarykey
AccountID INT foreign key email varchar(50)
Age varchar(50)
LastName varchar(50)
Phone varchar(50)
<asp:SqlDataSource ID="SqlDataSource3" runat="server"
ConnectionString="<%$ ConnectionStrings:PostPropertyConnectionString1 %>"
InsertCommand="INSERT INTO [HappyLand] ([AccountID], [Age], [LastName], [Phone]) Values(@AccountID, @agetxtbox, @lastnametxtbox, @phonetextbox)">
<InsertParameters>
<asp:ControlParameter ControlID="agetxtbox" DefaultValue="" Name="agetxtbox" PropertyName="Text" />
<asp:ControlParameter ControlID="lastnametxtbox" DefaultValue="" Name="lastnametxtbox" PropertyName="Text" />
<asp:ControlParameter ControlID="phonetxtbox" DefaultValue="" Name="phonetxtbox" PropertyName="Text" />
</InsertParameters>
</asp:SqlDataSource>
ConnectionString="<%$ ConnectionStrings:PostPropertyConnectionString1 %>"
I need to populate the foreign key coloum in the table.
i have three tables
PATIENT DETAILS
ptID
firstName
lastName
address
IMPLANT DETAILS
impID
ptID
productID
productSerialNo
PRODUCT
productID
productName
I am instering data in PATIENT DETAILS and IMPLANT DETAILS table on the same page from single button click .
I have a foreign key on the table IMPLANT DETAIL (productID) which i populate through the value on the dropdownlist .
What my problem is how will i populate foreign key (ptID) in IMPLANT DETAIL table. When ptID (PATIENT DETAIL) will also be generated from the same button click at almost of the same time.