Exemplo n.º 1
0
    protected void BindData(int amount)
    {
        var df = DB.ExecuteDataset("select top " + amount + " * from htblhistorytypes");

        dt = df.Clone();
        dt = df;


        GridViewPersonal.DataSource = dt;
        GridViewPersonal.DataBind();
    }
Exemplo n.º 2
0
    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();
        }
    }
Exemplo n.º 3
0
    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();
    }