Here is a sample program that is being provided by my close friend, business partner and fellow software engineer Sir Larry Dave Emol. He created this program using Microsoft Visual Basic 6 to display the record in a web browser.
I am currently accepting programming work, IT projects, school and application development, programming projects, thesis and capstone projects, IT consulting work, computer tutorials, and web development work kindly contact me in the following email address for further details. If you want to advertise on my website kindly contact me also in my email address also. Thank you.
My email address is the following jakerpomperada@gmail.com, jakerpomperada@aol.com, and jakerpomperada@yahoo.com.
My mobile number here in the Philippines is 09173084360.
My telephone number at home here in Bacolod City, Negros Occidental Philippines is +63 (034) 4335675.
Here in Bacolod I also accepting computer repair, networking and Arduino Project development at a very affordable price.
My personal website is http://www.jakerpomperada.com.
Add this control to your Visual Basic 6
Program Listing
FORM CODES
Sub LOAD_DATA()
Dim i As Long
Call SQLDB(Me.AdoCon, "select distinct Namex from tblInfo Order by Namex")
Me.WebBrowser1.Navigate2 "About:Blank"
Do While Me.WebBrowser1.ReadyState <> READYSTATE_COMPLETE
DoEvents
Loop
With WebBrowser1.Document
.Write ("<button>Save</button>")
.Write ("<HTML><head></head><style type='text/css'> body,td{font-family: Tahoma;} body,td{font-size:20px;} button{padding:30px; Background-color: blue; Margin: 10px; Color: #fff;}</style>")
.Write ("<BODY Scroll=Yes oncontextmenu='return false';>")
.Write ("<TABLE WIDTH=100% BORDER=1 BORDERCOLOR=#215DC6 CELLPADDING=1 CELLSPACING=1>")
.Write ("<thead>")
.Write ("<TR>")
.Write ("<TH BGCOLOR=pink><B>Namex </B></TH>")
.Write ("</TR>")
.Write ("</thead>")
Do While AdoCon.Recordset.EOF <> True
i = i + 1
.Write ("<TR>")
.Write ("<TD bgcolor=powderblue><FONT FACE=tahoma SIZE=5>" & AdoCon.Recordset.Fields("Namex").Value & "</TD>")
.Write ("</TR>")
AdoCon.Recordset.MoveNext
Loop
.Write ("</TABLE>")
.Write ("</BODY>")
.Write ("</HTML>")
WebBrowser1.Document.Script.Document.Clear
WebBrowser1.Document.Script.Document.Close
End With
End Sub
Private Sub Form_Activate()
Call LOAD_DATA
End Sub
MODULE CODES(DB Connection)
Option Explicit
Public Function AppDir() As String
If Right$(App.Path, 1) = "\" Then
AppDir = App.Path
Else
AppDir = App.Path & "\"
End If
End Function
Public Sub SQLDB(adoObj As Adodc, AdoRec As String) 'for SQL Recordsource
'Loads the database and provides the database password
adoObj.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & AppDir & "Tutorial.mdb;Persist Security Info=False;Jet OLEDB:Database Password = "
'Sets the command type to Table
adoObj.CommandType = adCmdText
'Loads the source table of info
adoObj.RecordSource = AdoRec
'refreshes database status
adoObj.Refresh
End Sub
Sub LOAD_DATA()
Dim i As Long
Call SQLDB(Me.AdoCon, "select distinct Namex from tblInfo Order by Namex")
Me.WebBrowser1.Navigate2 "About:Blank"
Do While Me.WebBrowser1.ReadyState <> READYSTATE_COMPLETE
DoEvents
Loop
With WebBrowser1.Document
.Write ("<button>Save</button>")
.Write ("<HTML><head></head><style type='text/css'> body,td{font-family: Tahoma;} body,td{font-size:20px;} button{padding:30px; Background-color: blue; Margin: 10px; Color: #fff;}</style>")
.Write ("<BODY Scroll=Yes oncontextmenu='return false';>")
.Write ("<TABLE WIDTH=100% BORDER=1 BORDERCOLOR=#215DC6 CELLPADDING=1 CELLSPACING=1>")
.Write ("<thead>")
.Write ("<TR>")
.Write ("<TH BGCOLOR=pink><B>Namex </B></TH>")
.Write ("</TR>")
.Write ("</thead>")
Do While AdoCon.Recordset.EOF <> True
i = i + 1
.Write ("<TR>")
.Write ("<TD bgcolor=powderblue><FONT FACE=tahoma SIZE=5>" & AdoCon.Recordset.Fields("Namex").Value & "</TD>")
.Write ("</TR>")
AdoCon.Recordset.MoveNext
Loop
.Write ("</TABLE>")
.Write ("</BODY>")
.Write ("</HTML>")
WebBrowser1.Document.Script.Document.Clear
WebBrowser1.Document.Script.Document.Close
End With
End Sub
Private Sub Form_Activate()
Call LOAD_DATA
End Sub
MODULE CODES(DB Connection)
Option Explicit
Public Function AppDir() As String
If Right$(App.Path, 1) = "\" Then
AppDir = App.Path
Else
AppDir = App.Path & "\"
End If
End Function
Public Sub SQLDB(adoObj As Adodc, AdoRec As String) 'for SQL Recordsource
'Loads the database and provides the database password
adoObj.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & AppDir & "Tutorial.mdb;Persist Security Info=False;Jet OLEDB:Database Password = "
'Sets the command type to Table
adoObj.CommandType = adCmdText
'Loads the source table of info
adoObj.RecordSource = AdoRec
'refreshes database status
adoObj.Refresh
End Sub
No comments:
Post a Comment