create Table NewUserInfo(
UserId int Identity(1,1) Primary key,
UserNumber Varchar(30) Null,
UserType varchar(20) Null,
UserName Varchar(30) Null,
Unit Varchar(30) Null,
Area Varchar(60) Null,
Address Varchar(60) Null,
AddressNumber Varchar(30) Null,
LightNode Varchar(50) Null,
BindDate datetime Null,
IdCard Varchar(25) Null,
PostCode char(8) Null,
Phone1 Varchar(20) Null,
Phone2 Varchar(20) Null
)
在delphi里面实现与SQL数据库的连接,在SQL显示上面这张表,用语句实现请各位大虾赐教,小弟先谢过!
UserId int Identity(1,1) Primary key,
UserNumber Varchar(30) Null,
UserType varchar(20) Null,
UserName Varchar(30) Null,
Unit Varchar(30) Null,
Area Varchar(60) Null,
Address Varchar(60) Null,
AddressNumber Varchar(30) Null,
LightNode Varchar(50) Null,
BindDate datetime Null,
IdCard Varchar(25) Null,
PostCode char(8) Null,
Phone1 Varchar(20) Null,
Phone2 Varchar(20) Null
)
在delphi里面实现与SQL数据库的连接,在SQL显示上面这张表,用语句实现请各位大虾赐教,小弟先谢过!
AdoTable.Connection:=AdoConnection;
DataSource.DataSet:=AdoTable;
DBGrid.DataSource:=DataSource;在AdoTable.TableName设置好要连接的数据表
with form1.Query1 do
begin
close;
sql.Clear;
sql.add('select * from NewUserInfo');
open;
再把Tquery1连一个Datasourse,一个DBgrid就ok!