Mehmet Ali Akbaba'ya bu paketten beni haberdar ettigi icin tesekkur ederim bu tip ihtiyaci olanlar icin burada anlatmak istedim.
Public bir library olan VFP Toolkit for .Net C# ta olmayan VFP komut,fonksiyonlarin implemente edilmis library si .
setup edip kullanilacak projede reference lere eklemek gerekiyor.
http://foxcentral.net/microsoft/VFPToolkitNET.htm
nelermi var ?
-Array
aCopy()
aDel()
aDir()
aFont()
aLns()
aLen()
aLines()
aPrinters()
aScan()
aSort()
-common
between()
cpConvert()
cpCurrent()
empty()
getPem()
inlist()
isBlank()
isnull()
keyboard()
nvl()
parameters()
pcount()
rgb()
type()
vartype()
-date
cdow()
cmonth()
ctod()
ctot()
date()
datetime()
day()
dmy()
dow()
....
ttoc()
week()
year()
- dialogs
getdir()
getcolor()
getfile()
getfont()
getpict()
getprinter()
locfile()
messagebox()
putfile()
-environment
getenv()
os()
sys()
sysmetric()
version()
_cliptext
_dblclick
- file class
addbs()
curdir()
directory()
file()
fullpath()
justpath()
justfname()
....
- help
do()
dodefault()
iif()
_newobject()
_screen
- math classes
min()
max()
abs()
...
-string classes
atc()
at()
chr()
chrtran()
createbinary()
filetostr()
left()
len()
lower()
ltrim()
padl()
padc()
padr()
proper()
rat()
rtrim()
space()
strexract()
strtofile()
strtran()
stuff()
substring()
val()
-vfp data classes
alias()
appendblank()
bof()
browse()
count()
cursortoxml()
curval()
delete()
deleteall()
deleted()
deletefor()
descendig()
eof()
fcount()
field()
filter()
found()
indexseek()
lookup()
order()
seek()
select()
setfilterto()
setorderto()
sqlconnect()
sqldisconnect()
sqlexecute()
sqlstringconnect()
xmltocursor()
gercekten isi kolaylastiracak komutlar....
hele surasi cok hosuma gitti
C#
[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();