protected void BindData(int amount) { var df = DB.ExecuteDataset("select top " + amount + " * from htblhistorytypes"); dt = df.Clone(); dt = df; GridViewPersonal.DataSource = dt; GridViewPersonal.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { var df = DB.ExecuteDataset("select id as Id, Imya, Familia from rPersonal"); if (!IsPostBack) { dt = df.Clone(); dt = df; GridViewPersonal.DataSource = dt; GridViewPersonal.DataBind(); } }
protected void Page_Load(object sender, EventArgs e) { string query = "select id, Imya, Familia from rPersonal"; SqlConnection con = new SqlConnection(); con.ConnectionString = "User id=sa; Password=123; Initial Catalog=lansweeperdb; Data Source=TEST0\\SQLEXPRESS"; SqlCommand cmd = new SqlCommand(query, con); con.Open(); dt.Load(cmd.ExecuteReader()); //dt = GridViewPersonal.DataSource = dt; GridViewPersonal.DataBind(); con.Close(); }