public static void default_SaveData(HttpRequest request, AjaxSaveDataHandlerEventArgs args)
{
string tableName = "people";
string primaryKey = "ContactID";
SqlConnection dbConn = new SqlConnection(localConnectionString);
try
{
dbConn.Open();
// Each element of 'args' is an XML Node representing a changed row in the Grid.
for (int p = 0; p < args.Count; p++)
{
// We cast the xml node as an IRow.
IRow r = args[p];
// Depending on the type of update action specified for the row (can be one of Insert, Update or Delete),
// perform the right command in our database.
UpdateAction action = r.UpdateAction;
switch (action)
{
case UpdateAction.Delete:
SqlCommand cmdDelete = dbConn.CreateCommand();
cmdDelete.CommandText = "DELETE FROM " + tableName + " WHERE " + primaryKey + " = @" + primaryKey;
cmdDelete.Parameters.AddWithValue("@" + primaryKey, r[primaryKey]);
cmdDelete.ExecuteNonQuery();
break;
case UpdateAction.Update:
SqlCommand cmdUpdate = dbConn.CreateCommand();
cmdUpdate.CommandText = "UPDATE " + tableName + " SET ContactName = @ContactName, ";
cmdUpdate.CommandText += "ContactEmail = @ContactEmail, JobTitle = @JobTitle, ";
cmdUpdate.CommandText += "CompanyName = @CompanyName, Gender = @Gender, ";
cmdUpdate.CommandText += "Birthday = @Birthday ";
cmdUpdate.CommandText += "WHERE " + primaryKey + " = @" + primaryKey;
cmdUpdate.Parameters.AddWithValue("@" + primaryKey, r[primaryKey]);
cmdUpdate.Parameters.AddWithValue("@ContactName", r["ContactName"]);
cmdUpdate.Parameters.AddWithValue("@ContactEmail", r["ContactEmail"]);
cmdUpdate.Parameters.AddWithValue("@JobTitle", r["JobTitle"]);
cmdUpdate.Parameters.AddWithValue("@CompanyName", r["CompanyName"]);
cmdUpdate.Parameters.AddWithValue("@Birthday", r["Birthday"]);
cmdUpdate.Parameters.Add("@Gender", OleDbType.Boolean).Value = Convert.ToBoolean(r["Gender"]);
cmdUpdate.ExecuteNonQuery();
break;
case UpdateAction.Insert:
SqlCommand cmdInsert = dbConn.CreateCommand();
cmdInsert.CommandText = "INSERT INTO " + tableName + " (ContactName, ContactEmail, JobTitle, CompanyName, Gender, Birthday) VALUES (@ContactName, @ContactEmail, @JobTitle, @CompanyName, @Gender, @Birthday)";
cmdInsert.Parameters.AddWithValue("@ContactName", r["ContactName"]);
cmdInsert.Parameters.AddWithValue("@ContactEmail", r["ContactEmail"]);
cmdInsert.Parameters.AddWithValue("@JobTitle", r["JobTitle"]);
cmdInsert.Parameters.AddWithValue("@CompanyName", r["CompanyName"]);
cmdInsert.Parameters.AddWithValue("@Birthday", r["Birthday"]);
cmdInsert.Parameters.Add("@Gender", OleDbType.Boolean).Value = Convert.ToBoolean(r["Gender"]);
cmdInsert.ExecuteNonQuery();
break;
}
}
}
finally
{
dbConn.Close();
}
}
public static void default_SaveData(HttpRequest request, AjaxSaveDataHandlerEventArgs args)
{
string serverPath = "";
serverPath = System.Web.HttpContext.Current.Server.MapPath(serverPath);
OleDbConnection dbConn = new OleDbConnection("provider=Microsoft.Jet.OLEDB.4.0; data source=" + serverPath + @"\data\generalproducts.mdb");
try
{
dbConn.Open();
for (int p = 0; p < args.Count; p++)
{
IRow r = args[p];
UpdateAction action = r.UpdateAction;
switch (action)
{
case UpdateAction.Delete:
OleDbCommand cmd = dbConn.CreateCommand();
cmd.CommandText = "delete from tblProducts where ProductID = @productId";
cmd.Parameters.AddWithValue("productId", r["ProductId"]);
cmd.ExecuteNonQuery();
break;
case UpdateAction.Update:
cmd = dbConn.CreateCommand();
cmd.CommandText = "update tblProducts set ProductName = @productName, BulkAction = @bulkAction where ProductId = @productId";
cmd.Parameters.AddWithValue("productName", r["ProductName"]);
cmd.Parameters.Add("bulkAction", OleDbType.Boolean).Value = Convert.ToBoolean(r["BulkAction"]);
cmd.Parameters.AddWithValue("productId", Convert.ToInt32(r["ProductId"]));
cmd.ExecuteNonQuery();
break;
}
}
}
finally
{
dbConn.Close();
}
}
public void saveData(HttpRequest request, AjaxSaveDataHandlerEventArgs info)
{
if (SaveData != null)
SaveData(request, info);
}
