效果图
![在这里插入图片描述](https://i-blog.csdnimg.cn/direct/859f98902a924df0938650890f5ef99e.gif#pic_center)
新建数据表
CREATE TABLE huiyuan (
id INT IDENTITY(1,1) PRIMARY KEY,
name NVARCHAR(50) NOT NULL,
rank NVARCHAR(10) NOT NULL,
reward INT,
goldcoin INT
);
INSERT INTO huiyuan (name, rank, reward, goldcoin) VALUES ('张三', '铜牌', 100, 500);
INSERT INTO huiyuan (name, rank, reward, goldcoin) VALUES ('李四', '银牌', 200, 1000);
INSERT INTO huiyuan (name, rank, reward, goldcoin) VALUES ('王五', '金牌', 300, 1500);
INSERT INTO huiyuan (name, rank, reward, goldcoin) VALUES ('赵六', '钻石', 500, 5000);
INSERT INTO huiyuan (name, rank, reward, goldcoin) VALUES ('孙七', '新手', 0, 100);
展示数据
![在这里插入图片描述](https://i-blog.csdnimg.cn/direct/75dbe415541e43e68ebf6de09827c2c3.png)
插入数据
![在这里插入图片描述](https://i-blog.csdnimg.cn/direct/9caf833f803c4fb28598c7c6a9d76d21.png)
{点击添加按钮,添加数据后立即展示}
procedure TForm1.btn1Click(Sender: TObject);
begin
qry2.close;
qry2.Parameters.ParamByName('name').value:=edt1.text;
qry2.Parameters.ParamByName('rank').value:=edt2.text;
qry2.Parameters.ParamByName('reward').value:=strtoint(edt3.text);
qry2.Parameters.ParamByName('goldcoin').value:=strtoint(edt4.text);
qry2.ExecSQL;
qry1.Close;
qry1.Open;
end;
完整项目代码
Delphi5+SqlServer+添加操作