Click here to Skip to main content
15,899,937 members
Home / Discussions / ASP.NET
   

ASP.NET

 
AnswerRe: Unable to Open (ASP.NET C#) Web Project Pin
saini arun18-Mar-10 21:39
saini arun18-Mar-10 21:39 
GeneralRe: Unable to Open (ASP.NET C#) Web Project Pin
Gaurav Dudeja India18-Mar-10 22:50
Gaurav Dudeja India18-Mar-10 22:50 
AnswerRe: Unable to Open (ASP.NET C#) Web Project Pin
Dinesh Mani19-Mar-10 0:27
Dinesh Mani19-Mar-10 0:27 
QuestionRegEx to allow Phone Numbers with #-###-###-#### or ###-###-#### format only Pin
Vipul Mehta18-Mar-10 20:39
Vipul Mehta18-Mar-10 20:39 
AnswerRe: RegEx to allow Phone Numbers with #-###-###-#### or ###-###-#### format only Pin
Dinesh Mani18-Mar-10 20:59
Dinesh Mani18-Mar-10 20:59 
GeneralRe: RegEx to allow Phone Numbers with #-###-###-#### or ###-###-#### format only Pin
Vipul Mehta18-Mar-10 21:16
Vipul Mehta18-Mar-10 21:16 
AnswerRe: RegEx to allow Phone Numbers with #-###-###-#### or ###-###-#### format only Pin
Arindam Tewary18-Mar-10 23:24
professionalArindam Tewary18-Mar-10 23:24 
QuestionTableAdapterManager.UpdateAll shows foreign key error Pin
Satheesh Vijayan18-Mar-10 17:44
Satheesh Vijayan18-Mar-10 17:44 
Hi,

I am trying to use the TableApapterManager.UpdateAll to insert values to master and child table. I had set the relation to cascade for update in the dataset relation and the HierarchicalUpdate to true. But still when I run TableApapterManager.UpdateAll(dataset), I get a foriegn key violation error. Following is the code I used:

m_adpMgr = new TableAdapterManager();
m_dsMembers = new ArchDemo.DAL.Datasets.dsMembers();
m_adpMgr.MemPhonesTableAdapter = new MemPhonesTableAdapter();

m_adpMgr.MembersTableAdapter = new MembersTableAdapter();

m_adpMgr.MembersTableAdapter.Fill(m_dsMembers.Members);
m_adpMgr.MemPhonesTableAdapter.Fill(m_dsMembers.MemPhones);

int ID;
DAL.Datasets.dsMembers.MembersRow rwMem = m_dsMembers.Members.NewMembersRow();

//Set values to parent table field
rwMem.u_name = mem.Name;
m_dsMembers.Members.AddMembersRow(rwMem);

DAL.Datasets.dsMembers.MemPhonesRow rwmemphn = null;

//Set values to child table field
rwmemphn = m_dsMembers.MemPhones.NewMemPhonesRow();
//Reference key value set here
rwmemphn.u_memberid = ID;
rwmemphn.u_phn = "test";

m_dsMembers.MemPhones.AddMemPhonesRow(rwmemphn);

m_adpMgr.UpdateAll(m_dsMembers);
return ID;

The error I get is "The INSERT statement conflicted with the FOREIGN KEY constraint "FK_MemPhones_Members". The conflict occurred in database "Family", table "dbo.Members", column 'i_memeberid'.
The statement has been terminated."

Can I get some advice on this.

Thanks and Regards,

Satheesh
QuestionWhy doesn't this string replacement work? (XmlDoc.InnerXml.Replace) Pin
David Mujica18-Mar-10 10:30
David Mujica18-Mar-10 10:30 
AnswerRe: Why doesn't this string replacement work? (XmlDoc.InnerXml.Replace) Pin
Arindam Tewary18-Mar-10 23:44
professionalArindam Tewary18-Mar-10 23:44 
GeneralWorking now Pin
David Mujica19-Mar-10 4:22
David Mujica19-Mar-10 4:22 
GeneralRe: Working now Pin
Arindam Tewary19-Mar-10 8:38
professionalArindam Tewary19-Mar-10 8:38 
QuestionWeb Deployment Project: Missing Reference? Pin
Diving Flo18-Mar-10 10:14
Diving Flo18-Mar-10 10:14 
AnswerRe: Web Deployment Project: Missing Reference? Pin
Diving Flo22-Mar-10 4:17
Diving Flo22-Mar-10 4:17 
QuestionAjax Validation with ASP.NET Pin
Morgs Morgan18-Mar-10 3:15
Morgs Morgan18-Mar-10 3:15 
AnswerRe: Ajax Validation with ASP.NET Pin
Not Active18-Mar-10 3:21
mentorNot Active18-Mar-10 3:21 
GeneralRe: Ajax Validation with ASP.NET Pin
Morgs Morgan18-Mar-10 3:47
Morgs Morgan18-Mar-10 3:47 
GeneralRe: Ajax Validation with ASP.NET Pin
Not Active18-Mar-10 3:57
mentorNot Active18-Mar-10 3:57 
AnswerRe: Ajax Validation with ASP.NET Pin
mrMercury18-Mar-10 4:20
mrMercury18-Mar-10 4:20 
QuestionVertical CSS Menu in ASP.NET Pin
MWRivera18-Mar-10 3:12
MWRivera18-Mar-10 3:12 
AnswerRepost Pin
Not Active18-Mar-10 3:19
mentorNot Active18-Mar-10 3:19 
GeneralRe: Repost Pin
MWRivera18-Mar-10 3:22
MWRivera18-Mar-10 3:22 
GeneralRe: Repost Pin
Not Active18-Mar-10 3:27
mentorNot Active18-Mar-10 3:27 
GeneralRe: Repost Pin
chengclq18-Mar-10 17:36
chengclq18-Mar-10 17:36 
QuestionHow to store DateTime in database am using following code. Pin
shiva.kore18-Mar-10 2:53
shiva.kore18-Mar-10 2:53 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.