procedure TForm1.FormCreate(Sender: TObject);
var
sqlstr:string;
begin
if not mHDCon.Connected then begin
try
mHDCon.Open;
except
ShowMessage('连接数据库失败');
close;
exit;
end;
end; mADOQueryHDLIST.Close;
mADOQueryHDLIST.SQL.Clear;
sqlstr:='select * from spirit_patient t'; mADOQueryHDLIST.SQL.Text:=sqlstr;
mADOQueryHDLIST.Open;
InitDBGrid(mDBGrid);
if mADOQueryHDLIST.RecordCount=0 then exit;
end;function TForm1.InitDBGrid(dbgrid: TDBGrid): boolean;
procedure SetColumn(FieldName,Title:string;Width:integer;Alignment:TAlignment;TitleAlignment:TAlignment);
var
AddColumn: TColumn;
begin
AddColumn:=dbgrid.Columns.Add;
AddColumn.FieldName:=FieldName;
AddColumn.Title.Caption:=Title;
AddColumn.Width:= Width;
AddColumn.Grid.BiDiMode:=BiDiMode;
AddColumn.Alignment:=Alignment ;
AddColumn.Title.Alignment:=TitleAlignment ;
end;
begin
dbgrid.Columns.Clear;
SetColumn('PATIENT_ID','诊疗号',85,taCenter,taCenter);
SetColumn('HIS_PATIENT_ID','住院号',130,taCenter,taCenter);
SetColumn('NAME','姓名',70,taCenter,taCenter);
SetColumn('GENDER','性别',45,taCenter,taCenter);
end;InitDBGrid的方法没有实现,但是调用了。SetColumn的方法实现了,但是没有调用。 数据能出来是怎么回事?
var
sqlstr:string;
begin
if not mHDCon.Connected then begin
try
mHDCon.Open;
except
ShowMessage('连接数据库失败');
close;
exit;
end;
end; mADOQueryHDLIST.Close;
mADOQueryHDLIST.SQL.Clear;
sqlstr:='select * from spirit_patient t'; mADOQueryHDLIST.SQL.Text:=sqlstr;
mADOQueryHDLIST.Open;
InitDBGrid(mDBGrid);
if mADOQueryHDLIST.RecordCount=0 then exit;
end;function TForm1.InitDBGrid(dbgrid: TDBGrid): boolean;
procedure SetColumn(FieldName,Title:string;Width:integer;Alignment:TAlignment;TitleAlignment:TAlignment);
var
AddColumn: TColumn;
begin
AddColumn:=dbgrid.Columns.Add;
AddColumn.FieldName:=FieldName;
AddColumn.Title.Caption:=Title;
AddColumn.Width:= Width;
AddColumn.Grid.BiDiMode:=BiDiMode;
AddColumn.Alignment:=Alignment ;
AddColumn.Title.Alignment:=TitleAlignment ;
end;
begin
dbgrid.Columns.Clear;
SetColumn('PATIENT_ID','诊疗号',85,taCenter,taCenter);
SetColumn('HIS_PATIENT_ID','住院号',130,taCenter,taCenter);
SetColumn('NAME','姓名',70,taCenter,taCenter);
SetColumn('GENDER','性别',45,taCenter,taCenter);
end;InitDBGrid的方法没有实现,但是调用了。SetColumn的方法实现了,但是没有调用。 数据能出来是怎么回事?
begin
dbgrid.Columns.Clear;
SetColumn('PATIENT_ID','诊疗号',85,taCenter,taCenter);
SetColumn('HIS_PATIENT_ID','住院号',130,taCenter,taCenter);
SetColumn('NAME','姓名',70,taCenter,taCenter);
SetColumn('GENDER','性别',45,taCenter,taCenter);
end;
procedure SetColumn
var
AddColumn: TColumn;
begin
AddColumn:=dbgrid.Columns.Add;
........ end;
begin
......end;
var
a:integer;
//----------
procedure oneProc(m:integer);
var
b:integer;
beginend;
//----------
beginend;