public void casi() { string sql = "select * from Casi ORDER BY YeuThich Desc"; con.Open(); SqlDataAdapter da = new SqlDataAdapter(sql, con); DataSet ds = new DataSet(); da.Fill(ds); NgheSi__.DataSource = ds; NgheSi__.DataBind(); con.Close(); }
public void casi() { string macasi = Request.QueryString["L"].ToString(); string sql = "select * from Casi Where MaCaSi='" + macasi + "'"; con.Open(); SqlDataAdapter da = new SqlDataAdapter(sql, con); DataSet ds = new DataSet(); da.Fill(ds); NgheSi__.DataSource = ds; NgheSi__.DataBind(); con.Close(); }