Ni

About HTML5 the latest being microsoft switching its focus from Silverlight to HTML5 With HTML5 media support now websites can now deliver rich, interactive media as easily as they deliver images. Safari was the first browser to support HTML5 audio and video elements Work is being done to which will enable videoconferencing from HTML5 applications. It will allow the user to give permission to a page to use a device, such as a video camera. That will make possible for users to communicate with each other through a web conferencing from the browser itself. Until recently there was limited support for HTML5 specs but now we have chrome, firefox, opera and IE 9 supporting HTML5. Also there is support for Previous versions of IE through a plugin. You can read more about it here. http://goo.gl/i3VY . You can view a demo of  video conferencing implemented using the device element and stream API's in WebKit GTK+ that enables you to capture video from an web cam and display it in t

Many had been asking about how to view records this tells  how to view records from database. Private Sub Command7_Click() 'code for view On Error GoTo q Dim viewv As Integer viewv = InputBox("enter the voter id") On Error GoTo w 'again you type it in a line this code runes rsv.Open "select id,name,address,age,gender,dob from voter where id=' " & viewv & " '", conv, adOpenDynamic, adLockOptimistic Text5.Text = rsv.Fields("id") Text2.Text = rsv.Fields("name") Text3.Text = rsv.Fields("address") Combo1.Text = rsv.Fields("age") If (rsv.Fields("gender") = "male") Then Option1.Value = True ElseIf (rsv.Fields("gender") = "female") Then Option2.Value = True End If DTPicker1.Value = rsv.Fields("dob") If (rsv.State = 1) Then rsv.Close End If MsgBox "view" Exit Sub q: MsgBox "you cancelled" Exit Sub w

It is a simple xml demo using altova.M5X6SH23V6Q9 You can download the altova trial version here http://www.altova.com/download-trial/ When you download you wll get the key for trial version on your mail id. Steps: 1)   2)

This part describes the way to implement procedure and cursor as well. I have together described cursor and procedure in a single example. What i have done is when you delete or update a record that record gets deleted from voter table and get inserted in to votertemp table. In procedure what i have tried to do is the deleted record that is currently in votertemp gets deleted from votertemp table and gets inserted back to voter table as it was in its first instance Oracle 1) type ed -> in the sql> command line -> it opens a notepad 2) type the procedure there! create or replace procedure voterundo is cursor votercur is select * from votertemp; id number(5); name varchar2(25); address varchar2(50); age varchar2(3); gender varchar2 (6); dob varchar2(30); begin open votercur; loop fetch votercur into id,name,address,age,gender,dob; exit when votercur%notfound; delete from voter; insert into voter values(id,name,address,age,gender,dob) ; delete from voterte

Now we will see how to insert values into table a table and to view them. Oracle Initially we had created table in part1. Visual Basic 6.0 Now we wil insert data into the table through visual basic. The code for inserting will be as follows When you double click on add button it will open your code window it will have this code! Private Sub Command1_Click() Dim gen As String If (Option1.Value = True) Then gen = "male" ElseIf (Option2.Value = True) Then gen = "female" End If rsv.Open "insert into voter values(" & Text5.Text & ",'" & Text2.Text & "','" & Text3.Text & "','" & Combo1.Text & "','" & gen & "','" & DTPicker1.Value & "')", conv, adOpenDynamic, adLockOptimistic If (rsv.State = 1) Then rsv.Close End If MsgBox ("Data Entered") End Sub This will add the data entered into

The first part defined how to establish connectivity between the back end and the front end of the project. Next we will see how to implement triggers . Oracle We need to Create the triggers in the oracle. 1) type ed in sql 2) it opens a notepad window 3) type the trigger as in the below example 4) exit the notepad with saving 5)and then type "/" 6) this will show a message as trigger created! 7) It should not show trigger created with compilation errors. If this message is shown check your syntax of trigger. Example: create or replace trigger votertrig after update or delete on voter for each row begin insert into votertemp values(:old.id,:old.name,:old.address,:old.age,:old.gender,:old.dob); end; Whenever we perform an update or delete operation the old values get stored into the votertemp table and the changed data gets reflected into the permanent table Visual Basic 6.0 In VB we do not have to do anything as triggers are automatically fired whenev

Here is a basic VB application called voter information system demonstrated which explains the concepts quite clearly. The first step required to establish connectivity is preparing the back end and the front end of the project. These steps are divided into two parts first the back end that is the oracle and front end that is the Visual Basic 6.0. Oracle Firstly we need to set up the database. Create the tables, triggers and procedures and database in the oracle. Create tables: Example: create table voter(id number(5) primary key, name varchar2(25),address varchar2(50),age number(3),gender varchar2(6),dob varchar2(30)); create table votertemp(id number(5) primary key, name varchar2(25),address varchar2(50),age number(3),gender varchar2(6),dob varchar2(30)); (we will be using the next table in the triggers that we will be implementing) Visual Basic 6.0 Develop the VB application as in this example given below. Design the necessary forms for the application. The next part is