Using System;
Using System.Configuration;
Using System.Data;
Using System.Linq;
Using System.Web;
Using System.Web.Security;
Using System.Web.UI;
Using System.Web.UI.HtmlControls;
Using System.Web.UI.WebControls;
Using System.Web.UI.WebControls.WebParts;
Using System.Xml.Linq;
Using System.Data.OleDb;
public partial class _default:system.web.ui.page
{
protected void Page_Load (object sender, EventArgs e)
{
if (! IsPostBack)
{
Gridview1.datasource = bind ();
Gridview1.databind ();
Gridview1.datasource = Bindtable ();
Gridview1.databind ();
}
}
Private DataSet bind ()
{
OleDbConnection conn = new OleDbConnection ("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|datadirectory|fazhi.mdb") ;
OleDbCommand comm = new OleDbCommand ("SELECT * from PA", Conn);
OleDbDataAdapter database = new OleDbDataAdapter (comm);
DataSet ds = new DataSet ();
Conn. Open ();
Database. Fill (DS);
return DS;
}
Private DataTable bindtable ()
{
OleDbConnection conn = new OleDbConnection ("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|datadirectory|fazhi.mdb") ;
Conn. Open ();
OleDbCommand cmd = new OleDbCommand ("SELECT * from PA ORDER BY id DESC", conn);
OleDbDataReader SDR = cmd. ExecuteReader (commandbehavior.closeconnection);
DataTable dt = new DataTable ();
Dt. Load (SDR);
return DT;
Conn. Close ();
}
protected void Button1_Click (object sender, EventArgs e)
{
OleDbConnection conn = new OleDbConnection ("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|datadirectory|fazhi.mdb") ;
Conn. Open ();
OleDbCommand cmd = new OleDbCommand ("INSERT into PA (XXMC) VALUES ('" + TextBox1.Text + "')", conn);
Cmd. ExecuteNonQuery ();
OleDbCommand comm = new OleDbCommand ("SELECT * from PA ORDER BY id DESC", conn);
OleDbDataReader SDR = Comm. ExecuteReader (commandbehavior.closeconnection);
DataTable dt = new DataTable ();
Dt. Load (SDR);
Gridview1.datasource = DT;
Gridview1.databind ();
Conn. Close ();
}
}
Access calls Contact