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

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 !
Homepage

https://www.udemy.com/course/quick-sql-in-vb-net-database-apps-in-visual-basic-sql/