public static bool ExistInTable(string TableName, string Criteria)
{
CLSDataAccess dataaAccess = new CLSDataAccess();
if (dataaAccess.GetSQLDataSetByQuery("SELECT * FROM " + TableName + " WHERE " + Criteria).Tables[0].Rows.Count > 0)
{
return(true);
}
else
{
return(false);
}
}
public static bool HasRows(string TableName)
{
CLSDataAccess dataaAccess = new CLSDataAccess();
if (dataaAccess.GetSQLDataSetByQuery("SELECT * FROM " + TableName).Tables[0].Rows.Count > 0)
{
return(true);
}
else
{
return(false);
}
}
public static bool ExistInTable(string TableName, string CulumnToSearch, string SearchValue)
{
CLSDataAccess dataaAccess = new CLSDataAccess();
if (dataaAccess.GetSQLDataSetByQuery("SELECT * FROM " + TableName + " WHERE " + CulumnToSearch + " = " + SearchValue).Tables[0].Rows.Count > 0)
{
return(true);
}
else
{
return(false);
}
}
