protected void getGameData()
{
using (GameContext db = new GameContext())
{
var gameData = (from eachGame in db.GameTables select eachGame);
GameGridView.DataSource = gameData.ToList();
GameGridView.DataBind();
}
}
protected void ConnectionToDB()
{
using (VJKMConnection db = new VJKMConnection())
{
var gameEdit = (from allgames in db.Games
select allgames);
// bind the result to the GridView
GameGridView.DataSource = gameEdit.AsQueryable().ToList();
GameGridView.DataBind();
}
}
private void getGame()
{
List <SqlParameter> spParams = new List <SqlParameter>();
spParams.Add(new SqlParameter("@gameName", searchText.Value));
spParams.Add(new SqlParameter("@stdName", searchText.Value));
DataSet ds = new DataSet();
ds = DBHelper.ExecuteBySPName("GameReportSearch", spParams.ToArray());
GameGridView.DataSource = ds.Tables[0];
GameGridView.DataBind();
}
/**
* <summary>
* This method gets the games data from the DB
* </summary>
*
* @method Getgame1
* @returns {void}
*/
protected void GetGames()
{
// connect to EF
using (ProjectConnection db = new ProjectConnection())
{
// query the game Table using EF and LINQ
var Games = (from allgames in db.MAIN_GAME
select allgames);
// bind the result to the GridView
GameGridView.DataSource = Games.AsQueryable().ToList();
GameGridView.DataBind();
}
}
// This Method gets the games data from the database
// @method Getguesttrack
// @return (void)
protected void GetGame()
{
//connect to the EF
using (DefaultConnection db = new DefaultConnection())
{
//Query the game results
var Games = (from allGames in db.Game
select allGames);
GameGridView.DataSource = Games.ToList();
GameGridView.DataBind();
}
}
protected void GetGame()
{
string sortString = Session["SortColumn"].ToString() + " " + Session["SortDirection"].ToString();
// connect to EF
using (GameDefaultConnection db = new GameDefaultConnection())
{
// query the Students Table using EF and LINQ
var g1 = (from allGames in db.Games
select allGames);
// bind the result to the GridView
GameGridView.DataSource = g1.AsQueryable().OrderBy(sortString).ToList();
GameGridView.DataBind();
}
}
