01.
sql =
"select max(Member_Finger) from Member"
;
02.
com =
new
SqlCommand(sql, Conn);
03.
getRecord = Convert.ToInt32(com.ExecuteScalar());
04.
05.
for
(
int
i = 1; i <= getRecord; i++)
06.
{
07.
sql =
"select count(Member_Finger) from Member where Member_Finger="
+i;
08.
com =
new
SqlCommand(sql, Conn);
09.
tempid = Convert.ToInt32(com.ExecuteScalar()) ;
10.
if
(tempid == 0)
11.
{
12.
tempid = i;
13.
break
;
14.
}
15.
}
16.
17.
if
(tempid == getRecord)
18.
{
19.
NewID = getRecord + 1;
20.
textBox1.Text = NewID.ToString();
21.
}
22.
else
23.
{
24.
NewID = tempid;
25.
textBox1.Text = NewID.ToString();
26.
}