Application development in Visual Basic (VB) is quite easy. However,
thinking to connect to the database using the code in May pure hard look.
But no! After understanding the basics and a little coding, it becomes easy.
First we need to get everything ready with the reference, then you will
understand what should I do (I leave this part to you. Google here), and
finally make a connection ... Note that this article related to VB6, but
it can work for flavors.Setting Reference - We will use Microsoft ActiveX Data Objects 2.6 Library. You can find it under "Projects" -> "References". Now,
you have to get all the references that are displayed, scroll down and find "Microsoft ActiveX Data Objects 2.6 Library" and check the box beside it.
You are now ready to connect to your database.
Setting up the Module - What does the following steps, "Project" -> "Add Module" and you will have something like "Module1.bas" appears in the project. Do not panic. : P Just head to the module, and in the "Properties" window, specify the name of "conndb", which means something. : D Now, in the head by double-clicking on the module. Remember, if we want to start our form, (well technically, the object through each module), we must set "Startup Object" as a "Sub Main". Still thinking where to do so? This is found in the project Properties. You "conndb" module, place the following code snippet:
Private Sub main ()
This can be considered as the beginning of the project
here we will start our main form and open a connection to our database
End Sub
Shooting connection - we can open our database connection now.
Please note, this tutorial only uses MS Access database. But! The concept
is still the same when using the other engine data. We continue to create
more new "sub" we "conndb" module. My name as "connect_db", but you can
select the name you want.
Private sub connect_db()
end sub
Go to the top of the module (ie the first line in conndb) type:
option explicit
dim conn as new addb.connection
dim cmdrs as new adodb.command
public rstable as new adodb.recordset
Private sub connect_db()
create the database connection
with conndb
connectionString="Provider=microsoft.jet.oledb.4.0;data source
="& App.parh&"\" &
"database\database.mdb
cursorlocation=aduserclient
open the connection
end with
if conndb.state=adtateclosed then
msgbox"connection to database failed"
end
end if
open
with cmdrs
activeconnection=conndb
commandtext="set your SQL query over here"
commandtype=admdtext
end with
with rstable
cursortype=adopenstatic
cursorlocation=aduserclient
locktype=adlockoptimistic
open cmdrs
end with
end sub
Read more...
Now let's talk about <input type = "file"/>, which allows the user to
select a file to upload to the server, which will be sent to server when
submitted. <input Type="file" /> together with the key when given in a browser.
When the user clicks on the browse button a file dialog box and the path name
of the selected files will appear in the field or you can type the path name to
the field.
After type = "file" /> <input to work, you must have a server with a CGI script or some type of scripting languages such as PHP, which will be invoked by the
forms action URL attribute values that will receive entry form file.
Now if the path name exceeds the value of control maxlength attribute specified,
the entire path name of the selected field will still be placed into the field
when selecting a file through the browse button a file selection dialog box, but
you do not need to worry with the maxlength attribute, although because most
browsers ignore attributes currently placed in the /> <input type = "file".
Now if you want to restrict file types that your user's browser that allows
users to choose from, you will need to use attribute tags <form> receive to
complete this. Receive an attribute that can be comma-separated list of MIME
encodings or a number of MIME encodings. User can only choose only the
appropriate type of file that you receive in the value attribute.
Now only accept attributes that are used with the <input type = "file"/> .
If you want to know what MIME stands, which means that the multipurpose Internet
Mail Extensions, I will name only a few MIME encoding since there are many types
of MIME. There are three types of MIME encoding (image / jpeg, text / richtext, and
video / mpeg).
Now is not like other types of form input controls will only work correctly with a specific data encoding and transmission method. Now if you are using type = "file" /> <form> you must set the value tag attribute enctype to multi / form-data and the method attribute value to the post in
