Record set - database applications, Visual Basic Programming

Assignment Help:

Record Set:

The record set presents the records in a base table or the records retrieved due to the query. The record set falls into 3 classes. These are table type record sets, dyna set & the snap shot type record sets.

(i)Table Type Record Sets:

The Table type record sets present a base table in the Microsoft Jet data base.

(ii) Dyna Set Type Record Sets:

The Dyna set type record sets are the resulting of a query.

(iii)Snap shot Type Record Sets:

The Snap shot type record sets presents a static copy of the records.

(iv) Data Source:

The Data source is a specific illustration made up of the 4 components.

  • Database which contains the data
  • A DBMS
  • The Operating system and the environment where the data resides
  • The network connection which permits access to the data source.

The database associated projects are made up of the MFC database classes. The ODBC driver manager uses the driver interacts with the database as shown in figure.

79_working of database application.png

Figure: Working of a Database Application


Related Discussions:- Record set - database applications

Creation of the menu in visual basic, Creation of the Menu in VB 1. Ini...

Creation of the Menu in VB 1. Initiate a new project by choosing a file and then new project. 2. Now select the Standard EXE as the Project type. 3. Build the Form1 activ

Switch 2 images, I have a problem with Visual Basic: exchangeable 2 image...

I have a problem with Visual Basic: exchangeable 2 images of place I have 2 picturebox''s placed a button when I click on the button, the 2 pictures of this place change with e

Explain Databound Controls, Databound Controls - A controls use to display ...

Databound Controls - A controls use to display the contents of table using Data Control , have to bound each Control to the specific field and the controls are Known as the Data Bo

Function procedures - vbscript, This is a series of VBScript statements enc...

This is a series of VBScript statements enclosed through the Function & End Function statements. A Function procedure is same to a Sub procedure, however can also return a value. T

#title., Write a program to print a digital clock which displays the time f...

Write a program to print a digital clock which displays the time for 2 hours . ..

Repeating statements while a condition is true, Use the While keyword to ve...

Use the While keyword to verify a condition in a Do...Loop statement. You can verify the condition before you enter the loop (as illustrated in the following ChkFirstWhile instance

Sdi application - types of project using visual c++, SDI Application T...

SDI Application The SDI application uses the main frame window to exhibit a document. Only one document can be opened at a particular time.

Data control, DATA CONTROL The data control is used to connect to the d...

DATA CONTROL The data control is used to connect to the database. Three properties are very necessary to connect to the database. The primary property is the database name. You

Multiple Forms Issue, i want to use two forms in vb.net. when the progress ...

i want to use two forms in vb.net. when the progress bar in form1 reaches on a specific value then disable form1 and progress bar will stop and the second Form2 will popup which wi

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd