SqlStringConnect() Method
|Visual FoxPro Toolkit for .NET | |
SqlStringConnect() Method
Receives a connection string as a parameter and establishes a connection to the backend. Returns a connection object back
[pic]
[Visual Basic]
Public Shared Function SqlStringConnect(ByVal tcConnectionString As String) As OleDbConnection
[C#]
public static OleDbConnection SqlStringConnect(string tcConnectionString)
Example
[Visual Basic]
'Establish a connection and a command
Dim lcConnectionString As String
Dim lcSQL As String
Dim oConn As OleDbConnection
'Get the connection string and sql statement
lcConnectionString = "Provider=vfpoledb.1;Data Source='C:\Program Files\Microsoft Visual FoxPro 7\Samples\Data\testdata.dbc';password='';user id=''"
lcSQL = "Select * from customer"
'Connect to the Database, execute the query and disconnect
'SqlConnect(), SqlExecute(), SqlDisconnect()
oConn = SqlConnect(lcConnectionString)
goView = SqlExecute(oConn, lcSQL, "CustomerList")
SqlDisConnect(oConn)
'Select the default cursor
VFPToolkit.vfpData.Select(goView)
Browse()
[C#]
//Establish a connection and a command
string lcConnectionString;
string lcSQL;
OleDbConnection oConn;
//Get the connection string and sql statement
lcConnectionString = "Provider=vfpoledb.1;Data Source='C:\\Program Files\\Microsoft Visual FoxPro 7\\Samples\\Data\\testdata.dbc';password='';user id=''";
lcSQL = "Select * from customer";
//Connect to the Database, execute the query and disconnect
//SqlConnect(), SqlExecute(), SqlDisconnect()
oConn = SqlConnect(lcConnectionString);
goView = SqlExecute(oConn, lcSQL, "CustomerList");
SqlDisConnect(oConn);
//Select the default cursor and browse it
VFPToolkit.vfpData.Select(goView);
Browse();
Implementation
[Visual Basic]
Public Shared Function SqlStringConnect(ByVal tcConnectionString As String) As OleDbConnection
Return SqlConnect(tcConnectionString)
End Function
[C#]
public static OleDbConnection SqlStringConnect(string tcConnectionString)
{
return SqlConnect(tcConnectionString);
}
Requirements
Namespace: VFPToolkit
Class: VFPToolkit.vfpData
Platforms: Windows 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows .NET Server family
Assembly: VFPToolkit (in VFPToolkitNET.dll)
See Also
VFPToolkit.vfpData Members | VFPToolkit Namespace
................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related download
- introduction lexisnexis
- java database connectivity
- sharing the database connection among java server pages
- sqlstringconnect method
- cs433 fall 2002 setup guide university of wisconsin
- jdbc wright state university
- database connection string to mysql database on a
- sql azure tips and tricks johns hopkins university
- introduction to sql azure
Related searches
- method of teaching in education
- baking soda method for drug test meth
- certo method instructions
- why is scientific method important
- examples of method of analysis
- effective interest method calculator
- effective interest rate method example
- best payment method for selling a car
- p value method formula
- race method for answering questions
- method study steps
- constant yield method excel