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

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 !