本文整理汇总了C#中StoredProcedure.ExecuteNonQuery方法的典型用法代码示例。如果您正苦于以下问题：C# StoredProcedure.ExecuteNonQuery方法的具体用法？C# StoredProcedure.ExecuteNonQuery怎么用？C# StoredProcedure.ExecuteNonQuery使用的例子？那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类StoredProcedure的用法示例。
在下文中一共展示了StoredProcedure.ExecuteNonQuery方法的8个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: DeleteBanner
public static void DeleteBanner(int p_BannerID)
{
StoredProcedure sp = new StoredProcedure("p_Banners_d");
sp["@BannerID"].Value = p_BannerID;
sp.ExecuteNonQuery();
}示例2: UpdateCategoryOrder
public static void UpdateCategoryOrder(int p_CategoryID, OrderDirection p_Direction)
{
StoredProcedure sp = new StoredProcedure("p_Categories_u_Order");
sp["@CategoryID"].Value = p_CategoryID;
sp["@Direction"].Value = (int) p_Direction;
sp.ExecuteNonQuery();
}示例3: DeleteCategory
public static void DeleteCategory(int p_CategoryID)
{
StoredProcedure sp = new StoredProcedure("p_Categories_d");
sp["@CategoryID"].Value = p_CategoryID;
sp.ExecuteNonQuery();
}示例4: UpdateCategory
public static void UpdateCategory(int p_CategoryID, int? p_ParentCategoryID, string p_Name,
string p_CategoryCode, bool p_bShowOpen, string p_Picture)
{
StoredProcedure sp = new StoredProcedure("p_Categories_u");
sp["@CategoryID"].Value = p_CategoryID;
sp["@ParentCategoryID"].Value = p_ParentCategoryID == null ? DBNull.Value : (object)p_ParentCategoryID;
sp["@Name"].Value = p_Name.Trim();
sp["@CategoryCode"].Value = p_CategoryCode.Trim();
sp["@ShowOpen"].Value = p_bShowOpen;
sp["@Picture"].Value = p_Picture;
sp.ExecuteNonQuery();
}示例5: SetEnable
public static void SetEnable(int p_CategoryID, bool p_isDisable)
{
StoredProcedure sp = new StoredProcedure("p_Categories_setEnable");
sp["@CategoryID"].Value = p_CategoryID;
sp["@isDisable"].Value = p_isDisable;
sp.ExecuteNonQuery();
}示例6: UpdateCustomer
/// <param name="p_Password">ѕередаем null, если хотим чтоб не измен¤лс¤ пассворд</param>
public static void UpdateCustomer(int p_CustomerID, string p_FirstName, string p_LastName, string p_Email, string p_Password)
{
StoredProcedure sp = new StoredProcedure("p_Customers_u");
sp["@CustomerID"].Value = p_CustomerID;
sp["@FirstName"].Value = p_FirstName.Trim();
sp["@LastName"].Value = p_LastName.Trim();
sp["@Email"].Value = p_Email.Trim();
sp["@Password"].Value = p_Password == null ? DBNull.Value : (object)p_Password.Trim();
sp.ExecuteNonQuery();
}示例7: DeleteCustomerAddress
public static void DeleteCustomerAddress(int p_CustomerAddressID)
{
StoredProcedure sp = new StoredProcedure("p_CustomerAddresses_d");
sp["@CustomerAddressID"].Value = p_CustomerAddressID;
sp.ExecuteNonQuery();
}示例8: UpdateCustomerCampaign
public static void UpdateCustomerCampaign(int p_CustomerID, int p_CampaignID)
{
StoredProcedure sp = new StoredProcedure("p_Customers_u_CampaignID");
sp["@CustomerID"].Value = p_CustomerID;
sp["@CampaignID"].Value = p_CampaignID;
sp.ExecuteNonQuery();
}