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();
}