protected void GridWeb1_CustomCommand(object sender, string command)
{
switch (command)
{
case "UPDATE":
// Only available for local users.
if (Request.UserHostAddress == "127.0.0.1")
{
// Create demo database object
ExampleDatabase db = new ExampleDatabase();
// Create path to database file
string path = (this.Master as Site).GetDataDir();
// Create connection string
db.oleDbConnection1.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + path + "\\Miscellaneous\\Database\\demos.mdb";
try
{
// Update database
db.oleDbDataAdapter1.Update((DataSet)GridWeb1.WebWorksheets[0].DataSource);
}
finally
{
// Close connection
db.oleDbConnection1.Close();
}
}
else
{
// Set error message
ShowErrorMsg("Can't update from remote machine!");
}
break;
case "ADD":
if (GridWeb1.ActiveSheetIndex == 0)
{
// Create new row
GridWeb1.WebWorksheets.ActiveSheet.CreateNewBindRow();
// Scrolls the panel to the bottom.
GridWeb1.ViewPanelScrollTop = "1200";
}
break;
case "DELETE":
if (GridWeb1.ActiveSheetIndex == 0)
{
if (GridWeb1.ActiveCell != null)
// Delete active row
GridWeb1.WebWorksheets.ActiveSheet.DeleteBindRow(GridWeb1.ActiveCell.Row);
}
break;
}
}