Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Off-topic (VB)

Off-topic (VB)

From: Santosh Varma <vsantosh_at_psi.soft.net>
Date: Wed, 25 Sep 2002 23:48:19 -0800
Message-ID: <F001.004D9A51.20020925234819@fatcity.com>


Content-Type: text/plain;
 charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

Hello all,

   Sorry for the off-topic discussion.
But any one who knows VB can answer me personally.

I have 2 forms.
In the first form, through the program, i call a function connection() which is as follows ->

{
Dim strconn As String
strconn = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=Santosh;Password=santosh;Initial Catalog=master;Data Source=anamika" objconn.ConnectionString = strconn
objconn.Open
}

and in the second form, i have 2 text boxes (from date and to date ) and a grid
and as soon as the focus is left from todate, i want to display the details from customer table to the grid.

How to achieve this ??

Thanks and regards,
santosh

------=_NextPart_000_0034_01C26556.8F158420 Content-Type: text/html;
 charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 5.50.4522.1801" name=3DGENERATOR></HEAD>
<BODY>
<DIV><SPAN class=3D897304306-26092002><FONT face=3DArial size=3D2>Hello=20
all,</FONT></SPAN></DIV>
<DIV><SPAN class=3D897304306-26092002><FONT face=3DArial=20
size=3D2></FONT></SPAN>&nbsp;</DIV>
<DIV><SPAN class=3D897304306-26092002><FONT face=3DArial =
size=3D2>&nbsp;&nbsp; Sorry=20
for the off-topic discussion.</FONT></SPAN></DIV>
<DIV><SPAN class=3D897304306-26092002><FONT face=3DArial size=3D2>But =
any one who=20
knows VB can answer me personally.</FONT></SPAN></DIV>
<DIV><SPAN class=3D897304306-26092002><FONT face=3DArial=20
size=3D2></FONT></SPAN>&nbsp;</DIV>
<DIV><SPAN class=3D897304306-26092002><FONT face=3DArial size=3D2>I have =
2=20
forms.</FONT></SPAN></DIV>
<DIV><SPAN class=3D897304306-26092002><FONT face=3DArial size=3D2>In the =
first form,=20
through the program, i call a function connection() which is as follows=20 -&gt;</FONT></SPAN></DIV>
<DIV><SPAN class=3D897304306-26092002><FONT face=3DArial=20
size=3D2></FONT></SPAN>&nbsp;</DIV>
<DIV><SPAN class=3D897304306-26092002><FONT face=3DArial=20
size=3D2>{</FONT></SPAN></DIV>
<DIV><SPAN class=3D897304306-26092002><FONT face=3DArial size=3D2>Dim =
strconn As=20
String<BR>strconn =3D "Provider=3DSQLOLEDB.1;Persist Security = Info=3DFalse;User=20
ID=3DSantosh;Password=3Dsantosh;Initial Catalog=3Dmaster;Data=20 Source=3Danamika"<BR>objconn.ConnectionString =3D=20 strconn<BR>objconn.Open</FONT></SPAN></DIV>
<DIV><SPAN class=3D897304306-26092002><FONT face=3DArial=20
size=3D2>}</FONT></SPAN></DIV>
<DIV><SPAN class=3D897304306-26092002><FONT face=3DArial=20
size=3D2></FONT></SPAN>&nbsp;</DIV>
<DIV><SPAN class=3D897304306-26092002><FONT face=3DArial size=3D2>and in =
the second=20
form, i have 2 text boxes (from date and to date ) and a grid=20
</FONT></SPAN></DIV>
<DIV><SPAN class=3D897304306-26092002><FONT face=3DArial size=3D2>and as =
soon as the=20
focus is left from todate, i want to display the details from customer = table to=20
the grid.</FONT></SPAN></DIV>
<DIV><SPAN class=3D897304306-26092002><FONT face=3DArial=20
size=3D2></FONT></SPAN>&nbsp;</DIV>
<DIV><SPAN class=3D897304306-26092002><FONT face=3DArial size=3D2>How to =
achieve this=20
??</FONT></SPAN></DIV>
<DIV><SPAN class=3D897304306-26092002><FONT face=3DArial=20
size=3D2></FONT></SPAN>&nbsp;</DIV>
<DIV><SPAN class=3D897304306-26092002><FONT face=3DArial size=3D2>Thanks =
and=20
regards,</FONT></SPAN></DIV>
<DIV><SPAN class=3D897304306-26092002><FONT face=3DArial=20
size=3D2>santosh</FONT></SPAN></DIV></BODY></HTML>

------=_NextPart_000_0034_01C26556.8F158420--

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Santosh Varma
  INET: vsantosh_at_psi.soft.net

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Received on Thu Sep 26 2002 - 02:48:19 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US