Database forign key error

Question

I have two tables A and B and i have created another table C. Now the table C have foreign keys of both table A and table B. When i enter the data in both the table A and C it is storing correctly but the table C is not auto populating with the primary keys of table A and C... All the tables are in the same database... Thanks in advance

Abhijeet Joshi · Answer

this is my code and the problem is the file path is not storing in the database instead it is storing System.Web.UI.WebControls.FileUpload

Abhijeet Joshi · Answer

using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using System.Data.SqlClient; using System.IO; using System.Data; using System.Configuration; public partial class UploadedFile : System.Web.UI.Page { SqlConnection con = new SqlConnection(Data Source=cook;Initial Catalog=MIS;Integrated Security=True); protected void Page_Load(object sender EventArgs e) { } private void StartUpLoad() { //get the file name of the posted image string fileName = FileUpload1.FileName.ToString(); //now we will set the image path string filePath = ImageStorage/ + fileName; //then save it to the folder FileUpload1.SaveAs(Server.MapPath(filePath)); //now get the size in bytes of the file //int fileSize = FileUpload1.PostedFile.ContentLength; //validate the posted file before saving if (FileUpload1.PostedFile != null && FileUpload1.FileName != ) { if (FileUpload1.PostedFile.ContentLength > 8120) { Page.ClientScript.RegisterClientScriptBlock(typeof(Page) Alert alert('File is too big') true); } else { //save the file //call the method to execute insertion of data to the database ExecuteInsert(filePath); Label.Text = File + fileName + Successfully uploaded; } } } private string GetConnectionString() { //sets the connection string from web.config return System.Configuration.ConfigurationManager.ConnectionStrings[MyDataEntries].ConnectionString; } private void ExecuteInsert(string path) { SqlConnection conn = new SqlConnection(GetConnectionString()); string sql = INSERT INTO JobPortalDatabase (FirstNameLastNameStreetAddressEmailAddressContactNumberPositionAppliedForNameoftheCompanyAddressofCompanyNameofSupervisorEnterContactNumberofSupervisorEmailAddressofSupervisorDescribeYourDutiesNameoftheCompany1AddressofCompany1NameofSupervisor1EnterContactNumberofSupervisor1EmailAddressofSupervisor1DescribeYourDuties1FilePathFileName) VALUES (' + TextBox1.Text + '  ' + TextBox2.Text + '  ' + TextBox3.Text + '  ' + TextBox4.Text + '  ' + TextBox5.Text + '  ' + TextBox6.Text + '  ' + TextBox7.Text + '  ' + TextBox8.Text + '  ' + TextBox9.Text + '  ' + TextBox10.Text + '  ' + TextBox11.Text + '  ' + TextBox12.Text + '  ' + TextBox13.Text + '  ' + TextBox14.Text + '  ' + TextBox15.Text + '  ' + TextBox16.Text + '  ' + TextBox17.Text + '  ' + TextBox18.Text + '  ' + FileUpload1+ '  ' + FileUpload1.FileName + '); try { conn.Open(); SqlCommand cmd = new SqlCommand(sql conn); //SqlParameter[] param = new SqlParameter[2]; //param[0] = new SqlParameter(@FilePath SqlDbType.VarChar 50); //param[0].Value = path; //for (int i = 0; i //{ // cmd.Parameters.Add(param[i]); //} cmd.CommandType = CommandType.Text; cmd.ExecuteNonQuery(); } catch (System.Data.SqlClient.SqlException ex) { string msg = Insert error; msg += ex.Message; throw new Exception(msg); } finally { conn.Close(); } } protected void Button2_Click(object sender EventArgs e) { StartUpLoad(); } protected void Button3_Click(object sender EventArgs e) { Response.Redirect(PersonalInformation.aspx); } }

Esakki Muthu · Answer

Are you mean by this is happaing in entity framework ?  if it's so u have to keeep primary keys for all the tables.