protected void Page_Load(object sender, EventArgs e)
{
OdbcConnection myConn = new OdbcConnection(connectionString);
myConn.Open();
string mySelectQuery = "select * from Employee";
OdbcCommand command = new OdbcCommand(mySelectQuery, myConn);
if (!Page.IsPostBack)
{
ListViewEmployees.DataSource = command.ExecuteReader();
ListViewEmployees.DataBind();
}
myConn.Close();
}
private void populateListView()
{
OdbcConnection myConn = new OdbcConnection(connectionString);
myConn.Open();
string mySelectQuery = "select * from Employee";
OdbcCommand command = new OdbcCommand(mySelectQuery, myConn);
if (!Page.IsPostBack)
{
ListViewEmployees.DataSource = command.ExecuteReader();
ListViewEmployees.DataBind();
}
myConn.Close();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
NorthwindEntities context = new NorthwindEntities();
var employees = context.Employees.Select(x => new
{
Id = x.EmployeeID,
FirstName = x.FirstName,
LastName = x.LastName,
}).ToList();
GridViewEmployees.DataSource = employees;
GridViewEmployees.DataBind();
RepeaterEmployees.DataSource = context.Employees.ToList();
RepeaterEmployees.DataBind();
ListViewEmployees.DataSource = context.Employees.ToList();
ListViewEmployees.DataBind();
}
}