Hi, just convert your
ListView Items to object of its type, and now you can access
Category Name, Amount, Discount properties from converted object. just refer the code below,
for (int i = 0; i < ListView_Selected_Category.Items.Count; i++)
{
YourCategoryClass CategoryObject = (YourCategoryClass)ListView_Selected_Category.Items[i];
SQLiteCommand cmd = new SQLiteCommand(query, con);
cmd.Parameters.Add(new SQLiteParameter("@1", CategoryObject.CategoryName));
cmd.Parameters.Add(new SQLiteParameter("@2", CategoryObject.Amount));
cmd.ExecuteNonQuery();
}