ASP.NET

Sample Login Form Code Assume that DLL & BLL refrences are Provided. If Not then Put Below Code First " Imports BLL " - It Will Import BLL to your Application Public Class FrmLogin #Region "<< Variable >>"     Dim objUserMaster As User_Master     Dim objUserMasterProperty As User_MasterProperty     Dim objGlb As New GlobalVariable     Dim objCompMaster As CompanyMaster #End Region #Region "<< Button Click >>"     Private Sub btnCancel_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnCancel.Click         Me.Close()     End Sub     Private Sub btnLogin_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnLogin.Click         Try             If Me.txtUser_Name.Text <> "" Then                 Dim objMST_COMPANY As New MST_COMPANY                 Dim dt As DataTable                 dt = objMST_COMPANY.GetData("USERNAME='" + txtUser_Name.Text + &

Hi Everyone I hope you enjoyed Lots with Our How to Create 3 Tier Vb.Net Desktop Application Article Part 1. Now Lets Continue with Part 2 that will show you how you can build up BLL (Business Logic Code). BLL Code ScheduleMaster.Vb Code '********* Function Class ********************** #Region " Data Access <<Imported NameSpaces>> " Imports DLL.Kcon.Practices.PrivateLibrary.DataLib Imports System.Data.Common #End Region #Region " <<Namespace, Class and Functions>> " Namespace Kcon.Practices.PrivateLibrary     Public Class Schedule_Master #Region " Variable Declaration "         Private objDAL As New DataAccess #End Region #Region " Stored Procedures Names "         Private PRCINS As String = "Schedule_MasterIns"         Private PRCUPD As String = "Schedule_MasterUpd"         Private PRCDEL As String = "Schedule_MasterDel"         Private PRCGETBYID As String = "Schedule_Maste

3 Tiers are  DLL (Data Logic Layer) BLL (Business Logic Layer ) UI/UX (User Interface) DLL Code DataAccess.vb Code #Region "Data Access <<Imported NameSpaces>>" Imports System.Data.Odbc Imports System.Data.SqlClient Imports System.Data.OleDb Imports System.Xml Imports System.Data.Common Imports System.Text Imports System.Configuration #End Region #Region "Data Access <<Namespace, Class, Functions, Proeprties, etc.>>" Namespace Kcon.Practices.PrivateLibrary.DataLib     Public Class DataAccess #Region "Private Variables"         Private databaseProviderFactory As DbProviderFactory         Private databaseConnection As DbConnection         Private connectionString As String         Private providerName As String         Private databaseTransaction As DbTransaction         Private transactionIsolationLevel As IsolationLevel         #End Region #Region "Private subroutine/Functions"         P