Posts

Setting up Github Repository on Visual Studio 2015

Image
1 . Create an account at https://github.com/ 2 . Download and install github extension for visual studio at https://visualstudio.github.com/ . Be sure that Visual Studio IDE is closed. 3 . Open Visual Studio 2015 > Tools > Options > Source Control. Change control plug-in to “Microsoft Git Provider”. 4 .  On team explorer window under Github node, click sign in. Use your github account created on step 1. 5 . Once signed in, create your github repository. 6 . Create your project. 7 . On Solution Explorer window, right click the solution and choose commit. (Commit means your source code will be updated to your local repository.) 8 . On Team Explorer window, enter your comments and click commit. 9 ....

How to make a simple CRUD (Create,Retrieve,Update,Delete) in VB.NET

Image
1. Create database in MS SQL. 2. Add new table and create necessary columns. Then save. 3. Create a new project in visual studio and choose "windows form applications". 4. Add new module. We will put here the public connection string of our simple CRUDE program. 5. Place the code below. 'NAMESPACES FOR SQL Imports System.Data.Sql Imports System.Data.SqlClient Imports System.Data Module Module1     'PUBLIC VARIABLES FOR SERVERNAME,DATABASENAME,CONNECTION STRING AND ETC.     Public SERVER_NAME As String     Public DATABASE_NAME As String     Public SQL As String     Public CON As New SqlConnection()     Public SQLCMD As New SqlCommand()     Public SQLADAPTER As New SqlDataAdapter     Public DR As System.Data.SqlClient.SqlDataReader     Public Sub MAIN()         SERVER_NAME = "SAMSUNG-PC"  'INSTANCE NAME IN ...