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); }