Winards Channel

>>Show Message Box taken from Textbox with Command Button Visit our Channel In this tutorial we will create application that will show a message box taken from textbox with command button. The script will placed at the button click (one click of course).

Visit our Channel Before create a database, you have to decide the following : Database name Database file path We will create a database Database name: HOSPITAL Database file path D:\HOSPITAL In this tutorial we will learn how to create a SQL Server 2014 database  in an easy way. Watch the tutorial video carefully, if any question please write on comments below.

Visit Our Channel Here we will create a table in 2 ways : Using SSMS task Using Query Syntax In this tutorial only give simple table with 2 data type, Varchar and Int (Integer). For more explanation about data type we will learn in other time. Watch the tutorial video carefully, if any question please write on comments below. 1. Using SQL Server Management Studio Like shown picture above, just right click Tables on the HOSPITAL database tree, choose New Table. Then it will appear 3 columns for create new table. Just fill the columns, field/column name, data type and don't forget if you want to not allow nulls you have to type default value for your field/column. If it's done click Save Button on Toolbar or click menu File-Save. 2. Using Query Syntax To create table using SQL Syntax, first click New Query button on Toolbar, then you type the syntax like picture above. Then just click Execute button on Toolbar or just hit F5 on keyboard. For...

Visit our Channel In this tutorial we will create an application to testing the SQL Server 2014 database connection. We will use connection string in the connection script. This part of lesson is very important for you which want to learn database programming. Before you can manipulate the database (SQL) using Windows form, you have to know how to connect them to the database. There is several steps to connecting to the database, that is: Create Visual Studio 2013 New Project Choose Windows Form Application Add Command Button on the Form Add Module to the Project Write command script to each Object Test the application >> Create Visual Studio 2013 New Project First, you have to open Visual Studio 2013, click New Project. Choose Windows Form Application. Then will appear New Project with default 1 Form on the workspace. >> Add Command Button on the Form Add a command button control take from Tool Box to the form object. >> Add Module to th...

vjhbnbn

yugfjhgjhg

In this tutorial we will learn how to connect a SQL Server database using SSMS (SQL Server Management Studio). SSMS is a tool to control directly to the database using menu and queries. Just be careful if you use this tool because you can update, insert and remove data in the database. If you want to use this tool you should backup the database first. So if you make mistake you just restore your database backup, it save. This tutorial is intended for basic knowledge about SQL Server 2014 client user. Enjoy the video of course. :)