Hi,

I;m trying to create a series of 4 random 8 digit numbers, checking to see they haven't already been created and then insert them into a database.

While I'm ok creating the numbers I'm having difficulty checking them against the values already in the database can anyone give me a few tips?

Cheers

Mike

how are u checking it in the database??

Regards
Ganesh

I'll suppose that you use SQL Server or Access database,
you can check the occurences of the value using the SELECT command,
for example:-

commandString = "SELECT num from numTable where num = '" + myNum
      + "'";
and then check the number of rows in the resulting dataTable.

You must know first how to connect to a database and make queries.

Hope that helps :)