private void DocDuLieu()
{
SqlConnection sqlcon = new SqlConnection();
SqlCommand sqlcom2 = new SqlCommand();
try
{
sqlcon.ConnectionString = conString;
sqlcon.Open();
if (sqlcon.State == System.Data.ConnectionState.Open)
{
sqlcom2.Connection = sqlcon;
sqlcom2.CommandType = System.Data.CommandType.Text;
sqlcom2.CommandText = "SELECT Player.ID AS 'ID CẦU THỦ',Player.Ten AS 'TÊN CẦU THỦ', Player.NamSinh AS 'NĂM SINH', Player.Tuoi AS 'TUỔI', Player.GiaTri AS 'GIÁ TRỊ', Player.QueQuan 'QUÊ QUÁN', Player.ID_VT 'ID VỊ TRÍ', VItri.VItri AS 'VỊ TRÍ'"
+ "FROM Player INNER JOIN VItri ON Player.ID_VT = VItri.ID_VT ";
DataTable dt = new DataTable("DS");
SqlDataAdapter da = new SqlDataAdapter(sqlcom2);
da.Fill(dt);
Gv2.DataSource = dt;
Gv2.DataBind();
}
}
catch (Exception exc)
{
}
finally
{
if (sqlcon.State == System.Data.ConnectionState.Open)
{
sqlcon.Close();
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
string ma = Request.QueryString["ma"].ToString();
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["dl"].ToString());
SqlDataAdapter da = new SqlDataAdapter("select * from sanpham where masp='" + ma + "'", con);
DataSet ds = new DataSet();
da.Fill(ds, "sanpham");
DataColumn[] khoachinh = new DataColumn[1];
khoachinh[0] = ds.Tables["sanpham"].Columns[0];
ds.Tables["sanpham"].PrimaryKey = khoachinh;
Gv2.DataSource = ds.Tables["sanpham"];
Gv2.DataBind();
}
public void Set()
{
Gv2.SetActive(true);//设置按钮弹窗
}
public void BackGame()
{
Gv1.SetActive(false);
Gv2.SetActive(false);//返回则关闭弹窗
}
