Using System.Configuration;
Using System.Data.OleDb;
Using System.Data;
public partial class Datafilm:System.Web.UI.Page
{
protected void Page_Load (object sender, EventArgs e)
{
String str1 = configurationmanager.connectionstrings["Accessconn"]. Connectionstring.tostring (); Read the character of a node configuration
OleDbConnection connstr1 = new OleDbConnection (STR1); Establishing a database Connection object
if (connstr1. state = = System.Data.ConnectionState.Closed)//Open Database
{
Connstr1. Open ();
}
String content = "SELECT * from Flim_info"; Writing SQL statements
OleDbDataAdapter oledba = new OleDbDataAdapter (CONTENT,CONNSTR1);//Build OleDbDataAdapter Object
DataSet ds = new DataSet (); Set up a DataSet object
Oledba. Fill (DS); Populating data sets
Gridview1.datasource = ds; Set up a data source for GridView1
Gridview1.databind (); Data binding
if (connstr1. state = = System.Data.ConnectionState.Open)//Close Database
{
Connstr1. Close ();
}
}
}
ASP through code binding GridView control