SQL Select, Insert, and Update using Windows Form

In your insert query, you have no RegistrationID and in parameters, you have provided RegistrationID. This you have to remove. Another point is Student ID is long so change SQLDbType for it to BigInt as shown below.

 

the class

  

 

Change the followings in Point-8

INSERT INTO ClubMembers VALUES(@ID, @RegistrationID,

@StudentID, @FirstName, @MiddleName, @LastName, @Age, @Gender, @Program)

sqlCommand.Parameters.Add(@StudentID, SqlDbType.BigInt).Value = StudentID;

HI

do as shown

 

 Change highlighted Varchar into BigInt