/** * <summary> * This is the protected method GridViewDataBind to bind data with gridview * </summary> * * @method GridViewDataBind * @returns {void} */ protected void GridViewDataBind() { // connect to EF DB using (TodoContext1 db = new TodoContext1()) { string SortString = Session["SortColumn"].ToString() + " " + Session["SortDirection"].ToString(); // query the Todos Table using EF and LINQ var todoList = (from todolist in db.Todos select new { TodoID = todolist.TodoID, TodoDescription = todolist.TodoDescription, TodoNotes = todolist.TodoNotes, Completed = todolist.Completed }).ToList(); // bind the result to the TodoListGridView TodoListGridView.DataSource = todoList.AsQueryable().OrderBy(SortString).ToList(); TodoListGridView.DataBind(); TodoListGridView.Columns[0].Visible = false; } }
/// <summary> /// This method gets the student data from the DB /// </summary> private void GetTodo() { // connect to EF DB using (TodoConnection db = new TodoConnection()) { // query the Student Table using EF and LINQ var Todo = (from allTodo in db.ToDo select allTodo); // bind the result to the Students GridView TodoListGridView.DataSource = Todo.ToList(); TodoListGridView.DataBind(); } }
private void GetData() { //connect to DB using (TodoContext db = new ContosoContext()) { //querry the todoList table var Data = (from alldata in db.Students select alldata); //bind the result to the TodoList GridView TodoListGridView.DataSource = TodoList.ToList(); TodoListGridView.DataBind(); } }
/// <summary> /// This method gets the Todo data from the DB /// </summary> private void TodoData() { // connect to DB using (TodoContext db = new TodoContext()) { // query the Todo Table using EF and LINQ var ToDo = (from allTodos in db.Todoes select allTodos); // bind the result to the TodoList GridView TodoListGridView.DataSource = ToDo.ToList(); TodoListGridView.DataBind(); } }
/// <summary> /// This method gets the Todo data from the DB /// </summary> private void GetTodos() { // connect to EF DB using (TodoContext db = new TodoContext()) { // query the Todo Table using EF and LINQ var Todos = (from allTodos in db.Todos select allTodos); // bind the result to the Students GridView TodoListGridView.DataSource = Todos.ToList(); TodoListGridView.DataBind(); } }