no

Not saved

No it will not get saved

standard module:

1)place for variable declarations,procedures etc.and we can 
access these procedures wherever needed in the project.

2)Available only for the existing modules where they are 
used.

class module:

1)Unlike standard module,members of class like object's 
properties,events can be accessed only whenever an instance 
of class is created.

2)We can make use of it whenever an object reference of the 
particular class is created for number of applications

Module
Code  in VB is stored in modules.
Thereare three kind of modules, Class modules, Form modules 
and Stendard modules.
In VB there are common codes we want to execute in several 
forms. We do not want to duplicate the code in all forms, 
we create a separate module containing the procedure that 
implements the common code. This separate module should be 
Standard module.

Class Module
Class modules (.CLS extension) are foundation of object 
oriented programming in VB. We can write code in class 
modules to create new objects. These new objects can 
include our own customiaed properties and methods, although 
custom objects can not have their own events.
We can also use the keyword, New to create multiple copies 
of our objects.

make the adodc connection with database from its property
connection string & connect datagrid with adodc & write the code


  adodc_.recordsource = "select * from table name"
  datagrid.refresh
  adodc.refresh

MY EMAIL ID shanty_pathak@yahoo.com

1. Differences between Image & Picture Box (Please note 
more than one)
2. Cursors and locks for ADO recordset.
3. Simple programs, like movable ball, slide show, etc.
4. Class creation
5. Property creation
6. ActiveX development
7. What is SSTab
8. How will you use 3rd Party Tool.
9. How Excel VBA Coding works?
10.How will you link crystal reports in vb?
11.Properties and methods of FlexGrid.
12.Properties and methods of Scrollbar.

Many other can be provided. Contact me on, 
chandresh_kumar@india.com

Dim strValue As String
        strValue = txtValue1.Text

        Dim rstData As ADODB.Recordset
        rstData = New ADODB.Recordset

        rstData.Fields.Append("A",
ADODB.DataTypeEnum.adInteger, 0,
ADODB.FieldAttributeEnum.adFldKeyColumn)
        rstData.Fields.Append("B",
ADODB.DataTypeEnum.adVarChar, 10,
ADODB.FieldAttributeEnum.adFldIsNullable)
        'rstData.Fields.Append("C",
ADODB.DataTypeEnum.adVarChar, 0)

        rstData.Open()
        rstData.AddNew()
        rstData.Fields("A").Value = "1"
        rstData.Fields("B").Value = "Amol"
        rstData.Update()
        rstData.MoveFirst()
        If UCase(Trim(rstData.Fields("B").Value)) =
UCase(Trim(strValue)) Then
            MsgBox("True")
        Else
            MsgBox("False")
        End If

You have to use this DSN name (in your case it is sonia) in 
your VB code wherever you wish to establish a connection 
between your VB application and your SQL server 2K database.

You have to create the DSN programatically by using some 
code.

You can used DSN Less Code here (which is more usefull 
andimportant insteated of using DSN Coz when you run that 
Application on Different PC, then you have to crete DSN 
again..)
DSN Less Code for Connection MS ACCESS: or can connect any 
db just need to change its provider:
dim con as new adodb.Connection 
con.open "provider=microsoft.jet.oledb.4.0;" & "Data 
Source= ur db path (there is no space btn Folder and File 
Name)"

redim can only be used to increase/decrease the size of the 
existing array.it cannot be used to create a new array.

srinivas  shetty

yes Redim can be used to declare a new array.

No We can't use redim to declare a new array. Redim is used 
to resize the declared array

M. chitramala is right. Redim is to resize the exiting 
array variable.

sample:
Dim myarray() as string

Redim myarray(10)

Redim is used to increase the dimension/size of the array.  
Preserve keyword is used to hold the previous value of the 
array.

ex:  Redim Preserve a[20]

yes friends its right redim is used to resize the decalred
array realier in the program

if I redim an array and increase its size. will the 
existing elements in the array be lost?

Yes, Using Redim statement the size is set at runtime.

Connection object

ye, through Connection object you can commit or rollback 
the transaction Eg:

on error go to errhandler
   con.BeginTrans
   
   con.execute cmd
   con.execute cmd2
   con.CommitTrans
errhandler:
   con.RollbackTrans

Connection Object of ADO is Used to Perform Commit and 
Rollback.

yes we can display only the integers through the message box.
if isnumeric(<value>) then
    msgbox value
end if

we can display any thing in messagebox. but,  what we r
going to display can be converted into string.

ex:messagebox.show(xxxx.tostring());

Yes, we can
msgbox(value)

yes,
msgbox(2)

dim xx as integer
xx=123

if val(xx) then exit sub

HI, GUYS

PIVOT TABLE IS ADVANCE FEATURE BY SQL ANSI WITH TRANSFORM 
STATEMENT. THIS REPRESENTING THE DATA IN CONSOLIDATE WAY. 
FOR EXAMPLE IF WE WANT THE PRODUCT V/S MONTHLY SALE ANALYSIS
THEN IT IS POSSIBLE WITH PIVOT TABLE.

       MONTH      APRIL-07  MAY-07  JUN-07         
PRODUCT
MARUTI-800          700     800     550
MARUTI ZEN          100     120     90

ETC

THIS IS TYPICAL PIVOT TABLE

Vlookup means Vertical lookup that is find the given value 
in vartical order

vlookup is the way to find the particular data from master 
file.it gives the data in vertical manner from the right 
side of the column against which data has to find.

251

85

A VB form can have 255 controls in a form. Note: Form is
also one of the control

91, my friend told,,

255

255

255 X 255 
we can use the control array on the form

only 255

Friends,

VB Can Make 255 Controls On a single Form. Because 0 to 256
we can Make Controls. But Form Also One of the Control by Self.
So We can Make only 255 Controls in A sINGLE fORM.

Note: I Already Workout this. SO I can tell Sure this is
Right answer...

255 controls on the form.

255 controls excluding form because is form is also a one 
control

They are 2 types of controls in VB, one is Intrinsic 
Controls and another one is Extrinsic Control.

The maximum number of controls allowed on a single form 
depends on the type of controls used and available system 
resources. 
However, there is a fixed limit of 254 control names per 
form

255

256 Controls