aspx sidan --------------------------------------------------------- Matchfakta <%# DataBinder.Eval(Container, "DataItem.Namn") %> <%# DataBinder.Eval(Container, "DataItem.omgang") %> <%# DataBinder.Eval(Container, "DataItem.lag1") %> <%# DataBinder.Eval(Container, "DataItem.lag2") %> <%# DataBinder.Eval(Container, "DataItem.resultat_a") %> <%# DataBinder.Eval(Container, "DataItem.resultat_b") %>   Skriv inte in målskyttar för Skriv inte in målskyttar för Mål Tid Målskytt Assist 1 Assist 2 Mål Tid Målskytt Assist 1 Assist 2 Skriv inte in utvisningar Skriv inte in utvisningar för Skriv inte in utvisningar för Antalet utvisningar: Antalet utvisningar: Tid Min Orsak Spelare Tid Min Orsak Spelare --------------------------------------------- codebehind filen --------------------------------------------- Public tblrantal As TableRow Public tblrResultat As TableRow Public lblresultat As Label Public dg_serier As DataGrid Public lblError As Label Public dg_Matcher As DataGrid Public tblFakta As Table Public tblGoals As Table Public tblPenalty As Table Public tblInfo As Table Dim objconn As New OleDbConnection(ConfigurationSettings.AppSettings("connectionstring")) 'Dim objconn As New OdbcConnection(ConfigurationSettings.AppSettings("connectionstring1")) Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load If Not IsPostBack Then bindserie() fillpenalty() End If End Sub Public Sub bindserie() Dim lagID As Integer = Session("lag") If lagID = "0" Then Dim objcmd As New OleDbDataAdapter _ ("select namn, id from serier order by namn", objconn) Dim ds As DataSet = New DataSet() objcmd.Fill(ds, "serier") dg_serier.DataSource = ds.Tables("serier"). _ DefaultView If ds.Tables("serier").Rows.Count = 0 Then lblError.Text = "Ditt lag har inte skrivit in några serier än" dg_serier.Visible = False Else dg_serier.DataBind() End If Else Dim objcmd As New OleDbDataAdapter _ ("select namn, id from serier where lagID=" & lagID & " order by namn", objconn) Dim ds As DataSet = New DataSet() objcmd.Fill(ds, "serier") dg_serier.DataSource = ds.Tables("serier"). _ DefaultView If ds.Tables("serier").Rows.Count = 0 Then lblError.Text = "Ditt lag har inte skrivit in några serier än" dg_serier.Visible = False Else dg_serier.DataBind() End If End If End Sub Public Sub skapa(ByVal sender As Object, ByVal e As DataGridCommandEventArgs) dg_serier.Visible = False dg_Matcher.Visible = True Dim serie_id As Integer = dg_serier.DataKeys(CType(e.Item.ItemIndex, Integer)) Dim objcmd As New OleDbDataAdapter _ ("select l1.namn as lag1, l2.namn as lag2,m.id,m.lagID,m.omgang,m.tid,m.datum,m.lagid_a,m.lagid_b,m.uppdaterad,m.resultat_a,m.resultat_b, m.slutspel from (s_deltagande_lag as l1 inner join s_matcher as m on l1.id = m.lagid_a) inner join s_deltagande_lag l2 on m.lagid_b = l2.id where m.uppdaterad= true and (l1.namn = 'Tibro IK' or l2.namn ='Tibro IK') and m.serie_ID = " & serie_id & " order by m.omgang desc", objconn) objconn.Close() objconn.Open() Dim ds As DataSet = New DataSet() objcmd.Fill(ds, "resultat") dg_Matcher.DataSource = ds.Tables("resultat"). _ DefaultView If ds.Tables("resultat").Rows.Count = 0 Then lblError.Text = "Det finns inga matcher. Resultate måste vara uppdaterat för att skriva in matchfakta" Else dg_Matcher.DataBind() End If End Sub Public lblMatch As Label Public lblSlutResultat As Label Public plHome As Panel Public plAway As Panel Public plPenalty As Panel Public lblHome As Label Public lblAway As Label Public lblHome1 As Label Public lblAway1 As Label Public lblHomeChecked As Label Public lblAwayChecked As Label Public Sub matcher(ByVal sender As Object, ByVal e As DataGridCommandEventArgs) Dim MatchID As Integer = dg_Matcher.DataKeys(CType(e.Item.ItemIndex, Integer)) Viewstate("matchID") = MatchID goals() End Sub Public Sub goals() Dim match As String Dim resultat As String Dim homeGoals As Integer Dim home As Integer Dim away As Integer Dim Lag1 As String Dim lag2 As String Dim awayGoals As Integer Dim serie As Integer Dim plHome1 As Panel = New Panel() Dim plAway1 As Panel = New Panel() dg_serier.Visible = False dg_Matcher.Visible = False tblFakta.Visible = True Dim strSQL As String = String.Format("select l1.namn as lag1, l2.namn as lag2,m.id,m.lagID,m.omgang,m.serie_id,m.tid,m.datum,m.lagid_a,m.lagid_b,m.uppdaterad,m.resultat_a,m.resultat_b, m.slutspel from (s_deltagande_lag as l1 inner join s_matcher as m on l1.id = m.lagid_a) inner join s_deltagande_lag l2 on m.lagid_b = l2.id where m.ID = {0}", viewstate("matchID")) Dim objcmd1 As New OleDbCommand(strSQL, objconn) Dim dr As OleDbDataReader objconn.Close() objconn.Open() dr = objcmd1.ExecuteReader If dr.Read Then match = dr("lag1") & " - " & dr("lag2") resultat = dr("resultat_a") & "-" & dr("resultat_b") home = dr("lagid_a") viewstate("home") = home away = dr("lagid_b") viewstate("away") = away Lag1 = dr("lag1") lag2 = dr("lag2") serie = dr("serie_id") viewstate("serie") = serie homeGoals = CInt(dr("resultat_a")) awayGoals = CInt(dr("resultat_b")) End If objconn.Close() lblMatch.Text = match lblSlutResultat.Text = resultat lblHome.Text = Lag1 lblAway.Text = lag2 lblHome1.Text = Lag1 lblAway1.Text = lag2 Dim i As Integer For i = 1 To homeGoals Dim tblHome As Table = New Table() tblHome.Width = Unit.Pixel(250) tblHome.CellPadding = "0" tblHome.CellSpacing = "0" Dim tblrHome As TableRow = New TableRow() Dim tblc1 As TableCell = New TableCell() tblc1.Width = Unit.Pixel(50) Dim tblc2 As TableCell = New TableCell() tblc2.Width = Unit.Pixel(50) Dim tblc3 As TableCell = New TableCell() tblc3.Width = Unit.Pixel(50) Dim tblc4 As TableCell = New TableCell() tblc4.Width = Unit.Pixel(50) Dim tblc5 As TableCell = New TableCell() tblc5.Width = Unit.Pixel(50) Dim tbMal As TextBox = New TextBox() tbmal.ID = "tbHomeGoal" & i tbmal.Width = Unit.Pixel(40) Dim tbTid As TextBox = New TextBox() tbTid.ID = "tbHomeTime " & i tbTid.Width = Unit.Pixel(35) Dim ddlScorer As DropDownList = New DropDownList() ddlScorer.ID = "ddlHomescorer" & i ddlscorer.DataSource = fillddl(home, serie) ddlScorer.DataTextField = "SpelarID" Dim ddlFirstAss As DropDownList = New DropDownList() ddlfirstass.ID = "ddlHomeFirstAss" & i ddlfirstass.DataSource = fillddl(home, serie) ddlFirstass.DataTextField = "SpelarID" Dim ddlSecondAss As DropDownList = New DropDownList() ddlSecondAss.ID = "ddlHomeSecondAss" & i ddlSecondAss.DataSource = fillddl(home, serie) ddlSecondass.DataTextField = "SpelarID" tblc1.Controls.Add(tbMal) tblc2.Controls.Add(tbTid) tblc3.Controls.Add(ddlScorer) tblc4.Controls.Add(ddlFirstAss) tblc5.Controls.Add(ddlSecondAss) tblrHome.Cells.Add(tblc1) tblrHome.Cells.Add(tblc2) tblrHome.Cells.Add(tblc3) tblrHome.Cells.Add(tblc4) tblrHome.Cells.Add(tblc5) tblHome.Rows.Add(tblrHome) plHome1.Controls.Add(tblHome) Next For i = 1 To awayGoals Dim tblAway As Table = New Table() tblAway.Width = Unit.Pixel(250) tblAway.CellPadding = "0" tblAway.CellSpacing = "0" Dim tblrAway As TableRow = New TableRow() Dim tblc1 As TableCell = New TableCell() tblc1.Width = Unit.Pixel(50) Dim tblc2 As TableCell = New TableCell() tblc2.Width = Unit.Pixel(50) Dim tblc3 As TableCell = New TableCell() tblc3.Width = Unit.Pixel(50) Dim tblc4 As TableCell = New TableCell() tblc4.Width = Unit.Pixel(50) Dim tblc5 As TableCell = New TableCell() tblc5.Width = Unit.Pixel(50) Dim tbMal As TextBox = New TextBox() tbmal.ID = "tbAwayGoal" & i tbmal.Width = Unit.Pixel(40) Dim tbTid As TextBox = New TextBox() tbTid.ID = "tbAwayTime " & i tbTid.Width = Unit.Pixel(35) Dim ddlScorer As DropDownList = New DropDownList() ddlScorer.ID = "ddlHomescorer" & i ddlscorer.DataSource = fillddl(away, serie) ddlScorer.DataTextField = "SpelarID" Dim ddlFirstAss As DropDownList = New DropDownList() ddlfirstass.ID = "ddlAwayFirstAss" & i ddlfirstass.DataSource = fillddl(away, serie) ddlFirstass.DataTextField = "SpelarID" Dim ddlSecondAss As DropDownList = New DropDownList() ddlSecondAss.ID = "ddlAwaySecondAss" & i ddlSecondAss.DataSource = fillddl(away, serie) ddlSecondass.DataTextField = "SpelarID" tblc1.Controls.Add(tbMal) tblc2.Controls.Add(tbTid) tblc3.Controls.Add(ddlScorer) tblc4.Controls.Add(ddlFirstAss) tblc5.Controls.Add(ddlSecondAss) tblrAway.Cells.Add(tblc1) tblrAway.Cells.Add(tblc2) tblrAway.Cells.Add(tblc3) tblrAway.Cells.Add(tblc4) tblrAway.Cells.Add(tblc5) tblAway.Rows.Add(tblrAway) plAway1.Controls.Add(tblAway) Next plHome.Controls.Add(plHome1) plAway.Controls.Add(plAway1) DataBind() End Sub Public Function fillddl(ByVal x As Integer, ByVal y As Integer) Dim objcmd1 As New OleDbDataAdapter _ ("select SpelarID, Id from statistik where serieID=" & y & " and lagID=" & x & "", objconn) Dim ds1 As DataSet = New DataSet() objcmd1.Fill(ds1, "deltagandelag") Return ds1.Tables("deltagandelag") End Function Public ddlHomePenalty As DropDownList Public ddlAwayPenalty As DropDownList Public Sub fillpenalty() Dim i As Integer ddlHomePenalty.Items.Add(" ") For i = 1 To 40 ddlHomePenalty.Items.Add(i) Next ddlAwayPenalty.Items.Add(" ") For i = 1 To 40 ddlAwayPenalty.Items.Add(i) Next DataBind() End Sub Public Function fillPenaltys() Dim objcmd1 As New OleDbDataAdapter _ ("select Namn,Kod from Penaltys", objconn) Dim ds1 As DataSet = New DataSet() objcmd1.Fill(ds1, "Penaltys") Return ds1.Tables("Penaltys") End Function Public plHomePenalty As Panel Public plAwayPenalty As Panel Public Sub showHomePenalty(ByVal sender As Object, ByVal e As EventArgs) tblFakta.Visible = True Dim plHomepenalty1 As Panel = New Panel() Dim i As Integer viewstate("HomePenalty") = ddlHomePenalty.SelectedItem.Value For i = 1 To viewstate("HomePenalty") Dim tbl As Table = New Table() tbl.Width = Unit.Pixel(210) tbl.CellPadding = "0" tbl.CellSpacing = "0" Dim tblr As TableRow = New TableRow() Dim tblc1 As TableCell = New TableCell() tblc1.Width = Unit.Pixel(50) Dim tblc2 As TableCell = New TableCell() tblc2.Width = Unit.Pixel(60) Dim tblc3 As TableCell = New TableCell() tblc3.Width = Unit.Pixel(50) Dim tblc4 As TableCell = New TableCell() tblc4.Width = Unit.Pixel(50) Dim tbTid As TextBox = New TextBox() tbTid.ID = "tbHomePenaltyTime " & i tbTid.Width = Unit.Pixel(35) Dim tbMinuter As TextBox = New TextBox() tbMinuter.ID = "tbHomePenaltyMin " & i tbMinuter.Width = Unit.Pixel(45) Dim ddlHomeOrsak As DropDownList = New DropDownList() ddlHomeOrsak.ID = "ddlHomeOrsak" & i ddlHomeOrsak.DataSource = fillPenaltys() ddlHomeOrsak.DataTextField = "Namn" ddlHomeOrsak.DataValueField = "kod" Dim ddlHomePlayer As DropDownList = New DropDownList() ddlHomePlayer.ID = "ddlHomePlayer" & i ddlHomePlayer.DataSource = fillddl(viewstate("home"), viewstate("serie")) ddlHomePlayer.DataTextField = "SpelarID" tblc1.Controls.Add(tbTid) tblc2.Controls.Add(tbMinuter) tblc3.Controls.Add(ddlHomeOrsak) tblc4.Controls.Add(ddlHomePlayer) tblr.Cells.Add(tblc1) tblr.Cells.Add(tblc2) tblr.Cells.Add(tblc3) tblr.Cells.Add(tblc4) tbl.Rows.Add(tblr) plHomepenalty1.Controls.Add(tbl) Next plHomePenalty.Controls.Add(plHomepenalty1) End Sub Public Sub showAwayPenalty(ByVal sender As Object, ByVal e As EventArgs) tblFakta.Visible = True Dim plAwaypenalty1 As Panel = New Panel() Dim i As Integer viewstate("awayPenalty") = ddlAwayPenalty.SelectedItem.Value For i = 1 To viewstate("awayPenalty") Dim tbl As Table = New Table() tbl.Width = Unit.Pixel(210) tbl.CellPadding = "0" tbl.CellSpacing = "0" Dim tblr As TableRow = New TableRow() Dim tblc1 As TableCell = New TableCell() tblc1.Width = Unit.Pixel(50) Dim tblc2 As TableCell = New TableCell() tblc2.Width = Unit.Pixel(60) Dim tblc3 As TableCell = New TableCell() tblc3.Width = Unit.Pixel(50) Dim tblc4 As TableCell = New TableCell() tblc4.Width = Unit.Pixel(50) Dim tbAwayTid As TextBox = New TextBox() tbAwayTid.ID = "tbHomePenaltyTime " & i tbAwayTid.Width = Unit.Pixel(35) Dim tbAwayMinuter As TextBox = New TextBox() tbAwayMinuter.ID = "tbHomePenaltyMin " & i tbAwayMinuter.Width = Unit.Pixel(45) Dim ddlAwayOrsak As DropDownList = New DropDownList() ddlAwayOrsak.ID = "ddlAwayOrsak" & i ddlAwayOrsak.DataSource = fillPenaltys() ddlAwayOrsak.DataTextField = "Namn" ddlAwayOrsak.DataValueField = "kod" Dim ddlAwayPlayer As DropDownList = New DropDownList() ddlAwayPlayer.ID = "ddlAwayPlayer" & i ddlAwayPlayer.DataSource = fillddl(viewstate("Away"), viewstate("serie")) ddlAwayPlayer.DataTextField = "SpelarID" tblc1.Controls.Add(tbAwayTid) tblc2.Controls.Add(tbAwayMinuter) tblc3.Controls.Add(ddlAwayOrsak) tblc4.Controls.Add(ddlAwayPlayer) tblr.Cells.Add(tblc1) tblr.Cells.Add(tblc2) tblr.Cells.Add(tblc3) tblr.Cells.Add(tblc4) tbl.Rows.Add(tblr) plAwaypenalty1.Controls.Add(tbl) Next plAwayPenalty.Controls.Add(plAwaypenalty1) End Sub ------------------------------------