DBGrid数据源:TADOQuery,怎样让DBGrid的数据,随TADOQuery的改变而改变? DBGrid数据源:TADOQuery,怎样让DBGrid的数据,随TADOQuery的改变而改变? 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 ADOQuery.Close;ADOquery.Open; DBGrid1.DataSource.DataSet.Close;DBGrid1.DataSource.DataSet.open; procedure TForm1.ServerClientConnect(Sender: TObject; Socket: TCustomWinSocket);Var strIp,strHost,sq:string; Count:Integer;begin strIp:=Socket.RemoteAddress; strHost:=Socket.RemoteHost; Memo1.Lines.Add('当前登录用户'); Memo1.Lines.add(#9'SocketID:'+Inttostr(Socket.SocketHandle)); Combox1.Items.Add(Inttostr(Socket.SocketHandle)); Memo1.lines.add(#9'IP地址:'+strIp); Memo1.Lines.Add(#9'主机名:'+strHost); ADOQ.SQL.Clear; ADOQ.SQL.Add('INSERT into CurUser values('+''''+'gf'+''''+',000001,'+''''+strIp+''''+','+'"0",'+'"0",'+'False,'+'False,'+'"'+Inttostr(Socket.SocketHandle)+'")'); ADOQ.ExecSQL; // dBGrid.refresh; Count:=Server.Socket.ActiveConnections; Statusbar1.Panels.Items[1].Text:='在线用户: '+IntToStr(Count);end;procedure TForm1.ServerClientDisconnect(Sender: TObject; Socket: TCustomWinSocket);Var Count:Integer; IDIndex:Integer;begin Memo1.Lines.add('用户离线'); Memo1.Lines.add(' SocketID:'+Inttostr(Socket.SocketHandle)); IDIndex:=Combox1.Items.IndexOf( Inttostr(Socket.SocketHandle)); Combox1.Items.Delete(IDIndex); // Memo1.Lines.add('delete from CurUser where SktID='+Inttostr(Socket.SocketHandle)+' )'); Adoq.Close; adoq.SQL.Clear; adoq.SQL.Add('delete from CurUser where SktID='+Inttostr(Socket.SocketHandle)); Adoq.ExecSQL; //该事件在用户离开前发生 Count:=Server.Socket.ActiveConnections-1; Statusbar1.Panels.Items[1].Text:='在线用户:'+Inttostr(Count);end;以上方法都试过,不幸... delphi 7 +spcomm 通讯问题 再次请教关于fastrepot的问题 设置了权限只能打开两按钮之一,但怎么两个都能用了~~?? 关于报表QRDBText1.DataField:=??? midas三层急,在线等待!! 有谁可以告诉我中国互动游戏中心那样的!程序是如何实现的! 不同分辨率下的界面? ado程序无法在win98第一版下运行,有没有解决办法?高手请进 100分!求XLGrid1.7源代码,提供线索也可 如何在一个NT的Service中封装一个RemoteDataModule? 放分最爽了 DBGrid 小问题???
ADOquery.Open;
DBGrid1.DataSource.DataSet.open;
Socket: TCustomWinSocket);
Var
strIp,strHost,sq:string;
Count:Integer;
begin
strIp:=Socket.RemoteAddress;
strHost:=Socket.RemoteHost;
Memo1.Lines.Add('当前登录用户');
Memo1.Lines.add(#9'SocketID:'+Inttostr(Socket.SocketHandle));
Combox1.Items.Add(Inttostr(Socket.SocketHandle));
Memo1.lines.add(#9'IP地址:'+strIp);
Memo1.Lines.Add(#9'主机名:'+strHost);
ADOQ.SQL.Clear;
ADOQ.SQL.Add('INSERT into CurUser values('+''''+'gf'+''''+',000001,'+''''+strIp+''''+','+'"0",'+'"0",'+'False,'+'False,'+'"'+Inttostr(Socket.SocketHandle)+'")');
ADOQ.ExecSQL;
// dBGrid.refresh;
Count:=Server.Socket.ActiveConnections;
Statusbar1.Panels.Items[1].Text:='在线用户: '+IntToStr(Count);
end;
procedure TForm1.ServerClientDisconnect(Sender: TObject;
Socket: TCustomWinSocket);
Var
Count:Integer;
IDIndex:Integer;
begin
Memo1.Lines.add('用户离线');
Memo1.Lines.add(' SocketID:'+Inttostr(Socket.SocketHandle));
IDIndex:=Combox1.Items.IndexOf( Inttostr(Socket.SocketHandle));
Combox1.Items.Delete(IDIndex);
// Memo1.Lines.add('delete from CurUser where SktID='+Inttostr(Socket.SocketHandle)+' )');
Adoq.Close;
adoq.SQL.Clear;
adoq.SQL.Add('delete from CurUser where SktID='+Inttostr(Socket.SocketHandle));
Adoq.ExecSQL;
//该事件在用户离开前发生
Count:=Server.Socket.ActiveConnections-1;
Statusbar1.Panels.Items[1].Text:='在线用户:'+Inttostr(Count);
end;
以上方法都试过,不幸...