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.

Google Online Preview   Download