Adding records - data control, Visual Basic Programming

Assignment Help:

Adding Records:

1. As in the earlier case Set the DatabaseName property as "C:\ex.mdb", now Set the Record Source for the data control as Customer and Set the Record Type to 0.

2. Design a form with 5 text boxes and 2 command buttons new and update.

3. Put the DataSource to Data1 for all the text boxes.

4. Place the DataField property for each and every text box to the various fields of the Customer table.

5. Handle the Click event for new command button and type the handler as shown below:

data1.RecordSource = "Customer"

data1.Refresh

data1.Recordset.AddNew

Now Add New adds a buffer in the memory for a new record.

6. Handle the Click event for the command button, update it and type the handler as shown below:

data1.Recordset("Id") = CInt(text1.Text)

data1.Recordset("name")= text2.Text

data1.Recordset("address")= text3.Text

data1.Recordset("city")= text4.Text

data1.Recordset("state")= text5.Text

data1.Recordset.Update

Now update marks the record into the database.

Related Discussions:- Adding records - data control

Programming project using straight-line method, Depreciation to a Salvage V...

Depreciation to a Salvage Value of 0. For tax purposes an item may be depreciated over a period of several years, n. With the straight-line method of depreciation, each year th

Events, everything about events

everything about events

Create an application for hospital management, 1. Make project in Visual ...

1. Make project in Visual Studio 2008. 2. Controller Class is used for functioning. 3. Login Form where three people can login like manager, staff and receptionist we c

Loops - VBScript, Using Loops to Repeat Code Looping let you to run a g...

Using Loops to Repeat Code Looping let you to run a group of statements repeatedly. Some loops repeat statements till a condition are False; others repeat statements till a con

If - else statement, A variation on the If...Then...Else statement lets you...

A variation on the If...Then...Else statement lets you to choose from various alternatives. By adding up Else If clauses expands the functionality of the If...Then...Else statement

Option explicit declaration - data types, Option Explicit Declaration: ...

Option Explicit Declaration: If the option explicit is used essentially then all the variables will have to be declared. Or else an error will be reported saying that the vari

Message loop, MESSAGE LOOP The message loop is the code in the Win 3...

MESSAGE LOOP The message loop is the code in the Win 32 based application. It retrieves messages from the application's message queue and passes these to the related window

program that compares interest rates between two banks, 'This program comp...

'This program compares interest rates between two banks and determines the best bank PublicClassForm1 PrivateSub Button1_Click(sender AsSystem.Object, e AsSystem.EventArgs) H

Shopping cart, Shopping Cart Purpose – Allows user to browse while keeping ...

Shopping Cart Purpose – Allows user to browse while keeping track of the items in which they will purchase at the end on the order page link and this will give a final price for al

Three models for user interface design, THREE MODELS FOR USER INTERFACE DES...

THREE MODELS FOR USER INTERFACE DESIGN The 3 models for the user interface design are the implementation model, mental model &the manifest model. The Implementation Mod

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages