如何刷新gridview只有在sql sever表中插入的新记录 [英] how to refresh gridview with only new record inserted in sql sever table

问题描述

嗨所有下午好，



i有一个gridview，它已经从sql server充满了记录，

但是如果在sql中服务器的表有任何新记录条目已完成比我想要

填写它在gridview中没有刷新已经存在的记录。



简而言之，我想填写那些不存在于已存在记录中的记录或其表中的新条目。

hi All Good Afternoon,

i have one gridview which is allready fill with the record from sql server,
But if in sql server's table have anything new record entry is done than i want to
fill it in gridview without refresh allready exist record.

In short, I want to fill those record which are not in allready exist record or its new entry in table.

推荐答案

轻松获取网格的最后一个ID并写入Select * from表1其中TableId> SuppliedId;

然后通过循环填充

easy get the last id of grid and write "Select * from Table1 where TableId>SuppliedId";
and then fill it through looping

这篇关于如何刷新gridview只有在sql sever表中插入的新记录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！