Answer / m.r.nataraajhan

You use Recordset objects to manipulate data from a
provider. When you use ADO, you manipulate data almost
entirely using Recordset objects. All Recordset objects
consist of records (rows) and fields (columns). Depending
on the functionality supported by the provider, some
Recordset methods or properties may not be available.

ADODB.Recordset is the ProgID that should be used to create
a Recordset object. Existing applications that reference
the outdated ADOR.Recordset ProgID will continue to work
without recompiling, but new development should reference
ADODB.Recordset.

There are four different cursor types defined in ADO:

Dynamic cursor Allows you to view additions, changes,
and deletions by other users; allows all types of movement
through the Recordset that doesn't rely on bookmarks; and
allows bookmarks if the provider supports them.

Keyset cursor Behaves like a dynamic cursor, except
that it prevents you from seeing records that other users
add, and prevents access to records that other users
delete. Data changes by other users will still be visible.
It always supports bookmarks and therefore allows all types
of movement through the Recordset.

Static cursor Provides a static copy of a set of
records for you to use to find data or generate reports;
always allows bookmarks and therefore allows all types of
movement through the Recordset. Additions, changes, or
deletions by other users will not be visible. This is the
only type of cursor allowed when you open a client-side
Recordset object.

Forward-only cursor Allows you to only scroll forward
through the Recordset. Additions, changes, or deletions by
other users will not be visible. This improves performance
in situations where you need to make only a single pass
through a Recordset.

Whether HTML supports multimedia: and document links?

0 Answers  

---

How would you attach pictures in column headers of List View Control?

0 Answers   RRB,

---

How do I mimic a toggle button?

0 Answers  

---

What is a variant data type and when would you use it?

3 Answers  

---

What methods are used for DBGrid in unbound mode?

1 Answers  

---

What will be the code in VB, while saving the form and light goes off? Please tell me the exact code line.

1 Answers  

---

by writing MACRO CODE,i want to retrive data from one spead sheet to another UI (workbook). control will search cell by cell for each row and load the data in another workbook(UI). ex: custdetails custname lastname locaton mobile pincode custdetails raj tony hyd 555555 521245 servcreqrd srvce# srvcename location srvcepincode servcreqrd 754 drilling hyd 521784 for the above example in the another workbook retrive data like this custname Raj srvce# 754 srvcepincode 521784. while retrieving data control will search cell by cell for each row.

0 Answers   CGI, Infotech,

---

Where can I get good up-to-date information about VB?

0 Answers  

---

What are constructors and destructors?

1 Answers  

---

Does VB Supports OOPS Concepts? Explain..

4 Answers  

---

What are some methods you can use to send data from one VB executable to another one?

0 Answers  

---

What is the purpose of the AutoRedraw property on a form or container?

3 Answers  

---