protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
ReadRecords();
}
private void ReadRecords()
{
OleDbConnection conn = null;
OleDbDataReader reader = null;
try
{
conn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" + Server.MapPath("db/Database1.mdb"));
conn.Open();
OleDbCommand cmd =
new OleDbCommand("Select * FROM Table1", conn);
reader = cmd.ExecuteReader();
DataGrid1.DataSource = reader;
DataGrid1.DataBind();
}
finally
{
if (reader != null) reader.Close();
if (conn != null) conn.Close();
}
}
protected void DataGrid1_CancelCommand(object source, DataGridCommandEventArgs e)
{
DataGrid1.EditItemIndex = -1;
ReadRecords();
}
protected void DataGrid1_EditCommand(object source, DataGridCommandEventArgs e)
{
DataGrid1.EditItemIndex = e.Item.ItemIndex;
ReadRecords();
}
protected void DataGrid1_UpdateCommand(object source, DataGridCommandEventArgs e)
{
int ID = (int)DataGrid1.DataKeys[(int)e.Item.ItemIndex];
string name = ((TextBox)e.Item.Cells[1].Controls[0]).Text;
string type = ((TextBox)e.Item.Cells[2].Controls[0]).Text;
string sql =
"UPDATE Table1 SET PetName=\"" + name +
"\", PetType=\"" + type + "\"" +
" WHERE ID=" + ID;
ExecuteNonQuery(sql);
DataGrid1.EditItemIndex = -1;
ReadRecords();
}
private void ExecuteNonQuery(string sql)
{
OleDbConnection conn = null;
try
{
conn = new OleDbConnection(
"Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" + Server.MapPath("db/Database1.mdb"));
conn.Open();
OleDbCommand cmd =
new OleDbCommand(sql, conn);
cmd.ExecuteNonQuery();
}
finally
{
if (conn != null) conn.Close();
}
}
protected void Button1_Click(object sender, EventArgs e)
{
string sql = "INSERT INTO Table1 (PetName, PetType)"
+ " VALUES (\"new\", \"new\")";
ExecuteNonQuery(sql);
ReadRecords();
}
protected void DataGrid1_DeleteCommand(object source, DataGridCommandEventArgs e)
{
int ID = (int)DataGrid1.DataKeys[(int)e.Item.ItemIndex];
string sql = "DELETE FROM Table1 WHERE ID=" + ID;
ExecuteNonQuery(sql);
ReadRecords();
}