ASP.NET VB WebApp Starter Guide

ASP.NET VB WebApp Starter Guide

🚀 Getting Started

Database Setup

  1. Open SQL Server Management Studio
  2. Connect to LocalDB\SQLEXPRESS
  3. Create new database: demo

Project Setup

Download Starter Project
Extract and open webapp_vb_starter.sln

Video Demonstration

Video Timeline:
  • 0:00 - Database setup
  • 01:31 - Automation process
  • 02:12 - CRUD operations demo

✨ Core Features

Database Operations

    Protected Sub create_sql_table()
        Dim iosql As New iosc.iosql
        If iosql.SQLCheckTableExist(“table1”, ConnStr) = False Then
            iosql.createiotable(ConnStr, “table1”, iosql.Ret_CreateTblStr(“table1”, "ID:id,Data1:s,Num1:i,Num2:i,Total:i"))
        End If
    End Sub

CRUD Operations

  • Add records
  • Edit entries
  • GridView display

Automation

    Protected Function sumup(ByVal input1 As String, ByVal input2 As String) As Integer
        Return CInt(input1) + CInt(input2)
    End Function

Configuration

web.config Settings
<connectionStrings>
    <add name="ConnStr" 
         connectionString="Server=.\SQLEXPRESS;
         Database=demo;
         Integrated Security=True;" 
         providerName="System.Data.SqlClient"/>
</connectionStrings>
Ensure SQL Server Express is running and adjust connection string as needed