Using mySqlCmd As New SqlCeCommand("INSERT INTO Teams(TeamName, LeagueID) VALUES(@myValTeamName, @myValLeagueID)", mySqlConn) If mySqlConn.State = ConnectionState.Closed Then mySqlConn.Open() mySqlCmd.Parameters.AddWithValue("@myValTeamName", myTeam) << This Line mySqlCmd.Parameters.AddWithValue("@myValLeagueID", myLeagueID) For Each myTeam In myTeamList Using mySqlRdr As SqlCeDataReader = mySqlCmd.ExecuteReader() mySqlCmd.ExecuteNonQuery() End Using Next End Using mySqlConn.Close()
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)