Greetings! This is the course: Fast SQL in VB .NET -Live Accounting Project By Visual Basic. No prior knowledge of VB is required, nor do you need to be a student needing hands-on practice; this course is created to introduce you to VB from scratch in Visual Studio 2022. Although VB is a fairly easy language to program in, you may need some background knowledge about VB in addition to at least half an hour of your time, and you’ll be programming in VB in no time! NET Core, building actual projects, and getting a chance to work at well-paying programming positions.
In this course, “Fast SQL in VB .NET -Live Accounting Project By Visual Basic,” to begin with, you will have to install VB in Visual Studio 2022 and learn about the basic designing of main forms to implement SQL through ADO. NET. You will be able to lay down and manage an MS SQL Server, develop database applications and produce very nice reports with a PDF engine at your disposal. It also includes more tangible assignments such as the design of “Customers Data Entry” and “Products Data Entry” forms and of DataGridView. In the same respect, you will be introduced to tools such as TableAdapter, Dataset, and Datatable, and you will learn how to deal with the application settings.
Here, the idea is to make this course as fun and practical as possible. Some of the projects that students shall be working on include creating the accounting database, adding the digital clock to the main form, and incorporating the user login image. Each idea is provided with non-mandatory case studies, making sure you not only grasp the material but also have fun doing it.
Fast SQL in VB .NET -Live Accounting Project By Visual Basic Table of Contents:
- Introduction (04:12)
- Download project files of this course (00:00)
- Main parts of accounting software (01:49)
- Creating accounting project (08:53)
- Designing main form (17:22)
- Designing bottom panel (09:15)
- Changing background image (10:49)
- Reload selected background (07:54)
- Start using tree view (19:53)
- Tree view VB code (06:16)
- ADO.NET structure (05:38)
- Customer database in SQL (13:02)
- Adding sample data (04:50)
- Adding Dataset to project (08:18)
- Install NuGet packages (03:51)
- Adding DataTable and TableAdapter (15:49)
- Deep dive into DataTable and TableAdapter (09:20)
- Designing customer form (17:12)
- Binding data to items on form (13:05)
- Enable and disable buttons on form (16:36)
- VB code for top button (14:27)
- Customize DataGridView (08:09)
- Adding VB code for registration data (04:41)
- Searching SQL data in VB (20:17)
- Connecting customer to main form (05:44)
- Creating product table in SQL (09:14)
- Using database in application (04:54)
- Designing the products form (16:05)
- Writing the code for product form (10:56)
- Designing setting form (10:32)
- VB code for settings form (14:10)
- Create invoice table in SQL (05:36)
- Adding SQL table to dataset (03:26)
- Designing sales invoice form (19:09)
- VB code for sales invoice form (08:15)
- Designing customers search form (23:37)
- Adding products database in SQL (08:04)
- Designing products form (24:16)
- VB code for product form (15:45)
- Customizing product DataGridView (08:35)
- Designing product search form (17:10)
- Assigning default value for numeric columns (09:41)
- Formatting numeric columns in DataGridView (12:04)
- Connecting 'product search' to product form (06:20)
- Auto calculate sum in product form (14:24)
- Adding some protections to code (13:36)
- Calculate sum of data (28:35)
- Designing receive money form (19:32)
- VB code for the receive money form (12:32)
- Connect receive money to sales invoice (21:13)
- Calculate sum of receive money (18:23)
- Adding guard to negative numbers (05:46)
- Design SQL database for purchase bill (07:56)
- Connecting database to application (08:12)
- Design purchase bill form (13:22)
- VB code for purchase bill (18:36)
- Purchase product list design (13:42)
- VB code for purchase product (26:29)
- Design spend money form (09:47)
- VB code for spend money form (21:11)
- Create expense table (04:39)
- Design cost form (08:01)
- VB code for cost code (09:13)
- Who should watch this section (00:05)
- Download project files of this section (00:00)
- Creating project for Excel (06:08)
- Installing NuGet for Excel (07:44)
- Creating SQL DB for Excel (05:57)
- Connecting DB to project (07:57)
- Adding items and DGV (11:31)
- Loading Excel file (08:38)
- Reading Excel data (17:39)
- Adding progress bar (10:45)
- Save Excel data in SQL (14:49)
- Fix the date bug (01:15)
- Loading all data (04:33)
- Exporting data to Excel (09:52)
- Installing PDF package (04:16)
- Create empty PDF file (09:10)
- Add report title to PDF (12:52)
- Add free space & line (06:28)
- Add table header to PDF (15:28)
- Add table data to PDF (14:03)
- Show progress panel (05:02)
- Format decimal columns (04:32)
- Adding print button (06:26)
- Export to PDF in cost form (14:52)
- Adding print to cost form (10:12)
- Export to Excel in cost form (05:22)
- Print data in receive money form (17:27)
- Adding print to spend money form (10:46)
- Adding print to products form (14:48)
- Adding print to customers forms (16:08)
- List of invoices (31:51)
- Adding print to invoice list (17:30)
- List of purchase bill (22:53)
- Invoice print part 1 (28:26)
- Invoice print part 2 (21:57)
- Adding print to Purchase Bill form (13:22)
- Creating user database (09:42)
- Adding user form (04:13)
- Designing user form (13:08)
- Writing VB code for user form (09:17)
- Browse button in user form (11:04)
- Designing login form (08:00)
- Writing VB code for login form (12:33)
- Connecting login user to main form (09:45)
- Adding About Us form (08:18)
- Adding shortcuts to main form (09:09)
- Designing SQL connection form (24:44)
Who is this course for?
- Anyone who wants to learn Windows form and VB from scratch.
Click on the links below to Download Fast SQL in VB .NET -Live Accounting Project By Visual Basic!
در حال پاسخ به :