سلام انجام دادم
کد سی شارپ add
:
private void Bsave_Click(object sender, EventArgs e)
{
try
{
SqlConnection conn = new SqlConnection("Data Source=localhost;Initial Catalog=Test1;Integrated Security=True");
conn.Open();
SqlCommand cmd = new SqlCommand("AddIn", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@id", SqlDbType.Int);
cmd.Parameters.AddWithValue("@city", SqlDbType.NVarChar).Value = TextCity.Text.Trim();
cmd.Parameters.AddWithValue("@age", SqlDbType.Float).Value = TextAge.Text.Trim();
cmd.ExecuteNonQuery();
MessageBox.Show("عملیات با موفقیت انجام شد", "پیام",MessageBoxButtons.OK,MessageBoxIcon.Inf ormation);
conn.Close();
this.Close();
}
catch (Exception error)
{
MessageBox.Show(error.Message);
}
sp
ALTER PROCEDURE [dbo].[AddIn]
@id int,
@city nvarchar(50),
@age float
AS
SET IDENTITY_INSERT Info ON;
INSERT INTO Info (id,city,age)
VALUES (@id,@city,@age)
SET IDENTITY_INSERT Info OFF;
RETURN
اخطار:
Additional information: Violation of PRIMARY KEY constraint 'PK_Info'. Cannot insert duplicate key in object 'dbo.Info'.
The statement has been terminated.
من فقط مشکل فقط id جدول که به صورت خودکار مقدار دهی میشه