Hi again Experts,
This issue is really, really driving me nuts.
Please take a look at code below:
s = "INSERT INTO tblTrainings (CourseId, tblLocations.LocationId, dateId,AvailableSeats,username) VALUES (@CosID, @LocID, @dat, @Available_Seating, @Username)"
Dim cmd = New SqlCommand(s, conn)
cmd.Parameters.AddWithValue("@cosID", Request.QueryString("cosId"))
cmd.Parameters.AddWithValue("@locID", Request.QueryString("locid"))
cmd.Parameters.AddWithValue("@dat", Request.QueryString("iddate"))
cmd.Parameters.AddWithValue("@Available_Seating", 45 - 1)
cmd.Parameters.AddWithValue("@UserName", username)
conn.Open()
cmd.ExecuteNonQuery()
conn.Close()
We have 2 fieldnames, one field called C ...
Go to the complete details ...