Generate random db record output. This is classic asp script. VB.NET version is coming soon < % @ Language=”VBScript” %> < % Option Explicit %> < !DOCTYPE html PUBLIC “-//W3C//DTD XHTML 1.0 Strict//EN” “http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd”> <html xmlns=”http://www.w3.org/1999/xhtml” xml:lang=”en”> <head runat=”server”> <title> <link href=”Styles/Site.css” rel=”stylesheet” type=”text/css” /> </head> <body> <div class=”page”> <div class=”main”> <div style=”width: 900px; text-align: […]
Author Archive
Find missing record using query
After running the query to update table records the record(s) is missing. Run this query to find the missing record. SELECT Table1.column FROM Table1 LEFT JOIN Table2 ON Table1.column = Table2.Column WHERE Table2.column is NULL; * Replace Table1 and *2 with your table names
VB.NET – Login form – create user session
This post will guide you through designing the login form with SQL backend and creating a user session. Learn more about new promotions! login.aspx login.aspx (markup code) <%@ Page Title=”” Language=”VB” MasterPageFile=”~/Default.Master” AutoEventWireup=”false” CodeFile=”login.aspx.vb” Inherits=”_login” %> <asp:Content ID=”HeaderContent” runat=”server” ContentPlaceHolderID=”HeadContent”> </asp:Content> <asp:Content ID=”BodyContent” runat=”server” ContentPlaceHolderID=”MainContent” > <table border=”0″ cellpadding=”1″ cellspacing=”0″> <tr> <td colspan=”2″>Login:</td> </tr> <tr> […]