using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Configuration;
using System.Data.OleDb;
using System.Data;
public partial class datafilm : System.Web.UI.Page
{
static string str1 = ConfigurationManager.ConnectionStrings["accessconn"].ConnectionString.ToString(); //读取节点配置的字符
OleDbConnection connstr1 = new OleDbConnection(str1); //建立数据库连接对象
protected void Page_Load(object sender, EventArgs e)
{
BindData();
}
protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)//分页功能
{
GridView1.PageIndex = e.NewPageIndex;//获取当前分页的索引值
GridView1.DataBind();//重新绑定数据
}
protected void BindData() {//自定义函数绑定数据到控件
if (connstr1.State == System.Data.ConnectionState.Closed) //打开数据库
{
connstr1.Open();
}
string content = "select * from flim_info"; //编写SQL语句
OleDbDataAdapter oledba = new OleDbDataAdapter(content, connstr1);//创建数据适配器
DataSet ds = new DataSet(); //创建数据集
oledba.Fill(ds); //填充数据集
GridView1.DataSource = ds; //设置GridView1的数据源为创建的数据集ds
GridView1.DataKeyNames = new string[] { "ID" };//将数据表中的主键字段放入GridView控件的datakeynames属性中,多个主键之间用都好分隔
GridView1.DataBind(); //数据绑定
if (connstr1.State == System.Data.ConnectionState.Open) //关闭数据库
{
connstr1.Close();
}
}
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Configuration;
using System.Data.OleDb;
using System.Data;
public partial class datafilm : System.Web.UI.Page
{
static string str1 = ConfigurationManager.ConnectionStrings["accessconn"].ConnectionString.ToString(); //读取节点配置的字符
OleDbConnection connstr1 = new OleDbConnection(str1); //建立数据库连接对象
protected void Page_Load(object sender, EventArgs e)
{
BindData();
}
protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)//分页功能
{
GridView1.PageIndex = e.NewPageIndex;//获取当前分页的索引值
GridView1.DataBind();//重新绑定数据
}
protected void BindData() {//自定义函数绑定数据到控件
if (connstr1.State == System.Data.ConnectionState.Closed) //打开数据库
{
connstr1.Open();
}
string content = "select * from flim_info"; //编写SQL语句
OleDbDataAdapter oledba = new OleDbDataAdapter(content, connstr1);//创建数据适配器
DataSet ds = new DataSet(); //创建数据集
oledba.Fill(ds); //填充数据集
GridView1.DataSource = ds; //设置GridView1的数据源为创建的数据集ds
GridView1.DataKeyNames = new string[] { "ID" };//将数据表中的主键字段放入GridView控件的datakeynames属性中,多个主键之间用都好分隔
GridView1.DataBind(); //数据绑定
if (connstr1.State == System.Data.ConnectionState.Open) //关闭数据库
{
connstr1.Close();
}
}