Add Data in Oracle Database Table

 Add Data in Oracle Database Table:

Imports System.Data

Imports Oracle.DataAccess.Client 

Imports Oracle.DataAccess.Types

Example of VB Programming  for Add Data in Oracle Database Table:

Private Sub addbtn_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles addbtn.Click

 If (Name.Text = "") Then

            MsgBox("Please Type Name")

        ElseIf (Regno.Text = "") Then

            MsgBox("Please Type Register No")

        ElseIf (mark1.Text = "") Then

            MsgBox("Please Type Mark1")

        ElseIf (mark2.Text = "") Then

            MsgBox("Please Type Mark2")

        ElseIf (mark3.Text = "") Then

            MsgBox("Please Type Mark3")

        ElseIf (mark4.Text = "") Then

            MsgBox("Please Type Mark4")

        ElseIf (mark5.Text = "") Then

            MsgBox("Please Type Mark5")

        Else

            Dim oradb As String = "Data Source=XE;User Id=HR;Password=password;"

            Dim conn As New OracleConnection(oradb)

            conn.Open()

            Dim cmd As New OracleCommand

            cmd.Connection = conn

            cmd.CommandText = "insert into table_name values ('" & Name.Text & "','" & Regno.Text & "','" & mark1.Text & "','" & mark2.Text & "','" & mark3.Text & "','" & mark4.Text & "','" & mark5.Text & "')"

            cmd.CommandType = CommandType.Text

            cmd.ExecuteNonQuery()

            MsgBox("Record is successfully stored")

            conn.Dispose()

        End If
End Sub

Create Oracle Database Table Using VB Programming

Create Oracle Database Table Using VB Programming:

• First, Connect with Oracle Database in Visual Studio.
• The Data Source , User Id and Password are change by  using  your Database Connection string.
• Use Following Library Function Headers in General 

Imports System.Data

Imports Oracle.DataAccess.Client 

Imports Oracle.DataAccess.Types

Example of Visual Basic Programming For Create Oracle Database Table:

Private Sub Button3_Click1(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button3.Click

Dim oradb As String = "Data Source=XE;User Id=HR;Password=password;"

        Dim conn1 As New OracleConnection

        Dim cmd1 As OracleCommand

        conn1.ConnectionString = oradb

        conn1.Open()

        Dim sql = "create table table_name(column_name1 varchar2(10),column_name2 varchar2(12),column_name3 varchar2(20),column_name4 varchar2(20),column_name5 varchar2(25),column_name6 number(8))"

        cmd1 = New OracleCommand(sql, conn1)

        cmd1.CommandType = CommandType.Text

        cmd1.ExecuteNonQuery()

         MsgBox("Table is Created")
End Sub

Avast Free Antivirus Free Download

Avast Free Antivirus Download for Windows:

• It is one of the famous free Anti virus
• Blocks Virus, Spyware and it contains several features.
• Easy to Register.
• Easy to update.

Download

Register Avast Free Antivirus :

Click to Register and get Serial Key for Avast free Antivirus.

Type Serial Key to Open Avast  free antivirus >> Maintenance >> Registration >> Click insert License key.

(or)

Open Avast free Antivirus >>Maintenance>>Registration>>Click Register>>Fill the Fields (type Email id, and others)>>Register. (Using Internet connection).

GIMP Image Editor For Windows

GIMP Image Editor Free Download:

• Free Image Editor.
• Free Software.

GIMP is a graphics manipulation software similar to Photoshop which lets you create, edit and work on images in general. GIMP has a full suite of painting tools such as the Brush, Pencil, Clone, Airbrush, etc. which should let you create new images from scratch as well as edit your own. The most recent version of GIMP includes layers, channels, masks, filters, effects, tabbed palettes, perspective clone, text tools, color operations and much much more which makes in comparable to the big boys of image editing such as Photoshop without the hefty price tag or subscription fees. GIMP is a completely free and open source application that is managed by volunteer developers that have been working very hard in order to create a well-polished and user-friendly image editing software. Download GIMP now, it’s 100% free!

Download

RGS- AvaCam Record Video from Web Camara

RGS-AvaCam Software:

• Record  the video from Webcam.
• Capture  photos from Webcam.
• Easy to Use.
• The easiest to use full featured WebCam tool to view your WebCam(s) or whatever video device you have installed (not just webcams) on your PC. A complete WebCam program designed with a intuitive user interface that makes AvaCam easy to use. 
• Can be used with ANY type of video device (not just webcams).
• Record video on motion.
• Free Software.

Download

Free Download Manager Download

Free Download Manager Download:

•  Free Download Manager is a free and open-source download manager for Microsoft Windows.
•  It is free software for windows.
•  Pause and Resume the Downloads.
•  Resuming broken downloads, if permitted by server.
• Batch downloading support for downloading a set of files.
•  Download easily.
•  HTTP and FTP download support.
•  RTSP/MMS download support.
• Import list of URLs from clipboard.
• Allows to download torrent files.
• BitTorrent support (based on Libtorrent).
• Download FLV video files from Youtube , Google Video and many other site.

Free Download Manager.

Flash Video Download.

Download- (FDM ver. 3.9.2 build 1303) 

(or)

Download

do PDF Software Free Download

do PDF  Free Download

Convert to PDF:

PDF stands for Portable Document Format and it was created by Adobe to ease document exchange. doPDF is a free PDF creator that does what the name suggests, creates PDF files. Once installed it will allow you to convert any type of printable documents to PDF files. doPDF^7.3 installs itself as a virtual PDF printer driver so after a successful installation will appear in yourPrinters and Faxes list and also in the list of All Programs. Using doPDF you can convert to PDF in two ways:

1.     Print to PDF via the virtual printer driver doPDF. You would do this exactly as you print to a regular printer, just the result will be a PDF file, not a printed piece of paper.

2.     Using the doPDF Startup window. doPDF has an executable file (accessible from the start program group) that you can run in order to start a conversion wizard.

Print to PDF via the virtual PDF printer, doPDF:

Open the document you want to convert (Word, Excel, PowerPoint, WordPad, NotePad or any printable document), choose Print and select doPDF from the list of printers. You will be asked where to save the PDF file and when finished, the PDF will be automatically opened with your default PDF reader. Screenshot below shows how easy it is to create a PDF file from Microsoft Word:

Convert to PDF using the doPDF Startup window

Go to Start->Programs->doPDF and click on doPDF to start the conversion wizard. Use the Browse button to select the file you want converted and after that click on Create to convert the document to PDF. Screenshot below shows how easy it is to convert to PDF from Microsoft Word:

Download