protected void Bind() { int gameid = Convert.ToInt32(Request.QueryString["gameid"]); int playerid = Convert.ToInt32(Request.QueryString["playerid"]); DataTable dt = gdiObj.getInfobyIds(gameid, playerid); DataTable gamedt = giObj.getInfobyId(gameid); DataTable playerdt = piObj.getInfobyId(playerid); txttime.Text = gamedt.Rows[0][1].ToString(); ddlhost.SelectedValue = gamedt.Rows[0][2].ToString(); ddlplayer.SelectedValue = playerdt.Rows[0][1].ToString(); playingtime.Text = dt.Rows[0][2].ToString(); score.Text = dt.Rows[0][3].ToString(); rebound.Text = dt.Rows[0][4].ToString(); assist.Text = dt.Rows[0][5].ToString(); cap.Text = dt.Rows[0][6].ToString(); steal.Text = dt.Rows[0][7].ToString(); hit.Text = dt.Rows[0][8].ToString(); shot.Text = dt.Rows[0][9].ToString(); thit.Text = dt.Rows[0][10].ToString(); tshot.Text = dt.Rows[0][11].ToString(); freehit.Text = dt.Rows[0][12].ToString(); freeshot.Text = dt.Rows[0][13].ToString(); foul.Text = dt.Rows[0][14].ToString(); }
protected void Bind() { int id = Convert.ToInt32(Request.QueryString["id"]); DataTable dt = giObj.getInfobyId(id); txttime.Text = dt.Rows[0][1].ToString(); ddlhost.SelectedValue = dt.Rows[0][2].ToString(); ddlvisitor.SelectedValue = dt.Rows[0][3].ToString(); ddltype.SelectedValue = dt.Rows[0][4].ToString(); }
protected void Page_Load(object sender, EventArgs e) { string id = Request.QueryString["id"]; SqlDataSource1.SelectCommand = "select * from gamedata join player on playerid = id where gameid = " + id; GridView1.DataBind(); DataTable gamedt = giObj.getInfobyId(Convert.ToInt32(id)); DataTable dt = gdiObj.getScore(gamedt.Rows[0][1].ToString(), gamedt.Rows[0][2].ToString()); Label1.Text = dt.Rows[0][3].ToString(); Label2.Text = dt.Rows[0][4].ToString(); Label3.Text = dt.Rows[0][5].ToString(); Label4.Text = dt.Rows[0][6].ToString(); }