How to Connect to MySQL Database Using Web ExpressionIn Feburary 2016 24,

In Feburary 2016 24,
Open Microsoft Expression Web. Click on 'File,' 'Open' and choose the target website from the website files. Click 'Split' below the design pane. The three tabs below the design pane are Design, Split and Code; Split shrinks the size of the design pane and opens up the Code section above it, where HTML code is entered.
Copy the following code:
Now click in the Code section of the target website in Expression Web, above where the code reads:
Right-click above
and choose 'Paste' to paste the copied code. It should now look like this:
Copy the following code:
Sub Page_Load(Source as object, e as EventArgs)Dim sConString As String = 'DRIVER={MySQL ODBC 3.51 Driver}; SERVER=localhost; DATABASE=Your_Mysql_DB; UID=mysql_username; PASSWORD=mysql_password; OPTION=3'Dim oConnection as ODBCConnection = new ODBCConnection(sConString)Dim sSQL as String = 'SELECT * FROM Table1'Dim oDataAdapter as ODBCDataAdapter = New ODBCDataAdapter(sSQL, oConnection)Dim oDataSet as DataSet = new DataSet()oDataAdapter.Fill(oDataSet)oDataGrid.DataSource = oDataSetoDataGrid.DataBind()End Sub
Click again in the Code section of the target website in Expression Web. Paste the code after the
tag in the code for the website. Be certain that the
tag closes the code section.Copy this line: Paste it between the
and
tags, also in the Code section of the target site in Expression Web.Example:
Note the line in the MySQL database code that reads: 'DRIVER={MySQL ODBC 3.51 Driver}; SERVER=localhost; DATABASE=Your_Mysql_DB; UID=mysql_username; PASSWORD=mysql_password; OPTION=3'These values will need to be changed to represent the desired MySQL database, ID and password. If the database is to be accessed remotely, the 'server' will be an IP address. Simply delete the 'answer' following the equal sign (=) for each item and type in the correct information.
In Feburary 2016 24,

How to Create Registration Forms in JavaIn Feburary 2016 07,

In Feburary 2016 07,
Download and install the free NetBeans IDE from NetBeans.org. (See Resources for other IDEs with similar form designers.)
Open NetBeans and select \'File>New Project.\' Select \'Java\' in the Categories window, and \'Java Application\' in the Projects window. Press \'Next.\'
Complete the New Java Application dialog box: enter \'registerform\' for \'Project Name.\' Enter \'c:\users\
\Desktop\registerform\' for the \'Project Location.\' Leave the \'Use Dedicated Folder...\' check box unchecked, and also the \'Create Main Class\' box unchecked. Do check the \'Set as Main Project\' check box, then press \'Finish.\'
Expand the \'registerform\' node, which is in the Projects window, then its \'Source Packages\' node. Right-click on \'
\' and select \'New>Java package.\' In the \'New Java Package\' dialog box, enter \'pkgRegform\' for \'Package Name,\' then click \'Finish.\'
Right-click the \'pkgRegform\' node in the \'Projects\' window and select \'New>JFrame Fform.\' In the \'New JFrame Form\' dialog box, enter \'frmRegform\' for the \'Class Name,\' then press \'Finish.\'
Click and drag a \'Label\' control from the \'Palette\' window onto the form, near the form's upper left corner. Right-click on the label control and select \'Properties,\' then locate the \'text\' property. Type \'first name\' to replace the default text for that control. Click the \'Close\' button on the \'Properties\' dialog box.
Drag a \'Text Field\' onto the form from the Palette window. Position the text field to the right of the label control. Using the Properties dialog box, delete the default text from the text field.
Repeat steps 6 and 7 to create a label and associated text box for the \'Last Name\' field. Position the new controls directly under the first two. Under the controls for the last name, add a label and text box control for an email address.
Add a button under the email label. Using the Properties window, change its \'Text\' property to read \'Submit.\'
Resize the form by dragging its lower right corner. Position that corner so that the white space between the controls and the form's borders is visually agreeable.
Preview your form by right-clicking on it and selecting \'Preview Design.\' In the context menu that appears, choose the form type (i.e. \'Metal,\' \'Nimbus,\' \'Windows Classic\') that matches your project's design specifications.
Double-click the button to enter the code window. Enter the Java program code needed to route the data that your form has gathered to the destination indicated in your project's specifications.
In Feburary 2016 07,

How to Open MySQL Database With MS AccessIn Feburary 2016 02,

In Feburary 2016 02,
Type 'Data Sources (ODBC)' in the search box on 'Start.' Click the result and enter your administrative password if necessary. Click 'System DSN.' Choose the MySQL driver from the list and click 'Finish.'
Click 'Add Data Source Name.' Enter all of the information for your MySQL database, such as the name, server, username and password. Click 'OK.'
Open Microsoft Access.
Click 'File.' Select the option 'Get External Data.' Click 'Link Tables.'
Select 'ODBC Databases ()' in the explorer window that opens. Select the MySQL data source.
Click 'Select All' to import all of your MySQL tables into Access. Click 'OK.'
In Feburary 2016 02,