shima2006
جمعه 23 مرداد 1388, 13:04 عصر
سلام
من در سی شارپ کد زیر رو نوشتم
private void button1_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection("Data Source=.;Initial Catalog=pjt;Integrated Security=True");
con.Open();
SqlCommand com = new SqlCommand();
com.Connection = con;
com.CommandText="SELECT owner.idowner,owner.name,owner.family,automobile.i dam,automobile.plaque ";
com.CommandText+="FROM automobile INNER JOIN owner ON automobile.idowner=owner.idowner ";
com.CommandText+="WHERE name=N'" + txtname.Text + "AND family=N" + txtfamily.Text + "AND plaque=" +txtplaque +"'";
SqlDataReader dr = com.ExecuteReader();
if (dr.Read())
{
idam = dr.GetInt32(1);
con.Close();
}
SqlConnection con1 = new SqlConnection("Data Source=.;Initial Catalog=pjt;Integrated Security=True");
con1.Open();
SqlCommand com1 = new SqlCommand();
com1.Connection = con1;
com1.CommandText = "INSERT INTO functions(idam,rejectable,accepting,credittime,dat e)values('" + idam + "','" + rbaccept.Checked + "','" + rbreject.Checked + "',N'" + credittime.Text + "','" + lbldate.Text + "')";
com1.ExecuteNonQuery();
con1.Close();
}
و با این پیغام خطا مواجه میشم
{"The INSERT statement conflicted with the FOREIGN KEY constraint \"FK_function_automobile\". The conflict occurred in database \"pjt\", table \"dbo.automobile\", column 'idam'.\r\nThe statement has been terminated."}
از همه بدتر این که در Diagram_pjt اکثر ارتباط هایی که بین جدوالم درست کرده بودم از بین رفت...
من در سی شارپ کد زیر رو نوشتم
private void button1_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection("Data Source=.;Initial Catalog=pjt;Integrated Security=True");
con.Open();
SqlCommand com = new SqlCommand();
com.Connection = con;
com.CommandText="SELECT owner.idowner,owner.name,owner.family,automobile.i dam,automobile.plaque ";
com.CommandText+="FROM automobile INNER JOIN owner ON automobile.idowner=owner.idowner ";
com.CommandText+="WHERE name=N'" + txtname.Text + "AND family=N" + txtfamily.Text + "AND plaque=" +txtplaque +"'";
SqlDataReader dr = com.ExecuteReader();
if (dr.Read())
{
idam = dr.GetInt32(1);
con.Close();
}
SqlConnection con1 = new SqlConnection("Data Source=.;Initial Catalog=pjt;Integrated Security=True");
con1.Open();
SqlCommand com1 = new SqlCommand();
com1.Connection = con1;
com1.CommandText = "INSERT INTO functions(idam,rejectable,accepting,credittime,dat e)values('" + idam + "','" + rbaccept.Checked + "','" + rbreject.Checked + "',N'" + credittime.Text + "','" + lbldate.Text + "')";
com1.ExecuteNonQuery();
con1.Close();
}
و با این پیغام خطا مواجه میشم
{"The INSERT statement conflicted with the FOREIGN KEY constraint \"FK_function_automobile\". The conflict occurred in database \"pjt\", table \"dbo.automobile\", column 'idam'.\r\nThe statement has been terminated."}
از همه بدتر این که در Diagram_pjt اکثر ارتباط هایی که بین جدوالم درست کرده بودم از بین رفت...