VB.NET: MS-Access Interaction Tutorial (Part I)

miCRoSCoPiC^eaRthLinG

May 15 2006, 03:01 PM

VB.NET - MS-Access Interaction Tutorial

[/tab]I got down to writing this tutorial because of this certain question that Dhanesh posted on our forums here. This tutorial will attempt to show you how to:

Create a MS-Access Database
Create/Edit/Delete Tables in it
Access it and Add/Edit/Update data in those tables

all with VB.NET.

Note:[tab]This is not a beginner's tutorial and I'll assume you know all the basics of creating WinForm based applications using VS.NET. The screen-shots provided are from VS.NET 2005 - but you shouldn't face any difficult even if you're using VS.NET 2003. The functionality is essentially the same.

[/tab]We will start by creating a blank Windows Application project called MS-AccessTest.

Creating a MS-Access Database
[tab]Microsoft didn't provide us with any easy modern method of creating an Access Database. No such classes are provided in the .NET Framework and hence we'll have to fall back onto an old library routine that came along with the older genre of Visual Studio. As for accessing a database and modifying data in it, we can conveniently use the OleDB Wrapper.

[/tab]For now, right-click on the project name in the Solution Explorer and select Add Reference. This will bring up the Add Reference dialog box. Next select the COM tab and scroll down till you find a library named Microsoft ADO Ext. 2.8 for DLL and Security as shown in the screen-shot.

Click OK to add the reference to this dll. The library should show up as ADOX in your References in the Solution Explorer, if you're using VS.NET 2003. Else you can spot it under the References tab under Project Properties in VS.NET 2005.

[tab]Next, we'll create our own class to encapsulate all database related routines. In the Solution Explorer, right-click on the solution name and select Add > Class. Name this class Database.We'll create a function called CreateDatabase( FileName ) that'll take the FileName as a parameter and create a blank database at the given location.

Here's the code for the function - it returns True or False depending on the success/failure in creating the database. We use the Create method which can be found under the ADOX.Catalog class to create the database. This method takes the standard OleDB connection string (as shown in oConnect) and creates a blank database with the file name passed to it as Data Source.

CODE

    'Method to create a blank database
    Public Function CreateDatabase(ByVal FileName As String) As Boolean

        'Instantiate the ADOX Object
        Dim ADOXCatalog As ADOX.Catalog = New ADOX.Catalog
        Dim oConnect As String

        'Setup the connection string
        oConnect = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & FileName

        ' Try creating the database
        Try

            'Create the database
            ADOXCatalog.Create(oConnect)

        Catch ex As System.Runtime.InteropServices.COMException
        Catch ex As Exception

            'Show error message and return failure
            MsgBox(ex.Message & vbCrLf & ex.StackTrace)
            Return False

        Finally

            'Dispose the object
            ADOXCatalog = Nothing

        End Try

        'Return success
        Return True

    End Function

Create/Edit/Delete Tables
[/tab]Our next job is to define some tables in this database. For this we use the standard OleDB Data Provider.You need to have a little prior knowledge of SQL to understand this - although syntactically this is very simple. We start by defining a process called CreateTable(). We'll create a simple table named accessTest for demonstration purposes. This will have just two columns:

ID - which is of the Data Type COUNTER, which basically means an Auto Incrementing Integer field
Name - A TEXT field of length 50, which will store the name of a person.

Moreover, we'll set the ID field as the Primary Key.The code for this function follows:

CODE

    Public Function CreateTable(ByVal FileName As String) As Boolean

        'Define the connectors
        Dim oConn As OleDbConnection
        Dim oComm As OleDbCommand
        Dim oConnect, oQuery As String

        'Define connection string
        oConnect = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & FileName & ";User ID=Admin;Password="

        'Define the query string the creates the table
        oQuery = "CREATE TABLE accessTest ( ID Counter," & _
                                           "Name TEXT(50) NOT NULL," & _
                                           "PRIMARY KEY(ID) )"

        ' Instantiate the connectors
        oConn = New OleDbConnection(oConnect)
        oComm = New OleDbCommand(oQuery, oConn)

        'Try connecting and crate the table
        Try

            'Open the connection
            oConn.Open()

            'Perform the Non-Query
            oComm.ExecuteNonQuery()

            'Close the connection
            oConn.Close()

        Catch ex As OleDb.OleDbException
        Catch ex As Exception

            'Show error message and return failure
            MsgBox(ex.Message & vbCrLf & ex.StackTrace)
            Return False

        Finally

            'Dispose the connector objects
            If Not (oConn Is Nothing) Then
                oConn.Dispose()
                oConn = Nothing
            End If
            If Not (oComm Is Nothing) Then
                oComm.Dispose()
                oComm = Nothing
            End If

        End Try

        'Return success
        Return True

    End Function

[tab]Next we've to define some methods to READ data from this table and return to us as a DataSet - which can be easily bound to a DataGrid to display the data directly on screen. Once again - we define a method called FetchData() to facilitate this. We use the standard connectors that we'd used in the above procedure, but along with that we introduce a new object called a DataAdapter - which is used to read the whole table and place the data into the DataSet.

CODE

    Public Function FetchData(ByVal FileName As String) As DataSet

        'Define the connectors
        Dim oConn As OleDbConnection
        Dim oComm As OleDbCommand
        Dim oData As OleDbDataAdapter
        Dim resultSet As New DataSet
        Dim oConnect, oQuery As String

        'Define connection string
        oConnect = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & FileName & ";User ID=Admin;Password="

        'Query String
        oQuery = "SELECT * FROM accessTest"

        'Instantiate the connectors
        oConn = New OleDbConnection(oConnect)
        oComm = New OleDbCommand(oQuery, oConn)
        oData = New OleDbDataAdapter(oQuery, oConn)

        Try

            'Open connection
            oConn.Open()

            'Fill dataset
            oData.Fill(resultSet, "accessTest")

            'Close connection
            oConn.Close()

        Catch ex As OleDb.OleDbException
        Catch ex As Exception

            'Show error message and exit
            MsgBox(ex.Message & vbCrLf & ex.StackTrace)

        Finally

            'Dispose the connector objects
            If Not (oConn Is Nothing) Then oConn.Dispose()
            oConn = Nothing
            If Not (oComm Is Nothing) Then oComm.Dispose()
            oComm = Nothing
            If Not (oData Is Nothing) Then oData.Dispose()
            oData = Nothing

        End Try

        'Return results
        Return resultSet

    End Function

So far we've created some basic routines to create database/table and fetch data. Now it's time to concentrate on the main interface and come up with a way to display the fetched data on the screen.For this we'll utilize a DataGrid control, as it can be easily bound to the fetched data. On the main form, drop a DataGrid. Also add a DataSet to the main form. We're going to link these two controls and whenever we update the dataset with any data from the database, the datagrid will reflect the changes on screen. Likewise, when data is modified on screen, the changes get reflected in the actual database.

Continued in Part II ...

apurba

Jul 31 2007, 01:48 PM

QUOTE(miCRoSCoPiC^eaRthLinG @ May 15 2006, 08:31 PM)

Create a MS-Access Database
Create/Edit/Delete Tables in it
Access it and Add/Edit/Update data in those tables

all with VB.NET.
Note:[tab]This is not a beginner's tutorial and I'll assume you know all the basics of creating WinForm based applications using VS.NET. The screen-shots provided are from VS.NET 2005 - but you shouldn't face any difficult even if you're using VS.NET 2003. The functionality is essentially the same.

[/tab]We will start by creating a blank Windows Application project called MS-AccessTest.

Creating a MS-Access Database
[tab]Microsoft didn't provide us with any easy modern method of creating an Access Database. No such classes are provided in the .NET Framework and hence we'll have to fall back onto an old library routine that came along with the older genre of Visual Studio. As for accessing a database and modifying data in it, we can conveniently use the OleDB Wrapper.

[/tab]For now, right-click on the project name in the Solution Explorer and select Add Reference. This will bring up the Add Reference dialog box. Next select the COM tab and scroll down till you find a library named Microsoft ADO Ext. 2.8 for DLL and Security as shown in the screen-shot.

CODE

    'Method to create a blank database
    Public Function CreateDatabase(ByVal FileName As String) As Boolean

        'Instantiate the ADOX Object
        Dim ADOXCatalog As ADOX.Catalog = New ADOX.Catalog
        Dim oConnect As String

        'Setup the connection string
        oConnect = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & FileName

        ' Try creating the database
        Try

            'Create the database
            ADOXCatalog.Create(oConnect)

        Catch ex As System.Runtime.InteropServices.COMException
        Catch ex As Exception

            'Show error message and return failure
            MsgBox(ex.Message & vbCrLf & ex.StackTrace)
            Return False

        Finally

            'Dispose the object
            ADOXCatalog = Nothing

        End Try

        'Return success
        Return True

    End Function

ID - which is of the Data Type COUNTER, which basically means an Auto Incrementing Integer field
Name - A TEXT field of length 50, which will store the name of a person.

Moreover, we'll set the ID field as the Primary Key.The code for this function follows:

CODE

    Public Function CreateTable(ByVal FileName As String) As Boolean

        'Define the connectors
        Dim oConn As OleDbConnection
        Dim oComm As OleDbCommand
        Dim oConnect, oQuery As String

        'Define connection string
        oConnect = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & FileName & ";User ID=Admin;Password="

        'Define the query string the creates the table
        oQuery = "CREATE TABLE accessTest ( ID Counter," & _
                                           "Name TEXT(50) NOT NULL," & _
                                           "PRIMARY KEY(ID) )"

        ' Instantiate the connectors
        oConn = New OleDbConnection(oConnect)
        oComm = New OleDbCommand(oQuery, oConn)

        'Try connecting and crate the table
        Try

            'Open the connection
            oConn.Open()

            'Perform the Non-Query
            oComm.ExecuteNonQuery()

            'Close the connection
            oConn.Close()

        Catch ex As OleDb.OleDbException
        Catch ex As Exception

            'Show error message and return failure
            MsgBox(ex.Message & vbCrLf & ex.StackTrace)
            Return False

        Finally

            'Dispose the connector objects
            If Not (oConn Is Nothing) Then
                oConn.Dispose()
                oConn = Nothing
            End If
            If Not (oComm Is Nothing) Then
                oComm.Dispose()
                oComm = Nothing
            End If

        End Try

        'Return success
        Return True

    End Function

CODE

    Public Function FetchData(ByVal FileName As String) As DataSet

        'Define the connectors
        Dim oConn As OleDbConnection
        Dim oComm As OleDbCommand
        Dim oData As OleDbDataAdapter
        Dim resultSet As New DataSet
        Dim oConnect, oQuery As String

        'Define connection string
        oConnect = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & FileName & ";User ID=Admin;Password="

        'Query String
        oQuery = "SELECT * FROM accessTest"

        'Instantiate the connectors
        oConn = New OleDbConnection(oConnect)
        oComm = New OleDbCommand(oQuery, oConn)
        oData = New OleDbDataAdapter(oQuery, oConn)

        Try

            'Open connection
            oConn.Open()

            'Fill dataset
            oData.Fill(resultSet, "accessTest")

            'Close connection
            oConn.Close()

        Catch ex As OleDb.OleDbException
        Catch ex As Exception

            'Show error message and exit
            MsgBox(ex.Message & vbCrLf & ex.StackTrace)

        Finally

            'Dispose the connector objects
            If Not (oConn Is Nothing) Then oConn.Dispose()
            oConn = Nothing
            If Not (oComm Is Nothing) Then oComm.Dispose()
            oComm = Nothing
            If Not (oData Is Nothing) Then oData.Dispose()
            oData = Nothing

        End Try

        'Return results
        Return resultSet

    End Function

Hi,

please give me the advise, how to display the fetch records set.......i am very much thanks full to you.....

please please help me.......

Apurba

miCRoSCoPiC^eaRthLinG

Aug 1 2007, 03:48 AM

Have neglected continuing this series for a long time.. will come up with a record fetching / saving tutorial asap.

vizskywalker

Aug 1 2007, 05:05 AM

M^E! Haven't heard from you in forever. Just looked over this, and am looking forward to your next update, even though I don't use access or VB.NET. Should be simple enough to convert the methods here to any other .NET language though, such as C# (my favorite).

~Viz

FeedBacker

Dec 5 2007, 10:23 AM

Sir/Madam,

I have sum problems but at present.
I know the how to create DataBase and Tables in MS Access 2000, But problem in table creation field yes/no looking as text. I want yes/no filed in as check box what can I write in table creation for this purpose.

Thank.

-K.Nageshwar Rao

FeedBacker

Jan 5 2008, 08:30 AM

Part 2
VB.NET: MS-Access Interaction Tutorial (Part I)

Dear sir/ Madam

Part 1 was useful for my friend and I, and we'll waiting for part 2 to complete our exercises!
We'll be pleased if you would do us a favor and give us the rest of this tutorial.

Thanks in advance

Soudeh and Fariba

-Soudeh

FeedBacker

Jan 17 2008, 04:17 PM

I really need Part 2
VB.NET: MS-Access Interaction Tutorial (Part I)

Hi,
That was really amazing, found myself understanding the code line by line. Could you please post the 2nd part or send it to me by email, that will be great.

Good to have people one can count on.

Forrest

PS : Thanks alot

-forrest

FeedBacker

Jan 26 2008, 08:40 AM

VB.net and MSaccess
VB.NET: MS-Access Interaction Tutorial (Part I)

I'm using adodb and the following code is not picking up the entries in the database

If (textbox1.Text) = Rec.Fields("Username").Value then
Statement

How do I make it work?

-Clement

FeedBacker

Jan 11 2008, 06:22 AM

I am using vb.Net 2005 as a front-End and Ms-Access 2000 (Mdb) database as a backend. The problem which I am facing is that.

Suppose I make a OledbTransaction and In that transaction I insert some rows into a table Named "Abc". After insertion is complete those Newly added rows are not available for further use unless I "commit" the transaction. I want that those rows should be available for further use after insertion without completing the transaction. (This happens in Sql-Server) what should I do for that.

Waiting for your response.

Thanking You
From : Kaushalendra Pandey

-Kaushaleandra Pandey

FeedBacker

Mar 16 2008, 06:37 AM

Generating crystal report at run time
VB.NET: MS-Access Interaction Tutorial (Part I)

I want to generate crystal report which shows only those records which satisfies the given condition . How to do it ? I am using MS-Access as back end and vb.Net

-reply by Rajeshwar Rajemane

Pages: 1, 2

Recent Queries:-

access yes no vb.net - 0.19 hr back. (2)
add reference open ms access report from vb net - 0.20 hr back. (1)
vb.net access database tutorial - 0.25 hr back. (1)
open ms access report from vb net - 0.27 hr back. (1)
vb.net form update access table - 0.31 hr back. (1)
get index columns oledb msaccess c# - 0.64 hr back. (2)
vb.net ms access connection string - 0.65 hr back. (1)
vb.net delete table in ms access - 1.01 hr back. (1)
vb.net in crystal report tutorials in pdf - 1.13 hr back. (1)
vb.net microsoft access connection - 1.56 hr back. (1)
sample code on data transfer between ms access and vb.net - 1.62 hr back. (1)
vb.net database tutorial - 2.25 hr back. (1)
vb.net write to access - 2.79 hr back. (1)
writing vb.net data to accesss - 3.05 hr back. (1)

Similar Topics

Keywords : vb, net, ms, access, interaction, tutorial, part

Here Are Some Great Php Tutorial Sites

(4)

these site very usefull for php html java 5 day ago i only use w3school recently i have some great
web for usefull http://www.devresources.net/ http://www.php.net/ http://www.tizag.com/phpT/
http://www.w3schools.com/php/default.asp http://phpbuilder.com/ http://www.phpfreaks.com/
http://www.w3schools.com/php/ http://www.hudzilla.org/phpbook/index.php
http://www.spoono.com/ http://codewalkers.com/ http://www.phpcs.com/ http://pear.php.net/
http://www.phpclasses.org/ http://phpdebutant.org/ http://www.phpfrance.com/ http://....

How To Design A Contact Form Part 3

(0)

QUOTE Design A Contact Form In Flex Part 3 Hopefully you have able to get a grasp on my first
tutorials on how to design a flex form and then be able to stylize it with CSS. So now on to set up
your form to validate and of course being able to reset your form as well., and before we get to the
actual coding I break down the tags that will be used in this tutorial and what their roles are. Of
course, since my newbieness really starts here I try my best to explain these tags. The first tag I
will cover for setting up the validation is the tag, and since I don'....

How To Understand A Database Schema

A very nice and simple tutorial (4)

Yesterday while i'm seaching for a data model and database schema at the Library of Free Data
Models for a new project of a friend of mine i found there this nice and simple tutorial on How to
Understand a Database Schema . As its name says, this tutorial will help you to better understand a
Database Schema and covers the following basics topics that every Database Schema must define:
QUOTE Primary and Foreign Keys. One-to-Many and Many-to-Many Relationships. Inheritance.
"Rabbit's Ears", (Recursive relationships). The Scope of this tutorial is ....

Psychostats

Psychostats tutorial for cs (1)

QUOTE Required Server Software A Web server (usually Apache or IIS) PHP v4.3 or any version
higher. MySQL v4.1.11 or any version higher. Windows ActivePerl v5.8 or v5.10 Linux Perl v5.8+
Required Perl modules DBI (v1.4 or higher) DBD::mysql (v3.0002 or higher) Optional Perl modules
Net::FTP - This is only required if you need to download logs from a remote FTP server (chances are
this will be installed by default with your version of Perl). Net::SFTP - This is only required if
you need to download logs via an SFTP server (secure SSH file transfer protoco....

Basic Html Tutorial

Made it myself, hope you like it. (1)

HTML stands for hyper text markup language. It is a basic coding language used on almost every
website. There are some tags in HTML which must be used, whilst others are enhancing, but not
essential. Below I shall list the essential tags and there uses: This tells the browser that
the language between the tags is going to be HTML so it knows how to read it. Inbetween those tags
come These tags tell the browser that all the content that you wish to be displayed is in there.
They are the only essential tags for HTML! The list is short but if you only use them your ....

C/c++ -gdb Linux Debug Tool

Simple Gdb tutorial (1)

To run the C/C++ file use $ gcc –g –o test sample.cpp To debug the code use following command $
gdb test --- you will get following messages GNU gdb Red Hat Linux
(6.3.0.0-1.122rh) Copyright 2004 Free Software Foundation, Inc. GDB is free software, covered by the
GNU General Public License, and you are welcome to change it and/or distribute copies of it under
certain conditions. Type "show copying" to see the conditions. There is absolutely no warranty for
GDB. Type "show warranty" for details. This GDB was configured as "i386-redhat-linux-g....

How To Download Videos From Youtube

A Tutorial designed to inform of how to download YouTube videos. (11)

This tutorial is to inform the reader of how to download videos from YouTube. I will also inform
you of how to convert these videos into MP4 format so you can put them on your iPod. First, download
Mozilla Firefox Internet Browser. This is, in my opinion, the most secure and customizable browser
available. It can be downloaded freely at http://www.firefox.com . After you have Mozilla Firefox
installed, open it and go to: http://www.firefox.com . When the page has finished loading, click
Add-ons at the top of the page. Once the page has loaded, click in the search....

Html Basic Tutorial

 (9)

Knowledge HTML stands for H yper T ext M arkup L anguage. You cannot create an HTML file
using a rich-text editor, such as Microsoft Word or Wordpad. HTML To write a basic HTML, you will
need to start with this: CODE The html > tag tells the browser that this is an HTML page.
To close any tag, the same tag will be repeted but with the "/" sign. For example, CODE
Page title Did you notice the /title >, /head > & /html > tags? That's how we
close the tag. The HEAD > Tag A head > tag will include the meta >, titl....

Hibsicus Flower

Digital Painting as a part of workshop (9)

Here is a digital painting I did as part of a workshop at another forum. ....

Php Tutorial: Making A Shoutbox

Requirements: PHP, MySQL (12)

Hi everyone, I'm going to tell you how to make a simple shoutbox using PHP and MySQL. To start
off, open up mysql in the command line, or phpmyadmin, and create a database called shoutbox. Next,
enter the following sql into the command line, or the phpmyadmin sql box, while using the shoutbox
database: CODE create table messages(author varchar(30), message text, time timestamp, mid int
auto_increment, primary key(mid)); This creates the table we need to store the messages, note the
"mid" column, this gives each message a seperate id number, we'll see why ....

C# Tutorial : Lesson 7 - Creating Value Types & Reference Types - Part II

(1)

foreach statement This statement is explicitly used to traverse through arrays. The
benefit of using foreach over the normal for statement is that it is not needed to check the
size of the array while using the former. Syntax:- foreach(type identifier in expression) {
statement 1; statement 2; .... } Suppose we have an array StudentNames containing the name of all
the students in a class. We need to display the name of each one of them on screen. First we will
see how it can be done using the for loop. CODE string StudentNames = new string {"....

Ajax + Php + Sql = Simply Superb! ( With Visitor Tracking )

A small tutorial to explain integrating php, ajax and MySQL Database (11)

Hi all.. I'm back with a new small tutorial! Introducation A tutorial to integrate
Ajax, Php And Database ( Im using MySQL) + Visitor Tracking! Here you can enter values to some
input fields, and by clicking some enter button, ( or u can call the function on some other event)
those values will be sent to the database, along with visitor details ( IP Address, Input Value,
Visitor Agent etc)! Those values will be stored in some database and you can retrieve the same using
some simple php code and even deleted some rows from those databases! Requiremen....

Phpbb - Installation Tutorial ( For Newbies Based On Astahost Cpane)l

phpBB 2.0.22 installation Tutorial with basic steps. (5)

Introduction!! Providing a comprehensive 'How To' tutorial guide, on the
installation of phpbb 2.0.22 forum on your Astahost/cPanel account. Tutorial includes Downloading
of files Uploading using cPanel File Manager CHMOD using cPanel File Manager MySQL database
creation PhpBB initial configuration This guid will help everyone from beginners, with images and
an in depth guide of what to do. Step 1 To start with we need to download PhpBB ( latest stable
version is PhpBB 2.0.22 ). This can be done by visiting the PhpBB Downloads page which shou....

Wireless: Bypassing Mac Filtering

Tutorial (11)

Sometimes you scan the neighborhood for the wireless connections, you see open connections but can
not connect to them. Well this is possible because they use MAC filtering to secure up their
network. I will try to explain how to bypass this protection NOTE: This is for EDUCATION purpose
only to show you it is possible to bypass this security. I am not responsible for unauthorized use
of these information. Requirements : 1- You need some tool for sniffing the traffic. I suggest
using Aircrack-ng (http://www.aircrack-ng.org/) 2- You need some tool to change your MAC ad....

Firefox 2

Access-key and close tabs configuration (5)

When I installed Firefox 2.0 I got a little probelm... Accesskeys: I use access-key to follow
links and send forms very often, and in Firefox 1.5 y default they were used by pressing
"Alt"+"Accesskey". In Firefox 2.0 the default value has changed, so to follow accesskeys you many
press: "Alt"+"Shift"+"Accesskey" wich is more complicated. To change Firefox 2's behaviour,
browse: "about:config" and set the value of the following keys to: ui.key.chromeAccess = 5
ui.key.contentAccess = 4 This way the menu bar accesskeys are associated to the combination
"Alt"+"S....

Help: XP Pro Admin Account Deleted! Only Guest Access

(41)

HELP Administrator account deleted, need help loggin in to my laptop!!! WIN XP PRO Service Pack 2?
My friend was using my laptop and she says she has no idea what she did but she somehow deleted my
account (the only account) so now i can only login as a guest andI have no access to my music
pictures. programs, homework nothing, and I have a Toshiba Portege' laptop, it has no floppy
disk or cd drive no internet connection, so i have no idea how to fix this, I tried the ctrl+alt+del
trick but it will not work the default admin, has a password and i have no idea what it....

Read/Write Issues After Copying An Access .mdb File

(3)

Alright, I'm currently creating an interface program for a MS Access database. I've only
used Access once in the past but used other DB's a handful of times so I didn't have any
trouble getting the general program created. My issue arose when I tried to make it so that the
users needing to use the program can just copy the .exe and the .mdb files and use it. The program
doesn't require users to share the database but to store their OWN programs information in their
OWN database, so basically each needs to have their own database with the exact same d....

[tutorial] Basics Of C Programming - Part 2

(21)

Ok, well here is the Second part of the tutorial i promised. Operators & Expressions in C
Introduction In c the variable, arrays or
function references are combined with operators to form expressions.
Eg. C=A+B The data items that the operators act upon are
called operands. Some operators require two operands will others
require just a single operand to act upon. Types Of Operators : ....

VB.NET & MS Access Issue

(7)

Alright, I haven't had much experience with vb.net or ms access as it is, let alone using them
together, so I need some advice on the best way to do this. I need to create a program that
basically is a form to fill out with information, and upon filling it out it can be saved. Saving
consists of making a row in a ms access database and placing each field as a column entry within
this new row. Then I need to be able to retrieve this information from the DB and fill out the form
as it was originally if the user chooses to load. This is all fine and wasn't hard to....

Using The Php Mail() Function For Images Or Attachments

Can't find a decent tutorial! (6)

I read the one mail() tutorial that was posted in the tutorial section and to my horror found that
he had quoted almost verbatim from the PHP Manual off php.net, and made a comment about it, and also
found that if you were new to PHP or the Manual that it was informative but not indepth enough for
my tastes. This is not a tutorial although with the code that will be posted it might look like
one, that is not its intent or purpose. I have searched and found many so called tutorials about
MIME mail and boundries and all that but basically it either told me to use PHPMai....

Photoshop Tutorial: Pencil Sketch

(4)

Ola a Todos /biggrin.gif" style="vertical-align:middle" emoid=":D" border="0" alt="biggrin.gif" />
This tutorial will show you how to convert a photo in to a pencil sketch. Step 1 Open your photo
in Adobe Photoshop. Step 2 Right click on Background layer and choose "Duplicate layer" Step
3 Now, lets convert the new layer in to black and white. For this we'll use a shortcut
CTRL+Shift+U, or just go to image->adjustments->desaturate Step 4 Duplicate a copy of the new
Background layer, so that the new layer we will work on step 5 is above all others. St....

Video Editing Tutorial

Using VirtualDub (3)

Video Editing Tutorial (using VirtualDub) Before I start with this tutorial please
download VirtualDub from VirtualDub.org . Many of us want to save just a small portion of a video,
discard unwanted scenes from a video or add a logo of your choice to the video. Its very easy in
virtual dub. First open the video in virtual dub. Virtual dub opens all kinds of video files with
exception of the wmv and asf format as these are patented by microsoft. But you can find a version
which opens asf too on doom9.org . Opened Video The bottom buttons are the co....

VB6-MS Access Question

help please (9)

hi guys, I am developing an application in Visual Basic 6.0 and using MS Access as my backend. What
i want is that my database should not open when someone doublec clicks on the .mdb file. But my
application should be able to access it. What can be a possible solution to this problem? Please
help. Thanx in advance.....

Need A Tutorial On Creating A Font

(5)

I'd like to create a font set, just unsure how to, can somebody possibly either create a short
tutorial or point me in the right direction (Maybe google.com /biggrin.gif' border='0'
style='vertical-align:middle' alt='biggrin.gif' /> ). Cheers,....

Change Fonts On A S60 Phone [tutorial]

(15)

I didnt find a suitable catagory for this tutorial so posting it out here, Mods please find a
suitable place for this if i am wrong. Allright, lets get started. Almost everyone now owns a
Nokia, and out of that almost 70% use SymbianOS phones (S60). You can change the themes the
wallpapers etc on your phone, but i assume that a few of you would like to change only the Font.
Nokia uses its default font called the NokiaSans . This is hard coded and set in the ROM of your
phone, so that whenever we format the phone, the same font is taken and used. Many of you might hav....

C#.NET: Web Timer Control Tutorial

C# & VB.NET (3)

Web Timer Control C# Difficulty: Easy Time: 10 Minutes The aim of this tutorial is to create a
Timer that works on web pages. Timers are a very useful control in Windows Applications but how can
you use them in web pages. With the default controls you get in the .Net Framework there is not a
Web Timer. This web timer can be used as a normal web control you will be able to drag and drop it
onto Web Forms, and modify it using the properties window. This Timer Works using the JavaScript
setTimeout() function which once the required time has elapsed unlike a Windows F....

3ds Max Tutorial.

Introduction to reactor. (7)

Letter Collision Tutorial. This tutorial will help u make a basic collision in 3Ds Max using its
inbuilt reactor feature. Requisites:- discreet 3Ds Max 7 (Does 6 have reactor?? I dunno....). Even
the trial downloaded from discreets website will do. Time:- 20-30min. Skill Level :- Beginner (A
basic knowledge of the menu items is a must for this tutorial) Introduction:- reactor is a plug-in
for 3ds max that allows animators and artists to easily control and simulate complex physical
scenes. reactor supports fully integrated rigid and soft body dynamics, cloth sim....

How To Remove Bad Sectors Or Bad Clusters From HDD

a tutorial for you all (18)

hi friends, there is small tutorial to remove Bad Sectors from hdd to remove bad sectors you need a
program named SeaMap now we start Start the SeaMap.exe software Set the option by typing SD and
then press enter Press 1 then 0 or 1 to select drive Then press 2 and there will be a option (Y/N)
press n for No Press Esc button one to go back to command line Type FD Type y for yes the Hdd will
format the whole disk and removes bad sectors and partitions Now the computer has to be restarted,
Restart your computer Partition your Hdd using fdisk and then format all partitio....

Looking for vb, net, ms, access, interaction, tutorial, part