kia9372
دوشنبه 21 تیر 1395, 15:58 عصر
درود .
این کد من برای اصافه کردن User جدید به DataBase هستش .
System.Data.SqlClient.SqlConnection con = new System.Data.SqlClient.SqlConnection();
con.ConnectionString = System.Configuration.ConfigurationManager.Connecti onStrings["shopDBConnectionString"].ConnectionString;
System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand();
cmd.CommandText = "insert into tblmember values ('" + txtemail.Text + "','" + txtname.Text + "','" + txtfamily.Text + "','" + txtpass.Text + "','','" + DropDownList1.SelectedValue + "') ";
cmd.CommandType = System.Data.CommandType.Text;
cmd.Connection = con;
con.Open();
cmd.ExecuteNonQuery();
این خظا میاد . باید چیکار کنم ؟
Violation of PRIMARY KEY constraint 'PK__tblmembe__DD7012648BA5EC8B'. Cannot insert duplicate key in object 'dbo.tblmember'. The duplicate key value is ().
The statement has been terminated.
این کد من برای اصافه کردن User جدید به DataBase هستش .
System.Data.SqlClient.SqlConnection con = new System.Data.SqlClient.SqlConnection();
con.ConnectionString = System.Configuration.ConfigurationManager.Connecti onStrings["shopDBConnectionString"].ConnectionString;
System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand();
cmd.CommandText = "insert into tblmember values ('" + txtemail.Text + "','" + txtname.Text + "','" + txtfamily.Text + "','" + txtpass.Text + "','','" + DropDownList1.SelectedValue + "') ";
cmd.CommandType = System.Data.CommandType.Text;
cmd.Connection = con;
con.Open();
cmd.ExecuteNonQuery();
این خظا میاد . باید چیکار کنم ؟
Violation of PRIMARY KEY constraint 'PK__tblmembe__DD7012648BA5EC8B'. Cannot insert duplicate key in object 'dbo.tblmember'. The duplicate key value is ().
The statement has been terminated.