資源簡介
LabWindows/cvi數據庫連接方式,使用CVI的人可以參考。

代碼片段和文件信息
#include?“adox.h“
#include?“tckgrid.h“
#include?
#include?
#include?
#include?
#include?
#include?“424.h“
static?int?panelHandle;
double?sine[512]sinedb[512];
static?CAObjHandle?objhandle;
static?CAObjHandle?gridobjhandle;
static?ERRORINFO?errinfo;
static?HRESULT?status;
static?VARIANT?source;
static?VARIANT?activeconnecting;
static?char*?recordstr;
static?VARIANT?aff;
static?ADODBObj__Recordset?recordset;
char?buff[512]buff2[512];
static?ADODBObj_Fields?data1num;
//BSTR?buffbuff1;
//BSTR?bstr1bstr2;
//const?char?DATA[50]DATA1[50];
int?main?(int?argc?char?*argv[])
{
if?(InitCVIRTE?(0?argv?0)?==?0)
return?-1; /*?out?of?memory?*/
if?((panelHandle?=?LoadPanel?(0?“424.uir“?PANEL))?0)
return?-1;
DisplayPanel?(panelHandle);
RunUserInterface?();?
?
DiscardPanel?(panelHandle);
return?0;
}
int?CVICALLBACK?close?(int?panel?int?event?void?*callbackData
int?eventData1?int?eventData2)
{
switch?(event)
{
case?EVENT_CLOSE:
???QuitUserInterface?(0);?
break;
}
return?0;
}
int?CVICALLBACK?ok?(int?panel?int?control?int?event
void?*callbackData?int?eventData1?int?eventData2)
{
int?i;
switch?(event)
{
case?EVENT_COMMIT:
???SinePattern(5124.00.05.0sine);
???ADODB_New_Connection?(NULL?1?LOCALE_NEUTRAL?0?&objhandle);
???
??status?=?ADODB__ConnectionOpen?(objhandle?NULL?“DSN=mydb1“?““?““?-1);
??????if(status>=0)
??{
????MessagePopup?(“提示“?“成功!!“);?
??}
???
??else
??{
????MessagePopup?(“提示“?“失敗!!“);
??}
??
//----------------------------------------------------------------------------------??
???
//SQL命令方法(connection對象法)
ADODB__ConnectionExecute?(objhandle?NULL?“CREATE?TABLE?sample2(ID?DOUBLEDATA?DOUBLEDATA1?DOUBLEDATA2?DOUBLE)“?&aff?-1?&recordset);
??for(i=0;i<512;i++)?
??{
???sprintf(buff“insert?into?sample2?VALUES(%i%f%f)“isine[i]sine[i]);
?
??ADODB__ConnectionExecute?(objhandle?NULL?buff?&aff?-1?&recordset);
???}?
??????for(i=0;i<512;i++)
??{ ??
??sprintf(buff2“select?DATA?from?sample?VALUES(%f)“sine[i]);?
??????????ADODB__ConnectionExecute?(objhandle?NULL?buff2?&aff?-1?&recordset);?
??Scan?(buff2?“%s>%s[dt#]%f“?&sinedb[i]);?
??}
??????PlotWaveform?(panelHandle?PANEL_GRAPH?sinedb?512?VAL_DOUBLE?1.0?0.0?0.0?1.0?VAL_THIN_LINE?VAL_EMPTY_SQUARE
VAL_SOLID?1?VAL_RED);
??
??
??
??
??ADODB__ConnectionClose?(objhandle?NULL);??
?//---------------------------------------------------------------------------------
??//MSFlexGridLib_IMSFlexGridSetText?(gridobjhandle0?“表格韓國“);?
????????//?MSFlexGridLib_NewIMSFlexGrid?(panelHandle“當時的繁華的“?0?1PANEL_MSFLEXGRID0);??
??
?
?//Recordset對象法
/* ?ADODB__ConnectionExecute?(objhandle?NULL?“CREATE?TABLE?sample(DATA?DOUBLEDATA1?DOUBLE)“?&aff?-1?&recordset);?
?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????文件?????562688??2008-05-15?09:18??dboperator\424_dbg.exe
?????文件????2889727??2008-05-15?09:18??dboperator\424_dbg.cdb
?????文件????1761280??2008-05-15?09:24??dboperator\mydb.mdb
?????文件????1590376??2008-04-24?21:13??dboperator\adox.fp
?????文件????????207??2008-04-24?21:13??dboperator\adox.sub
?????文件????1047388??2008-04-24?21:13??dboperator\adox.c
?????文件?????194988??2008-04-24?21:13??dboperator\adox.h
?????文件?????412594??2008-04-24?21:13??dboperator\adox.obj
?????文件????1206784??2008-04-25?11:14??dboperator\sql語句.doc
?????文件?????????79??2008-04-25?15:25??dboperator\說明.txt
?????文件?????508660??2008-05-06?14:23??dboperator\tckgrid.fp
?????文件????????209??2008-05-06?14:23??dboperator\tckgrid.sub
?????文件?????315117??2008-05-06?14:23??dboperator\tckgrid.c
?????文件??????75871??2008-05-06?14:23??dboperator\tckgrid.h
?????文件?????127204??2008-05-06?14:23??dboperator\tckgrid.obj
?????文件?????508660??2008-05-06?14:26??dboperator\MSFLXGRD.fp
?????文件????????209??2008-05-06?14:26??dboperator\MSFLXGRD.sub
?????文件?????315118??2008-05-06?14:26??dboperator\MSFLXGRD.c
?????文件??????75871??2008-05-06?14:26??dboperator\MSFLXGRD.h
?????文件?????127204??2008-05-06?14:26??dboperator\MSFLXGRD.obj
?????文件???????3759??2008-05-06?14:46??dboperator\424.prj
?????文件???????6720??2008-05-06?14:59??dboperator\424.uir
?????文件???????1485??2008-05-06?14:59??dboperator\424.h
?????文件???????4754??2008-05-15?09:18??dboperator\424.c
?????文件???????5495??2008-05-15?09:23??dboperator\424.cws
?????目錄??????????0??2008-05-27?11:35??dboperator
-----------?---------??----------?-----??----
?????????????11742665????????????????????27
評論
共有 條評論