<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.OleDb" %>
void Page_Load(object sender, EventArgs e)
{
string strConnection, strSQL;
DataSet objDataSet = new DataSet();
OleDbConnection objConnection = null;
OleDbDataAdapter objAdapter = null;
OleDbCommand objCommand = null;
OleDbCommandBuilder objBuilder = null;
// Set the connection and query details
strConnection = "Provider=Microsoft.Jet.OleDb.4.0;";
strConnection += @"Data Source="+MapPath("EmployeeDatabase.mdb");
strSQL = "SELECT ID, FirstName, LastName FROM Employee";
// Open the connection and set the command
objConnection = new OleDbConnection(strConnection);
objAdapter = new OleDbDataAdapter(strSQL, objConnection);
// Create the other commands
objBuilder = new OleDbCommandBuilder(objAdapter);
objAdapter.UpdateCommand = objBuilder.GetUpdateCommand();
objAdapter.InsertCommand = objBuilder.GetInsertCommand();
objAdapter.DeleteCommand = objBuilder.GetDeleteCommand();
// Now display the CommandText property from each command
lblSelectCommand.Text = objAdapter.SelectCommand.CommandText;
lblUpdateCommand.Text = objAdapter.UpdateCommand.CommandText;
lblInsertCommand.Text = objAdapter.InsertCommand.CommandText;
lblDeleteCommand.Text = objAdapter.DeleteCommand.CommandText;
}
Command
CommandText
SelectCommand
UpdateCommand
InsertCommand
DeleteCommand
EmployeeDatabase.zip( 10 k)