I am passing my session variable from one page to another then storing the value into my database, for some reason my code isn't working?
page one:
page two:Code:Session["userID"] = "4545"; Server.Transfer("CreateProfile.aspx");
Error:Code:SQL = "INSERT INTO LoginDetails (UserID, Username, [Password])"+ "VALUES (@UserID, @Username, @Password)"; OleDbCommand WO_Cmd2 = new OleDbCommand(SQL, WO_Conn); WO_Cmd2.Parameters.Add("@UserID", Session["userID"]); WO_Cmd2.Parameters.Add("@Username", txtUsername.Text); WO_Cmd2.Parameters.Add("@Password", txtPassword.Text); WO_Conn.Open(); WO_Cmd2.ExecuteNonQuery(); WO_Conn.Close(); Server.Transfer("Login.aspx");
Anyone know what i am doing wrong?Code:System.Data.OleDb.OleDbException: Parameter @UserID has no default value.




Reply With Quote