Help on adding new rows

[justenoughtobedangerous]

Need help! I'm sure I need something after .Add(newRow) I get an error that the row already exists.

Public Class frmTeamParings
    Private Sub addPairings()
        Try
            Dim newRow As PairingsLeagueDataSet.tblParingsRow = Me.PairingsLeagueDataSet.tblParings.NewRow()
            Dim k As Integer = 1
            For i As Integer = 1 To 5
                For j As Integer = 1 To 10
                    k = j + 1
                    newRow.Week = i
                    newRow.TeamA = j
                    newRow.TeamB = k
                    Me.PairingsLeagueDataSet.tblParings.Rows.Add(newRow)
                   Next
            Next
        Catch ex As Exception
            MsgBox(ex.ToString)
        End Try
    End Sub

Thanks,

 

[MattP]

Please use [ C O D E ] blocks in the future for readability.

	Private Sub AddPairings()
		Try
			Dim newRow As PairingsLeagueDataSet.tblParingsRow
			Dim k As Integer = 1

			For i As Integer = 1 To 5
				For j As Integer = 1 To 10
					newRow = Me.PairingsLeagueDataSet.tblParings.NewRow
					k = j + 1
					newRow.Week = i
					newRow.TeamA = j
					newRow.Teamb = k
					Me.PairingsLeagueDataSet.tblParings.Rows.Add(newRow)
				Next
			Next
		Catch ex As Exception
			MessageBox.Show(ex.ToString())
		End Try
	End Sub

 

[justenoughtobedangerous]

Sweet!

Thanks Matt very much! Worked great!

(Code Blocks) is that in the format? I was ok when I pasted it, then it align left after?

 

[MattP]

Try this link to learn about the bbcode this board uses: Visual Basic .NET Forums - BB Code List

 

[justenoughtobedangerous]

Cool

Thanks again

 

[JohnH]

Click the "post reply" button and you get the good post editor instead of using the very limited "quick reply" editor. The good post editor has quick buttons for all those BB codes, and it has preview also. I even posted screenshot here: http://www.vbdotnetforums.com/forum-feedback/14540-how-do-i-add-my-code-here.html#post43749