السلام عليكم ورحمته الله وبركاته
هذا الكود للتعديل ولكن يوجد فيه خطا الكود كالاتى :-
For x As Integer = 0 To DataGridView1.Rows.Count - 2
Dim id As Integer = DataGridView1.Rows.Item(x).Cells(0).Value
Dim name As String = DataGridView1.Rows.Item(x).Cells(1).Value
cmd.Parameters.Clear()
cmd.CommandText = "updatedes"
cmd.Parameters.Add("@name", SqlDbType.VarChar).Value = name
cmd.Parameters.Add("@id", SqlDbType.Int).Value = id
cmd.ExecuteNonQuery()
Next
MessageBox.Show("تم التعديل ")
Catch ex As Exceptionيظهر الخطا التالى
incorrect syntax near updatedes
والstored procedure كالاتى
CREATE PROCEDURE updatedes
-- Add the parameters for the stored procedure here
@id int,
@name varchar(50)
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
-- Insert statements for procedure here
update des set name=@name where id=@id
END
وشكرااااااااااا