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:07 - Database setup
  • 00:41 - Project setup
  • 01:59 - 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