Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Off-topic (VB)
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> </DIV>
<DIV><SPAN class=3D897304306-26092002><FONT face=3DArial =
size=3D2> 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> </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
-></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></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> </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> </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> </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
![]() |
![]() |