Live Accounting App by C# .NET Core in Windows Forms and SQL

Explore the main parts of accounting software, including the main form, user background changer, and settings, then navigate modules like customers, sales invoices, purchase invoices, payments, expenses, and reports.

Create a new C# Windows Forms .NET Core project in Visual Studio, name the accounting software, configure the solution and framework, add the main form, then build and run.

Design the main form for a Windows Forms accounting app by creating a new project and adding a form, then arrange a top and bottom panel with docked controls.

Design the bottom panel of the main form by adding a background changer, a login username, a user image, a date-time display updated by a timer, and a combo box.

Load and switch the main form's background image in a C# Windows Forms app using a combo box, storing images in data/pics, and loading via Image.FromFile with a stretch layout.

Write C# code to save the selected combobox image index in application settings on close, then load it on form startup to display the last chosen background.

Learn to add a tree view in a Windows Forms app, dock it in a panel, build root and child nodes, and assign images via an image list with keys.

Write C# code to show and hide the tree panel using the accounting button, implement expand and collapse all, and refresh the tree view in a Windows Forms app.

Learn the three core components of a database app—database, a Visual Studio application, and the ado.net connector—to load and display SQL data using datagridview.

Design a SQL server database accounting and create a customers table with an auto-generated id primary key, plus first name, last name, gender, contact, and address fields, using Windows authentication.

Design and populate the customers table with sample data, including first name, last name, gender, contact details, email, and rec date/time, using an auto-generated id and nullable fields.

Add the dataset to the project, load data from the SQL database into an in-memory data table via a table adapter, and bind it to the form using a bindingsource.

Install the SQL data provider in your project using the NuGet Package Manager. Choose the Microsoft.Data.SqlClient package in the latest stable version compatible with dotnet 6.0 or higher.

Learn to add a data table and table adapter to a dataset, configure a SQL Server connection, build select queries with query builder, and generate insert, update, and delete methods.

Explore the data table and table adapter in a Windows Forms project, focusing on identity, nullability, int 32 and nvarchar, and generating CRUD queries with the query builder.

Design a customer data form. Assemble a toolbar, group box, and data grid view with id, first name, last name inputs; prepare for binding with a binding source.

bind form controls to a data table using a bindingsource, connect a datagridview, and load data with a table adapter in a Windows Forms app.

Learn to enable and disable form controls in a Windows Forms app, including the toolbar, GroupBox, and DataGridView, with a shared method for new, edit, delete, save, and cancel.

Learn to implement top button logic in a C# Windows Forms app using a binding source to add, edit, delete, and cancel records, then save changes via a table adapter.

Master DataGridView customization by editing columns, adjusting header text and widths, and preserving binding column. Learn to set selection mode, row height, and add or remove bound or unbound columns.

Write C# code to assign rec user, rec date, and rec time using DateTime and ToString with a 24-hour format, for new and edit records.

Add a search feature to the customers form using a parameterized SQL query, enabling id and last name searches via a table adapter, with a show/hide search panel.

Connect the customers form to the main form in a Windows Forms app by assigning the MDI parent and opening the customers form on TreeView double-click using show.

Create a products table in sql server with product_id as auto-generated primary key, and fields like product name, initial quantity, unit, price, discount, comment, and audit fields req_user, req_date, req_time.

Connect the products database to the application using Azure, creating a table adapter and loading data from the products table with a select query and ordering by product id.

Design and bind a Windows Forms products form by adding a dataset, binding source, and table adapter, then lay out controls, apply properties, and use copy-paste workflows to finalize.

Copy the customer form to create a product form, wire up new, edit, delete, save, and cancel actions, and implement product table adapters and search by ID or name.

Learn to design a settings form in a windows forms app, add a settings context menu, arrange controls, set properties, and prepare for saving settings in a live accounting app.

Learn to write C# code to save and load application settings in a Windows Forms app using Properties.Settings, including strings and doubles, with parsing, error handling, and user feedback.

Create the sales invoice table in SQL Server, define invoice_id as int primary key with identity, add invoice_date (date), customer_id (int), customer_name (nvarchar), and money fields for shipping and other.

Add the sales invoice sql table to a dataset in a Windows Forms project, configure the connection string, and generate fill, update, insert, and delete methods.

Design and bind a sales invoice form in a C# .NET Core Windows Forms app, wiring in customers, products, and invoice data with a binding source and table adapter.

Learn to implement a sales invoice form in a C# Windows Forms app by copy-pasting button code and binding to the sales invoice table with a table adapter.

Design and implement a Windows Forms customer search form with a search panel, binding to the customers table, and integration with the main sales invoice.

Design and implement the sales invoice table and related invoice products table in SQL Server, including invoice id, product name, qty, unit price, tax, and net amount.

Design the sales invoice product form in a Windows Forms app, wiring the product list with bindings to invoice data, including id, product name, quantity, and unit price.

Write C# code for the product form, connect the product list to the sales invoice form, pass the invoice ID, and load data via table adapters and binding sources.

Customize the product DataGridView by editing columns, resizing headers, hiding product ID, moving invoice ID to the panel, and formatting amount, tax, and net amount.

Design a product search form integrated with the product list, reuse the SEO search approach, and bind data with the bindingsource to drive the datagridview through a table adapter.

Set default zero values for all numeric columns in the live accounting app, configuring SQL Server data types and bindings so new invoices and products initialize with zeros.

Learn to format numeric columns in a datagridview by applying integer and currency formats, setting decimals and thousand separators for unit price, tax rate, discount, and net amount.

Bind unit, unit price, and discount from the product search form to product list form, using a public modifier and decimal parsing to update labels and numeric up down controls.

Learn to implement live calculations in a Windows Forms product form: compute amount from quantity, price, and discount, then tax sum and net amount from a tax rate.

Load invoice products with the table adapter for the selected id, then guard against null or invalid ids and missing customer. Set invoice date to the current date and time.

Learn to calculate sums across numeric columns in a Windows Forms app by using DataTable.Compute or a SQL sum query to derive amount, tax sum, net amount, shipping, and total.

Design and implement the receive money form and its sql server database, linking invoices and customers with pay date, cash amount, and comments using binding sources and data adapters.

Develop the receive money form in a C# .NET Windows Forms app by wiring buttons, binding data, and using a datagridview, date picker, and table adapters.

Connect the receive money feature to the sales invoice using the payment button by transferring invoice id, customer name, and key id to the receive money form.

Learn to write C# code to calculate the total paid amount and total due for invoices by loading receive money data, summing cash amounts, and updating the user interface.

Learn to guard negative total dues in a Windows Forms numeric up-down by adjusting the minimum, adding a try statement, and using a message box to inform users.

Fix the bug in the receive money edit button by guarding direct access and correctly repopulating the customer name, sue name, and invoice ID from the sale invoice form.

Learn to design and create SQL Server tables for the purchase bill, spend money, and purchase bill products by copying column definitions, setting primary keys, and enabling identity fields.

Connect sql server tables to a dataset by adding table adapters, generating the insert, update and delete queries, and filling data tables for purchase bill, purchase product, and spend money.

design the purchase bill form by copying the sale invoice layout, binding sources and data sets, and organizing the datagridview and panels for purchase items.

Create a purchase bill form in a C# .NET Windows Forms app. Reuse sales invoice code for buttons and events, wire purchase products, and connect to the main form.

Design the purchase product list in a Windows Forms app by binding data to a datagridview and mapping id, product name, quantity, unit price, tax, and net amount.

Master purchasing product workflows in a C# .NET Windows Forms app by copying code, wiring form load events, and configuring purchase products, purchase bill, tax rates, and currency formatting.