If Data Exist

Question

User-1031608939 posted

Hi,

For MS Access, how to check if the particular field data exist?

Thanks.

Regards,

ling

Answer 1

User1949625403 posted

hi check this post here i explained how to check particular field data exists or not

http://aspdotnet-suresh.blogspot.com/2010/10/introduction-here-i-will-explain-how-to.html

Answer 2

User-1199946673 posted

I'm not sure exactly waht you mean? But waht about:

(SELECT COUNT(*) FROM [tablename] WHERE .....) > 0

This will return True if the data exist and false if no records are found...

Answer 3

User-1199946673 posted

hi check this post here i explained how to check particular field data exists or not

http://aspdotnet-suresh.blogspot.com/2010/10/introduction-here-i-will-explain-how-to.html

He's using ACCESS!!!!!

Answer 4

User3866881 posted

Try something like this:

using(OleDbCommand cmd = new OleDbCommand("SELECT COUNT(*) FROM [tablename] WHERE .....",new OleDbConnection("……"))

{

   int number = Convert.ToInt(cmd.ExecuteScaler());

   if(number>0)

   {

          //Do what you want……

   }

}