Tags
Language
Tags
June 2025
Su Mo Tu We Th Fr Sa
1 2 3 4 5 6 7
8 9 10 11 12 13 14
15 16 17 18 19 20 21
22 23 24 25 26 27 28
29 30 1 2 3 4 5
    Attention❗ To save your time, in order to download anything on this site, you must be registered 👉 HERE. If you do not have a registration yet, it is better to do it right away. ✌

    ( • )( • ) ( ͡⚆ ͜ʖ ͡⚆ ) (‿ˠ‿)
    SpicyMags.xyz

    Quick Sql In Vb .Net : Database Apps In Visual Basic & Sql

    Posted By: ELK1nG
    Quick Sql In Vb .Net : Database Apps In Visual Basic & Sql

    Quick Sql In Vb .Net : Database Apps In Visual Basic & Sql
    Published 8/2023
    MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
    Language: English | Size: 30.40 GB | Duration: 68h 51m

    10 in 1:Data Entry App, Visual Basic ADO .Net ,Search SQL in VB ,multi user,Image in SQL Server,Backup,Aggregate,Publish

    What you'll learn

    10 Courses in one + 60 Hours + 10 Projects - Longest SQL in VB. Net course on Udemy!

    Easily Learn Pro Database Apps with VB .Net and SQL: Data Entry Apps ,Phone Book, Image in SQL ,Searching and Filtering Data, Aggregates ,SQL CRUD, Multi User A

    Build VB. Net Apps by SQL ADO .Net

    Pro English Dictionary by 176,000 Words!

    Start working With SQL Server

    Search the SQL Data by VB. net App

    Filtering data to find values quickly

    Design Pro Data Entry Forms

    Save Image in SQL Db by VB .net App

    Create Phone Book Project in VB .net

    Multi User App & Login Form in VB. net

    Backup and Restore SQL Db in VB. Net

    SQL Aggregates ( Sum, Avg, Max, Min) in VB

    Publish VB .net Apps in SQL in Users PC

    Load,Save,Delete & New By VB. net in SQL

    Date,Time,Currency & Number in VB. Net

    SQL CRUD : Insert, Update, Delete functions

    Working with Oracle VirtualBox

    Requirements

    Visual Studio 2017 or 2019 or 2022 Community edition or other versions

    General Knowledge of Visual Basic Programming

    Inner Motivation to Learn SQL in VB. Net!

    Description

    Hi ThereWith my 20 years programming skills Im with you to share my knowledge with youSoIf you want to make a lot of moneyIf you want to find best jobs in programmingIf you want to buy 1 course and get 10 coursesIf you try you will learn using SQL Server Database in VB  Net ApplicationIf you are beginners or student looking for a tutorial to database app in SQL Server and create a application for that in VB  Net in simplest wayI started from beginning and show you how toStart Working with SQL ServerBuild VB Net Apps by SQL ADO  NeSearch the SQL Data by VB  net AppDesign Pro Data Entry FormsSave Image in SQL Db by VB  Net AppPro English Dictionary by 176000 WordsCreate Phone Book Project in VB  netMulti User App and Login Form in VB  netBackup and Restore SQL Db in VB  NetSQL Aggregates  Sum Avg Max Min in VB  NetPublish VB  net Apps in SQL in Users PCLoad Save Delete and New By VB  net in SQLUsing Date Time Currency and Number in VB  NetWorking with Oracle VirtualBoxDont hesitate to start learning SQL Server in vb  netEvery thing will be discussed with sample project and you will have lot of fun within my courseSay Hi SQL and VB  net world and lets go

    Overview

    Section 1: Intro

    Lecture 1 Course Intro

    Lecture 2 Download projects and files of this course

    Section 2: SQL Serverfor Beginners

    Lecture 3 Who should watch this section!

    Lecture 4 Download & install SQL 2014 on Windows 10 and Windows 7

    Lecture 5 Start using SQL server and SSMS

    Lecture 6 Working with SQL database

    Lecture 7 Using SQL Server configuration manager

    Lecture 8 Using SQL Server Table

    Lecture 9 SQL Numeric Data types

    Lecture 10 SQL English Text Data types

    Lecture 11 SQL Unicode Text Data types

    Lecture 12 GUID datatype in SQL

    Lecture 13 How to Attach, Detach and offline the SQL database

    Lecture 14 Identity and Auto Increment Column in SQL Server

    Lecture 15 SQL Date Time Data types

    Section 3: Basics - "Phone Book" Db in SQL

    Lecture 16 Section intro

    Lecture 17 Intro -Road map of Phone Book Db in SQL

    Lecture 18 Create "Phone Book" database in SQL

    Lecture 19 Select Query In SQL

    Section 4: Basics - Using SQL Database in VB

    Lecture 20 Intro - Using SQL ADO.Net in VB

    Lecture 21 SQL ADO.Net Introduction

    Lecture 22 Adding and debt and income columns to database

    Lecture 23 Create VB.Net Phone Book Project for SQL Server

    Lecture 24 Add Dataset to VB.Net project

    Lecture 25 Make a back up of our project

    Lecture 26 Add Table Adapter to Dataset

    Lecture 27 SQL Server Connection String in Depth

    Lecture 28 Using Manual Query editor in VB.Net

    Lecture 29 Using Diagram & Criteria to Create SQL Select Query

    Lecture 30 Finish Adding Table Adapter to Dataset

    Lecture 31 What is Dataset and Data table in VB.Net

    Lecture 32 What is Table Adapter in VB.Net

    Lecture 33 How to configure SQL Query in Table Adapter

    Section 5: Basics - Data Entry Form in VB

    Lecture 34 #### Section intro 1 ### - Add DataGridView

    Lecture 35 Add Datagrid view to Phone Book form

    Lecture 36 Resolve errors and create form again

    Lecture 37 What is Binding Source?

    Lecture 38 Add All Textboxes & Labels to Phone Book Form

    Lecture 39 Adding Textbox & Label one by one to Form

    Lecture 40 Configure New , Delete and Save Buttons in Form

    Lecture 41 Add Records to Dataset and save in SQL Server Database

    Lecture 42 #### Section intro 2 ### - Add Toolbar to data entry form

    Lecture 43 Upgrade to Visual Studio 2019 my Phone Book project

    Lecture 44 Add toolbar to data entry form

    Lecture 45 Add image to toolbar buttons

    Lecture 46 Enable|Disable toolbar buttons by VB.Net code

    Lecture 47 Create method for Enable|Disable buttons

    Lecture 48 Enable|Disable Datagridview & Groupbox by VB.Net code

    Lecture 49 #### Section intro 3 ### - VB.Net codes for data entry buttons

    Lecture 50 Write "Add New " button code in VB.Net

    Lecture 51 Write "Save Changes" button code in VB.Net

    Lecture 52 Show message box after saving data to SQL

    Lecture 53 Write "Delete User" button code in VB.Net

    Lecture 54 Write "Edit" & "Cancel" buttons code in VB.Net

    Lecture 55 Add empty record guard to "Edit" & "Delete" Buttons

    Lecture 56 Disable groupbox Items when click the "Delete" button

    Section 6: Basics - Loading Data & DataGridView

    Lecture 57 TableAdapter section intro

    Lecture 58 Use default Fill method of TableAdapter

    Lecture 59 Add new Fill method for TableAdapter and use it

    Lecture 60 Add new BindingNavigator and using it

    Lecture 61 Customize default BindingNavigator

    Lecture 62 #### Section intro 1 ### - Working with DataGridView

    Lecture 63 Disable DGV edit,delete,column reorder,new row and …

    Lecture 64 Disable DGV column & row resize

    Lecture 65 Add and remove DGV columns

    Lecture 66 Change the width and visibility of columns in DGV

    Lecture 67 Change the text of Columns in DGV

    Section 7: Basics - Advance ADO.Net

    Lecture 68 #### Section intro 1 ### - Advance Topics of ADO.Net

    Lecture 69 Get the Row count by using DataTable

    Lecture 70 Get the Row count after deleting some records by using DataTable

    Lecture 71 Sort the records inside DataTable using Select query

    Lecture 72 Get the Row count by using BindingSource

    Lecture 73 Get the current record position using BindingSource

    Lecture 74 Using BindingSource to Sort the records inside DataTable

    Lecture 75 #### Section intro 2 ### - Create Custom BindingNavigator

    Lecture 76 Design custom BindingNavigator by normal buttons

    Lecture 77 Write the code to navigate between records

    Lecture 78 Adding "Current Record" & "Total Records" labels to custom Navigator

    Lecture 79 Disable "First" & "Previous" buttons in first record

    Lecture 80 Disable "Last" & "Next" buttons in last record

    Lecture 81 Using "Try" structure to protect VB.Net codes against errors

    Section 8: Basics - Saving Image to SQL

    Lecture 82 Intro - Saving Image to SQL

    Lecture 83 Steps to save customer image in SQL database

    Lecture 84 Add customer image picturebox and browse button

    Lecture 85 Write the code to load customer image in VB.Net

    Lecture 86 Add empty image guard to customer image

    Lecture 87 Add filter for selecting customer image

    Lecture 88 Add "No Image" picture for new customer image

    Lecture 89 Add customer image column to SQL Server database

    Lecture 90 Add customer image column to VB.Net project by Configuring TableAdapter

    Lecture 91 Save Image in SQL DataBase

    Lecture 92 Configure TableAdpter to load saved image in form

    Section 9: Advance - Searching data

    Lecture 93 Course intro

    Lecture 94 Intro - Searching data

    Lecture 95 Download projects and files of this course

    Lecture 96 Intro creating phone book database

    Lecture 97 Search SQL data : Review to Create "Phone Book" Db in SQL

    Lecture 98 #### Section intro 1 ### - "Phone book" project in VB.Net

    Lecture 99 Create VB.Net Phone Book Project for SQL Server

    Lecture 100 Overview of ADO.NET

    Lecture 101 Add Dataset & TableAdapter to Phone Book app

    Lecture 102 Bind datatable to Datagrid View on form

    Lecture 103 Load data in to form from the SQL database

    Lecture 104 #### Section intro 2 ### - Finding the Fix Values in SQL

    Lecture 105 Where Clause for Searching Data in SQL

    Lecture 106 #### Section intro 3 ### - Finding Fix Values in VB.Net

    Lecture 107 Write query to search fix last name in VB.Net

    Lecture 108 Write query to search last name from textbox

    Lecture 109 Write query to search numeric columns

    Lecture 110 Search Unicode text in SQL table by VB.Net

    Lecture 111 Use Not equal operator(<>) for searching in VB.Net and SQL

    Lecture 112 Use other operators for search in SQL numeric columns in VB.Net

    Lecture 113 #### Section intro 4 ### - Finding Similar Values in SQL

    Lecture 114 Simple like query

    Lecture 115 Like query with starting percent

    Lecture 116 Like query with ending percent

    Lecture 117 Search evrywhere by like

    Lecture 118 Unicode in where

    Lecture 119 Like query with other wild carts

    Lecture 120 Like query with not operator

    Lecture 121 #### Section intro 5 ### - Finding Similar Values in VB.Net

    Lecture 122 LIKE operator in table adapter for searching fix Last Name

    Lecture 123 Search words with common starting by WildCard '%' with SQL Like

    Lecture 124 Searching words with common ending by WildCard '%' and SQL Like

    Lecture 125 Searching words anywhere with WildCard '%'+ SQL Like

    Lecture 126 Use LIKE operator for searching Unicode Values

    Lecture 127 #### Section intro 6 ### - Finding Between Values in SQL

    Lecture 128 Between usage

    Lecture 129 Using between with numberic columns

    Lecture 130 Using between with text columns

    Lecture 131 Using between with date columns

    Lecture 132 Using between with not operator

    Lecture 133 #### Section intro 7 ### - Finding Between Values in VB.Net

    Lecture 134 Add Between operator to table adapter to search a rage of dates

    Lecture 135 Design form to use Between operator

    Lecture 136 Working with DateTimePicker control

    Lecture 137 VB.Net code to search between dates

    Section 10: Project -> Advance Search Form

    Lecture 138 Download project of: Advance Search Form

    Lecture 139 Intro - advance search project

    Lecture 140 Create the advance search project in VB.Net

    Lecture 141 Set form default setting and add dataset

    Lecture 142 Connect Project & Dataset to SQL Databse

    Lecture 143 Design search form and add controls to it

    Lecture 144 Write the code to show and hide controls

    Lecture 145 Add DataGrid View to form

    Lecture 146 Search data by date of birth between 2 dates

    Lecture 147 . Search data by last name and 4 operators

    Lecture 148 Show message box when search type is not selected

    Lecture 149 Search last name by between and not equal operator

    Lecture 150 Protect the code by try structure

    Section 11: Project -> English Dictionary (+176,000 Words)

    Lecture 151 Download project files of: Pro English Dictionary

    Lecture 152 Intro - Pro English Dictionary with 176,000 words

    Lecture 153 How to download SQL Database of Dictionary with 176,000 words

    Lecture 154 Attach SQL database inside SQL Data folder

    Lecture 155 Attach SQL database inside custom folder

    Lecture 156 Create the English Dictionary project in VB. Net

    Lecture 157 Set the default properties of dictionary form

    Lecture 158 Design the English Dictionary main form

    Lecture 159 Add the dataset to VB.Net project

    Lecture 160 Connect VB. Net project to SQL Server

    Lecture 161 Write Select query in table adapter and add datatable

    Lecture 162 Bind data gridview and binding navigator to Datatable

    Lecture 163 Customize DGV columns (resize,column header, …)

    Lecture 164 Change the color of odd & even records in DGV

    Lecture 165 Change the row height & row header width of DGV

    Lecture 166 Add a textbox to show the definition completely

    Lecture 167 Add a query to search exact word in tableadapter

    Lecture 168 Write the code to search exact Word in VB .Net code

    Lecture 169 Add a query to search similar words in tableadapter

    Lecture 170 Add the search type combobox to form

    Lecture 171 Write VB.Net code to identify selected search type

    Lecture 172 Write the code to search similar Words in VB. Net code

    Lecture 173 Show the progress panel while searching the words

    Lecture 174 Sort the records after searching by table-adapter

    Lecture 175 Use the binding-source to sort the words after searching

    Lecture 176 Show message box when there is nothing to search

    Lecture 177 Add a button to show all words in dictionary

    Lecture 178 Finalize project by loading the default data in the startup

    Section 12: Advance - Filtering Data

    Lecture 179 Intro - Filtering Data

    Lecture 180 Project files of next sections

    Lecture 181 #### Section intro 1 ### - Build project for filtering data

    Lecture 182 Various methods to search data

    Lecture 183 Create the project in VB .Net to search data by filter

    Lecture 184 Add Dataset to VB.Net project

    Lecture 185 Connect the project to SQL database by adding Table-Adapter & datatable

    Lecture 186 Add the data-gridview to project and design dictionary form

    Lecture 187 #### Section intro 2 ### - Filtering Numeric Data

    Lecture 188 Search fix number by filter in numeric column

    Lecture 189 Other operators with filter to search numeric column

    Lecture 190 Using Logical operators with filter to advance search

    Lecture 191 #### Section intro 3 ### - Filtering Text Data

    Lecture 192 Using the filter to search exact text in text column

    Lecture 193 Filter & like operator to search similar values

    Lecture 194 Logical operators with text and numeric columns

    Lecture 195 #### Section intro 4 ### - Sorting records & remove filter

    Lecture 196 Sort the records by single column with the binding-source

    Lecture 197 Multi-column sorting with bindingsource

    Lecture 198 Remove the filter property of the bindingsource

    Lecture 199 Remove the sort property of the bindingsource

    Lecture 200 #### Section intro 5 ### - Filtering Date Data

    Lecture 201 Add phone book form to search the date column by filter

    Lecture 202 Add DateTimePicker and DGV to phone book form

    Lecture 203 Vb.Net code to search fix date by filter method

    Lecture 204 Effect of Windows regional format to search date by filter

    Lecture 205 Use DateTimePicker to search the date by filter method

    Lecture 206 Change DateTimePicker value by Vb. Net code

    Section 13: Project -> Fast English Dictionary

    Lecture 207 Download project files of: Fast English Dictionary

    Lecture 208 Intro - fast English dictionary

    Lecture 209 Prepare previous dictionary project to develop

    Lecture 210 VB.Net code to load the default records of dictionary

    Lecture 211 Use filter method to write "Show all" button code

    Lecture 212 . Search exact word by filter method

    Lecture 213 Search similar words in dictionary by filter method

    Lecture 214 Make Dictionary startup faster by timer control

    Section 14: Project -> Fast Search Phone Book

    Lecture 215 Download project files of: Fast Phone Book Search By Filter

    Lecture 216 . Intro - Fast search phone book

    Lecture 217 Prepare previous phone book project to develop

    Lecture 218 VB.Net code to load the all records of phone book in app startup

    Lecture 219 VB .Net code for "Show all" Button by filter method

    Lecture 220 Use filter to search exact last name in phone book

    Lecture 221 Use filter to search similar last name in phone book

    Lecture 222 Use Not equal operator(<>) with filter to search data

    Lecture 223 Auto search by filter

    Lecture 224 Search the date column by filter

    Lecture 225 Sort records after searching by filter

    Section 15: Pro - Date, Time, Currency & Number

    Lecture 226 Project files of Date,Time,Currency & Number with MaskedTextBox

    Lecture 227 #### Section intro 1 ### - Start Using MaskedTextBox

    Lecture 228 Add a new form and MaskedTextBox to the project

    Lecture 229 Using the MaskedTextBox by default masks

    Lecture 230 Main parts of the mask property for Date values

    Lecture 231 Change the prompt character of MaskedTextBox

    Lecture 232 Disable Space key on the MaskedTextBox

    Lecture 233 #### Section intro 2 ### - Using MTB for Date, Time, Number & Currency

    Lecture 234 Get the final Text of MaskedTextBox in VB.Net code

    Lecture 235 Using MaskedTextBox for Date and Time values

    Lecture 236 Using MaskedTextBox for Numerics values

    Lecture 237 What is the country based language code?

    Lecture 238 Using the MaskedTextBox for localized Currency

    Lecture 239 Using the MaskedTextBox for localized Date

    Lecture 240 Using the MaskedTextBox with Arabic language

    Lecture 241 Using the MaskedTextBox with Persian language

    Lecture 242 #### Section intro 3 # - Validating MTB for Date, Time, …

    Lecture 243 Validating MaskedTexbox Text as Date for LTR languages

    Lecture 244 Advance tips for Validating MaskedTexbox Text as Date for LTR languages

    Lecture 245 Validating MaskedTexbox Text as Date for Arabic & Persian & other RTL languages

    Lecture 246 Validating MaskedTexbox Text as Time

    Lecture 247 Validating MaskedTexbox Text as Number

    Lecture 248 Validating MaskedTexbox Text as Currency

    Lecture 249 . #### Section intro 4 ### - VB.Net project to save MTB values in SQL

    Lecture 250 Create a SQL database for using MaskedTextBox in VB.Net

    Lecture 251 Add customer info table to SQL database

    Lecture 252 Add sample data to SQL Server Table

    Lecture 253 Add 3 form to project for English,Arabic & Persian language

    Lecture 254 Set the form default properties and add the dataset

    Lecture 255 Add Table Adapter to Dataset and connect it to SQL

    Lecture 256 Add Datagrid view and items to form

    Lecture 257 Write VB.Net code to save data and load them back

    Lecture 258 #### Section intro 5 ### - MTB in VB.Net for Date and Time

    Lecture 259 Effect of Windows regional format of date column in VB.Net App

    Lecture 260 Change the culture of App by VB. Net code

    Lecture 261 Add MaskedTextBoxs to form and bind them to Datatable

    Lecture 262 Prepare MaskedTextBox for Date datatype

    Lecture 263 Change Application short date format in VB .Net code

    Lecture 264 VB code to Validate the Date inside MaskedTextbox for LTR languages

    Lecture 265 Prepare MaskedTextBox for Time datatype

    Lecture 266 Change Application short & long time format in VB.Net code

    Lecture 267 VB.Net code to Validate the Time in MaskedTexbox

    Lecture 268 #### Section intro 6 ### - MTB in VB.Net for Numbers & Currency

    Lecture 269 Prepare MaskedTextBox for Numeric datatype

    Lecture 270 VB.Net code to Validate the Number in MaskedTexbox

    Lecture 271 Prepare MaskedTextBox for Currency datatype

    Lecture 272 VB. Net code to change currency symbol in App culture

    Lecture 273 VB .Net code to Validate the Currency in MaskedTextbox

    Lecture 274 #### Section intro 7 ### - Data Validator Class & Method

    Lecture 275 Add class & method for data validation to Visual Studio project

    Lecture 276 Move our codes to validator method

    Lecture 277 Add parameter to our method

    Lecture 278 Add return value to validator method

    Lecture 279 Use the validator method in our form

    Lecture 280 Test and check the method by break point

    Lecture 281 #### Section intro 8 ### - Arabic & Persian Date, Time , …

    Lecture 282 Design Arabic data entry form with date,time , …

    Lecture 283 Change App culture to Arabic by visual basic code

    Lecture 284 Validate the Arabic date,time,number, …

    Lecture 285 Design Persian data entry form with date,time , …

    Lecture 286 Change App culture to Persian by visual basic code

    Lecture 287 Validate the Persian date,time,number, …

    Section 16: Pro - Amazing Data Entry Forms

    Lecture 288 Intro - Amazing Data Entry Forms

    Lecture 289 Download projects and files of this course

    Lecture 290 #### Section intro 1 ### - Add SQL Database for Goods

    Lecture 291 Create database and table for goods

    Lecture 292 Add sample data to SQL Server Table

    Lecture 293 #### Section intro 2 ### - Connecting SQL Db to VB.Net

    Lecture 294 Create new project in VB.Net

    Lecture 295 Add form for first data entry form

    Lecture 296 SQL ADO.Net Introduction

    Lecture 297 Add Dataset to VB.Net project

    Lecture 298 Add Table Adapter to Dataset and connect it to SQL

    Lecture 299 Simple working with query builder in Tableadapter

    Lecture 300 Advance working with query builder in Tableadapter

    Lecture 301 Finish Adding Table Adapter to Dataset

    Lecture 302 Datatable and Table Adapter in depth

    Lecture 303 Connection String & configuring Tableadapter query

    Lecture 304 . #### Section intro 3 ### - First data entry form type

    Lecture 305 Create data entry form by using first method

    Lecture 306 Working with BindingNavigator

    Lecture 307 Loading data with auto VB.Net generated codes!

    Lecture 308 Add data entry buttons in to top of form

    Lecture 309 Disable and enable data entry buttons by VB.Net code

    Lecture 310 Write the code for "New Record" Button

    Lecture 311 Write the code for "Save Changes" Button

    Lecture 312 Show message box after saving data to SQL

    Lecture 313 Write the code for "Delete Record" Button

    Lecture 314 Write the code for "Edit Record" & "Cancel" Buttons

    Lecture 315 Disable & enable DataGridView and group box

    Lecture 316 Prevent "Edit"&"Delete Button" empty record error

    Lecture 317 Working with DataGridView settings

    Lecture 318 #### Section intro 4 ### - 2nd data entry form type

    Lecture 319 Create data entry form by using second method

    Lecture 320 Design the main form of second method

    Lecture 321 Design the child form of second method data entry

    Lecture 322 Write the code to show the child form

    Lecture 323 Add status label to child form

    Lecture 324 Write the code for "New Record" Button

    Lecture 325 Write "Save Changes" button code in VB.Net

    Lecture 326 Reload the data after saving changes in SQL

    Lecture 327 Transfer selected ID from main form to the child form

    Lecture 328 Add the SQL query to load data by ID in TableAdapter

    Lecture 329 Write the code of "Edit Button" by using the "Fill By ID" query

    Lecture 330 Add the empty record guard to "Edit Button"

    Lecture 331 Write "Delete" button code in VB.Net

    Lecture 332 Sort records by "ID" column by 2 methods

    Lecture 333 Finalize second method forms

    Lecture 334 #### Section intro 5 ### - 3rd data entry form type

    Lecture 335 Add forms for 3rd data entry form

    Lecture 336 Design the main form of 3rd method

    Lecture 337 Show the child form of 3rd method data entry

    Lecture 338 Design the child form of 3rd method data entry

    Lecture 339 Write the code for child form of 3rd data entry form

    Lecture 340 Transfer selected ID from main form to the child form

    Lecture 341 load data by selected "ID" in child form

    Lecture 342 Correct the "Delete Button" code

    Lecture 343 Add the empty record guard to "Edit Button" & "Delete Button"

    Lecture 344 Add main form to show 3 data entry main forms

    Lecture 345 Using Try structure to protect code against SQL Errors

    Section 17: Pro - Saving Image in SQL

    Lecture 346 Intro - Saving Image in SQL

    Lecture 347 Project files of this course

    Lecture 348 How to load the Project files after downloading

    Lecture 349 #### Section intro 1 ### - Build "User List" Database in SQL

    Lecture 350 Create SQL Database for users List

    Lecture 351 Add image column to table in SQL

    Lecture 352 Add Users sample data in SQL Database

    Lecture 353 #### Section intro 2 ### - Add SQL Database in VB.Net

    Lecture 354 Create Users List project in VB.Net

    Lecture 355 Structure ADO

    Lecture 356 Add Dataset to VB.Net project

    Lecture 357 Connect VB.Net project to SQL Server

    Lecture 358 Add Select query to Table adapter

    Lecture 359 Add Datatable to Dataset and Tips

    Lecture 360 #### Section intro 3 ### - Design User List Form

    Lecture 361 Add Datagrid view & Items to Users form

    Lecture 362 Add user picture box to form

    Lecture 363 Write code to load user image in VB.Net

    Lecture 364 Add empty image guard to user image

    Lecture 365 Add filter for selecting user image

    Lecture 366 Add "No Image" picture for empty user image

    Lecture 367 #### Section intro 4 ### - Data Entry Form Toolbar

    Lecture 368 Add toolbar to data entry form

    Lecture 369 Add image to toolbar buttons

    Lecture 370 Enable|Disable toolbar buttons by VB.Net code

    Lecture 371 Create method for Enable|Disable buttons

    Lecture 372 #### Section intro 5 ### - Data Entry Buttons VB.Net Coding

    Lecture 373 "Add New User" button code in VB.Net

    Lecture 374 "Save Changes" button code in VB.Net

    Lecture 375 Show message box after saving data to SQL

    Lecture 376 "Delete User" button code in VB.Net

    Lecture 377 "Edit" & "Cancel" buttons code in VB.Net

    Lecture 378 Save user image in SQL Database

    Lecture 379 #### Section intro 6 ### - Customize DataGrid View (DGV)

    Lecture 380 Set the size of Image column in DGV

    Lecture 381 Set the height of Image column in DGV

    Lecture 382 Disable DGV edit,delete,column reorder,new row and …

    Lecture 383 Customize DGV columns (resize,column header, …)

    Lecture 384 #### Section intro 7 ### - Save Image Manually to SQL

    Lecture 385 Convert Image to Binary or Byte array

    Lecture 386 Save image binary directly in SQL database

    Lecture 387 #### Section intro 7 ### - Save Image Manually to SQL

    Lecture 388 Solve the error when insert method not found

    Lecture 389 Show message box after saving image in SQL

    Lecture 390 Add Guard to prevent empty image error

    Lecture 391 Insert data into SQL by using textboxes

    Section 18: Pro - Multi-UserApps

    Lecture 392 Intro - Multi User App

    Lecture 393 Download projects and files of this course

    Lecture 394 #### Section intro 1 ### - Add "User Login" Db in SQL

    Lecture 395 Create SQL Database for Users Login

    Lecture 396 Create table for Users Login in SQL Database

    Lecture 397 Add Users Login sample data in SQL Database

    Lecture 398 #### Section intro 2 ### - Design Form of "Login Users List"

    Lecture 399 Create Users Login project in VB.Net

    Lecture 400 Add main form for project

    Lecture 401 Add top & bottom panels with buttons

    Lecture 402 Add image & text to toolbar buttons

    Lecture 403 Add Dataset to VB.Net project

    Lecture 404 Connect VB.Net project to SQL Server

    Lecture 405 Add Select query to Table adapter

    Lecture 406 Finish adding Datatable to Dataset and Tips

    Lecture 407 #### Section intro 3 ### - Design "Login List" Main Form

    Lecture 408 Add main login users list form to VB.Net project

    Lecture 409 Add Datagrid view to login users list form

    Lecture 410 Write the code to load user list data by TableAdapter

    Lecture 411 #### Section intro 4 ### - Design "User Register" Form

    Lecture 412 Add user register form

    Lecture 413 Design User Register Form

    Lecture 414 Add items to user register form

    Lecture 415 Write the code to disable & enable data entry buttons

    Lecture 416 Write the code to disable & enable items inside groupbox

    Lecture 417 #### Section intro 5 ### - Coding "User Register" Form in VB.Net

    Lecture 418 Write "Add New User " button code in VB.Net

    Lecture 419 Write "Save Changes" button code in VB.Net

    Lecture 420 Show message box after saving data to SQL

    Lecture 421 Transfer selected ID from main form to the child form

    Lecture 422 Add the SQL query to load data by ID in TableAdapter

    Lecture 423 Write the code to load user data by selected ID

    Lecture 424 Write "Edit" & "Delete" button code in VB.Net

    Lecture 425 Write "Cancel" button code in VB.Net

    Lecture 426 Add empty record guard to "Edit" & "Delete" Buttons

    Lecture 427 Fill the data by last "ID" after saving in database

    Lecture 428 Refresh the records after closing user register form

    Lecture 429 Customize DataGrid View (DGV)

    Lecture 430 #### Section intro 6 ### - Saving User Image in SQL Db

    Lecture 431 Load the user image in picturebox

    Lecture 432 Add the guard for empty user image

    Lecture 433 Add filter for selecting user image

    Lecture 434 Saving User Image in SQL Database

    Lecture 435 #### Section intro 7 ### - Design User Login Form

    Lecture 436 Add login form to project

    Lecture 437 Design login form and adding controls to it

    Lecture 438 Bind user name combobox to data table

    Lecture 439 Add login info labels to login form

    Lecture 440 Bind user image picturebox to user image column

    Lecture 441 Write the code to verify user entered password

    Lecture 442 Limit password textbox chars and add guard to …

    Lecture 443 #### Section intro 8 ### - Using "Login" Form by Main Form

    Lecture 444 Show users list form within main form

    Lecture 445 Show login form at App startup

    Lecture 446 Write the "Exit Button" code in login form

    Lecture 447 Saving user login info in App settings

    Lecture 448 Show login user image & name in main form

    Lecture 449 Finalize login form coding!

    Lecture 450 #### Section intro 9 ### - Project 1: Data Entry Form with Login data

    Lecture 451 Create "Product List" database in SQL Server

    Lecture 452 Add sample data in SQL for Product List table

    Lecture 453 Add "Product List" table to dataset in our Project

    Lecture 454 Add Product List data entry form

    Lecture 455 Design the Product List form

    Lecture 456 Write the code for Product List form to save data

    Lecture 457 Add value to the "User Name" & "User Id" labels

    Lecture 458 Add value to the "System Date" & "System Time" labels

    Lecture 459 Connect Product List form to the main form

    Lecture 460 Add guard & protection to codes by "Try" Structure

    Lecture 461 Add the background image to the main form

    Section 19: Pro - Backup &Restore Data

    Lecture 462 Intro - Backup & Restore Data

    Lecture 463 Download projects and files of this course

    Lecture 464 Steps to add the backup & restore to VB.Net apps

    Lecture 465 #### Section intro 1 ### - Creating the sample database

    Lecture 466 Create the sample database in SQL Server

    Lecture 467 Add sample data and test our SQL table

    Lecture 468 #### Section intro 2 ### - Connecting SQL Db to VB.Net

    Lecture 469 Add new project in VB.net

    Lecture 470 Add Table Adapter to Dataset and connect it to SQL

    Lecture 471 Finish Adding Table Adapter to Dataset

    Lecture 472 Add Datagrid view to form

    Lecture 473 #### Section intro 3 ### - Backup Database in SQL

    Lecture 474 Simple database backup in SQL Server

    Lecture 475 Advance database backup in SQL Server

    Lecture 476 SQL script to make a database backup in SQL Server

    Lecture 477 #### Section intro 4 ### - Restore Database in SQ

    Lecture 478 Restore database from SQL internal backup list

    Lecture 479 Restore database from SQL backup file

    Lecture 480 Advance topics of database restore in SQL Server

    Lecture 481 SQL script to restore a database backup in SQL Server

    Lecture 482 #### Section intro 5 ### - Run SQL Backup Query in VB.Net

    Lecture 483 Add "SQL command" & "SQL connection" to VB.net code

    Lecture 484 Add 6 steps to run SQL Query in VB.Net code

    Lecture 485 Add backup script to run in VB.net

    Lecture 486 Change backup file name & path and … in VB.Net

    Lecture 487 #### Section intro 6 ### - Run SQL Restore Query in VB.Net

    Lecture 488 Add restore script to run in VB.Net

    Lecture 489 Advance topics about restore command in VB.net code

    Section 20: Project -> Pro Backup Form

    Lecture 490 Add backup form to VB.net project

    Lecture 491 Design backup form in VB.net

    Lecture 492 VB code for "Browse" & "Exit" Buttons

    Lecture 493 VB code to generate the backup file name

    Lecture 494 Add empty backup folder name guard to "Browse" Button

    Lecture 495 VB code for "Backup & Exit" Button

    Lecture 496 Add empty backup file name guard to "Backup" Button

    Lecture 497 Show message after creating the SQL backup in VB

    Lecture 498 Show backup progress panel while backing up database

    Lecture 499 VB.net code to exit the backup form after backup process

    Section 21: Project -> Pro Restore Form

    Lecture 500 Add restore form to VB.net project

    Lecture 501 Design restore form in VB .net

    Lecture 502 VB code for "Browse" & "Exit" Buttons

    Lecture 503 Add empty backup file name guard to "Browse" Button

    Lecture 504 Start writing the "Restore" button code

    Lecture 505 Complete "Restore" button code

    Lecture 506 Add database exist checker to "Restore" button

    Lecture 507 Show "Backup" & "Restore" forms from main form

    Section 22: Pro - SQLAggregates

    Lecture 508 Intro - SQL Aggregates

    Lecture 509 Download projects and files of this course

    Lecture 510 #### Section intro 1 ### - Sample Database in SQL

    Lecture 511 Create the sample database in SQL Server

    Lecture 512 Add sample data and test our SQL table

    Lecture 513 #### Section intro 2 ### - Connecting SQL Db to VB.Net

    Lecture 514 Add new project in VB.net

    Lecture 515 What is SQL ADO.Net technology?

    Lecture 516 Add Table Adapter to Dataset and connect it to SQL

    Lecture 517 Finish Adding Table Adapter to Dataset

    Lecture 518 Add Datagrid view to form

    Lecture 519 Connection String & configuring Tableadapter query

    Lecture 520 #### Section intro 3 ### - COUNT Aggregate Function

    Lecture 521 Using COUNT aggregate function in SQL Editor

    Lecture 522 Add new aggregate query to tableadapter

    Lecture 523 Add COUNT function to tableadapter in VB. Net

    Lecture 524 Using the COUNT query in VB.Net form

    Lecture 525 Working the "GetvalueorDefault" method

    Lecture 526 #### Section intro 4 ### - SUM Aggregate Function

    Lecture 527 Using SUM aggregate function in SQL Editor

    Lecture 528 Add SUM function to tableadapter in VB .Net

    Lecture 529 Using the SUM query in VB.Net form

    Lecture 530 #### Section intro 5 ### - AVG Aggregate Function

    Lecture 531 Using AVG aggregate function in SQL Editor

    Lecture 532 Add AVG function to tableadapter in VB

    Lecture 533 Using the AVG query in VB.net form

    Lecture 534 #### Section intro 6 ### - MIN Aggregate Function

    Lecture 535 Using MIN aggregate function in SQL Editor

    Lecture 536 Add MIN function to tableadapter in VB

    Lecture 537 Using the MIN query in VB.net form

    Lecture 538 #### Section intro 7 ### - MAX Aggregate Function

    Lecture 539 Using MAX aggregate function in SQL Editor

    Lecture 540 Add MAX function to tableadapter in VB.net

    Lecture 541 Using the MAX query in VB. Net form

    Lecture 542 #### Section intro 8 ### - Condition in Aggregate for Numeric Columns

    Lecture 543 Add condition to aggregate in numeric columns in SQL editor

    Lecture 544 Add condition to aggregate in numeric columns in TableAdapter

    Lecture 545 Use condition with aggregate query in VB form

    Lecture 546 #### Section intro 9 ### - Condition in Aggregate for Text Columns

    Lecture 547 "Equal" & "LIKE" operators with aggregate in text columns in SQL editor

    Lecture 548 "Between" operator with aggregate in text columns in SQL editor

    Lecture 549 Logical operators with aggregate in text columns in SQL editor

    Lecture 550 Add condition to aggregate in text columns in TableAdapter

    Lecture 551 Use condition with aggregate query in VB.Net form

    Section 23: Pro - Advance ADO.Net &ComboBox

    Lecture 552 Download projects and files of this course

    Lecture 553 What is ComboBox and SQL in VB.Net?

    Lecture 554 #### Section intro 1 ### - Build ComboBox Db in SQL

    Lecture 555 Create SQL Database for combobox

    Lecture 556 Add table and sample data for combobox in SQL Db

    Lecture 557 #### Section intro 2 ### - Connect ComoBox Db to VB.Net App

    Lecture 558 Create ComboBox Project in VB. Net

    Lecture 559 Add Dataset to combobox project in VB .Net

    Lecture 560 Add Table Adapter to Dataset and connect it to SQL

    Lecture 561 Create Select query with query builder in table adapter

    Lecture 562 Configure SQL Query in Table Adapter & connection string in depth

    Lecture 563 #### Section intro 3 ### - Simple ComboBox in VB.Net & SQL

    Lecture 564 Main parts of ComboBox

    Lecture 565 Simple binding of combobox to database

    Lecture 566 VB.Net code to load the data by tableadapter

    Lecture 567 Binding multiple combobox to database

    Lecture 568 Using Selected text and Selected index of combobox

    Lecture 569 Using the selected value in combobox

    Lecture 570 #### Section intro 4 ### - Advance ComboBox in VB.Net & SQL

    Lecture 571 Add group id column to combobox items table in SQL Db

    Lecture 572 Add advance combobox form to VB .Net windows form project

    Lecture 573 Add group id column to datatable inside the VB projec

    Lecture 574 Bind multiple ComboBoxes to datatable by the bindingsource

    Lecture 575 Filter multiple ComboBoxes items by group id

    Lecture 576 In depth filtering the combobox items

    Lecture 577 Sort the items of combobox by the bindingsource

    Lecture 578 Sort & Filter the Combo Items by VB.Net code

    Lecture 579 Speed up form load by excluding unused combo items in form load

    Lecture 580 #### Section intro 5 ### - ComboBox Items Form in VB.Net

    Lecture 581 Add combobox items manager form to VB .Net project

    Lecture 582 Add and Design DataGridView in Combo items form

    Lecture 583 Write VB. Net code for save button

    Lecture 584 Show message after saving records

    Lecture 585 Add delete button to DataGrid View

    Lecture 586 Send selected combo group id to Combo items form

    Lecture 587 Load the combobox items based on selected combobox

    Lecture 588 Manually "Add,Delete,Update" the combobox items by combo items form

    Lecture 589 #### Section intro 6 ### - Advance ADO.Net & Datatable

    Lecture 590 Datatable structure in depth

    Lecture 591 Get the row and column count of datatable

    Lecture 592 Get single record Rowstate in datatable

    Lecture 593 Get multiple records Rowstate in datatable

    Lecture 594 Using "AcceptChanges" method of datatable

    Lecture 595 Get the value of single row and column

    Lecture 596 Get the value of multiple rows and single column

    Lecture 597 Write the value inside single row and single column

    Lecture 598 Write the value inside multiple rows and single column

    Lecture 599 #### Section intro 7 ### - Add New Item to ComboBox

    Lecture 600 Add the new item to combobox by VB .Net code

    Lecture 601 Close the form after adding new combo item

    Lecture 602 #### Section intro 8 ### - Binding ComboBox to the Db

    Lecture 603 Add customer info table to SQL database

    Lecture 604 Add customer info table to VB.Net App

    Lecture 605 Add controls on form to customer info datatable

    Lecture 606 Bind ComboBox text to datatable

    Lecture 607 Bind ComboBox selected value to datatable

    Lecture 608 Advance topic of ComboBox binding

    Section 24: Pro - SQLCRUD in VB

    Lecture 609 Download projects and files of this course

    Lecture 610 #### Section intro 1 ### - SQL CRUD operations in SSMS

    Lecture 611 What is the Crud operations?

    Lecture 612 Using the SQL INSERT query in simple method

    Lecture 613 Using INSERT query without column list

    Lecture 614 Advance topics of INSERT query ( Adding Date,Text,Numbers)

    Lecture 615 Add NULL values by INSERT query

    Lecture 616 Auto generate Insert query in SQL Management Studio (SSMS)

    Lecture 617 Using the SQL Update query in simple method

    Lecture 618 Advance topics of UPDATE query & Auto generate it

    Lecture 619 Use UPDATE method with custom column list

    Lecture 620 Using NULL value with UPDATE method

    Lecture 621 Using the SQL DELETE query

    Lecture 622 #### Section intro 2 ### - Build VB.Net App for SQL CRUD

    Lecture 623 Add & design CRUD form in VB. Net project

    Lecture 624 Bind the DGV to datatable and load the data from SQL db

    Lecture 625 #### Section intro 3 ### - SQL CRUD in VB.Net App

    Lecture 626 Use default INSERT query of TableAdapter to add the new record

    Lecture 627 Add new INSERT query to TableAdapter and used it

    Lecture 628 Get the last inserted ID in DataBase after inserting the new record

    Lecture 629 Use default DELETE query of TableAdapter to delete the record

    Lecture 630 Customize the default DELETE query of TableAdapter

    Lecture 631 Add our new DELETE query to TableAdapter and use it

    Lecture 632 Show confirm Message box to user before deleting a the record

    Lecture 633 Show the InputBox to user to edit the value in edit button

    Lecture 634 Use default UPDATE query of TableAdapter to save changes

    Lecture 635 Customize the default UPDATE query of TableAdapter

    Lecture 636 Add new UPDATE query to TableAdapter for updating the record

    Lecture 637 #### Section intro 4 ### - Finalizing the VB.Net CRUD Project

    Lecture 638 Reload the data after : New,Edit and Delete operations

    Lecture 639 Connect the "Combo items CRUD" form to the main form

    Lecture 640 Finalize connecting the "Combo items CRUD" form

    Section 25: Pro - Oracle VirtualBox

    Lecture 641 Intro VirtualBox

    Lecture 642 What is Virtual Machine?

    Lecture 643 Download and install Oracle VirtualBox

    Lecture 644 Quick tour of VirtualBox environment

    Lecture 645 Add new Windows 7 virtual machine to VirtualBox

    Lecture 646 Working with the settings of Virtual Machine

    Lecture 647 Delete virtual machine and settings from VirtualBox

    Lecture 648 Preparing Installing Windows 7 64 bit in VirtualBox

    Lecture 649 Host key in virtual machine

    Lecture 650 Installing Windows 7 64 bit in VirtualBox

    Lecture 651 Quick working with Virtual machine and menus

    Lecture 652 Installing Guest addition in virtual Windows 7

    Lecture 653 Share folder between your windows and virtual windows part 1

    Lecture 654 Share folder between your windows and virtual windows part 2

    Lecture 655 Share folder between your windows and virtual windows part 3

    Lecture 656 Share clipboard between our Windows and virtual machine

    Lecture 657 Backup & Restore Virtual Machine part 1

    Lecture 658 Backup & Restore Virtual Machine part 2

    Lecture 659 Backup & Restore Virtual Machine part 3

    Section 26: Pro - Publishing SQL&VB.Net Apps

    Lecture 660 Intro - Publishing SQL & VB.Net Apps

    Lecture 661 Download projects and files of this course

    Lecture 662 #### Section intro 1 ### - Build Sample Project to Publish

    Lecture 663 Create SQL Database for shop

    Lecture 664 Add sample data in SQL for product list

    Lecture 665 Create shop project in VB. Net to use SQL Database

    Lecture 666 Add Dataset and table-adapter to VB .net project

    Lecture 667 Working with query builder in Tableadapter

    Lecture 668 Add Datagrid view to shop form

    Lecture 669 Using the VirtualBox for VB.net App testing!

    Lecture 670 #### Section intro 2 ### - Test an App in VirtualBox

    Lecture 671 Open shop project for publishing

    Lecture 672 Copy App files in virtual windows 7

    Lecture 673 How to Install .Net framework 2.0 on virtual machine

    Lecture 674 Install .Net framework 4 on virtual Windows 7

    Lecture 675 Change application .net framework version to 4

    Lecture 676 #### Section intro 3 ### - 1st Method -> Manual Publishing

    Lecture 677 Different methods for publishing Apps With VB. Net & SQL

    Lecture 678 Method 1 - Download SQL Server 2014 express with SSMS

    Lecture 679 Method 1 - Copy SQL installation file to Vbox & start installation

    Lecture 680 Method 1 - Define dedicated SQL name & user & pass

    Lecture 681 Method 1 - Install SQL 2014 express & SSMS in Windows 7

    Lecture 682 Method 1 - Using SQL management studio in virtual machine

    Lecture 683 Method 1 - Using SQL Server configuration manager

    Lecture 684 Method 1 - What is Application config file?

    Lecture 685 Method 1 - Use dot (.) in SQL Server name

    Lecture 686 Method 1 - Copy shop SQL Database to Vbox

    Lecture 687 Method 1 - Attach Shop SQL Db in Windows 7 to SQL

    Lecture 688 Method 1 - Finalize publishing of VB.Net App

    Lecture 689 Method 1 - Protect SQL login info in Users Pc

    Lecture 690 Method 1 - Add new connection to Application settings

    Lecture 691 Method 1 - Change connection of tableadapter in VB code

    Lecture 692 Method 1 - Switching between Connections in VB code

    Lecture 693 #### Section intro 4 ### - 2nd Method -> SQL User Instance

    Lecture 694 Add New VM & Install .net framework 4 and …

    Lecture 695 - Download SQL Server 2014 express

    Lecture 696 Add dedicated SQL Server name & user & pass

    Lecture 697 Prepare Installing SQL Server Express

    Lecture 698 - Install SQL 2014 express in Windows 7

    Lecture 699 Move VB.Net project to Drive "E"

    Lecture 700 Copy SQL Db inside VB.Net project

    Lecture 701 SQL Connection String in Depth

    Lecture 702 SQL Connection String in Depth

    Lecture 703 Connection string to use SQL user instance

    Lecture 704 - Finish connecting SQL Db file to SQL user instance

    Lecture 705 What is "|DataDirectory|" in connection?

    Lecture 706 New connection string with TableAdapter

    Lecture 707 Solve "database already exist" err for connecting to SQL user instance

    Lecture 708 Get the list of SQL user instance in SSMS

    Lecture 709 Connecting to SQL user instance in SSMS

    Lecture 710 Detach & delete Db from SQL user instance

    Lecture 711 Attach SQL Db file to SQL user instance by initial catalog

    Lecture 712 Attach SQL Db file to SQL user instance by empty initial catalog

    Lecture 713 Solve in depth "database already exist" error by initial catalog

    Lecture 714 Solve in depth "database already exist" err by empty initial catalog

    Lecture 715 Different types of initial catalog in connection string

    Lecture 716 Empty initial catalog for publishing SQL app by SQL user instance

    Lecture 717 Not empty initial catalog for publishing SQL app by SQL user instance

    Lecture 718 Make easier 2nd method publish steps & development

    Lecture 719 #### Section intro 5 ### - 3rd Method -> Normal SQL Instance

    Lecture 720 Add connection to SQL normal instance

    Lecture 721 Adding permission to SQL Db folder

    Lecture 722 Check effect of auto connecting Db to SQL normal instance

    Lecture 723 Publish App with SQL authentication and SQL normal instance

    Lecture 724 Method 3 - Publish App with Windows authentication and SQL normal instance

    Lecture 725 Method 3 - Make easier 3rd method publish steps and development

    VB. Net programmers who want to work with SQL Server in Visual Basic code!,VB. Net programmers who want to Learn Quickly SQL Server in VB. Net code!,VB. Net programmers who want to make more money by Using SQL Server in Visual Basic !